How to check the capacity size of database tables in MySQL

Today, I will talk to you about how to check the capacity of the database table in MySQL. Many people may not know much about it. In order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article.

1. View all database capacity sizes

SELECT table_schema AS 'database', sum (table_rows) AS 'records', sum (TRUNCATE (data_length / 1024 / 1024, 2)) AS 'data capacity (MB), sum (TRUNCATE (index_length / 1024 / 1024, 2)) AS' index capacity (MB) 'FROM information_schema.TABLES GROUP BY table_schema ORDER BY sum (data_length) DESC, sum (index_length) DESC

2. View the table capacity of all databases SELECT table_schema AS 'database', table_name AS 'table name', table_rows AS 'records', TRUNCATE (data_length / 1024 / 1024, 2) AS 'data capacity (MB)', TRUNCATE (index_length / 1024 / 1024, 2) AS 'index capacity (MB)' FROM information_schema.TABLES ORDER BY data_length DESC, index_length DESC

3. View the specified database capacity SELECT table_schema AS 'database', sum (table_rows) AS 'records', sum (TRUNCATE (data_length / 1024 / 1024, 2)) AS 'data capacity (MB), sum (TRUNCATE (index_length / 1024 / 1024, 2)) AS' index capacity (MB) 'FROM information_schema.TABLES WHERE table_schema =' mysql''

4. View the table capacity of the specified database: SELECT table_schema AS 'database', table_name AS 'table name', table_rows AS 'records', TRUNCATE (data_length / 1024 / 1024, 2) AS 'data capacity (MB)', TRUNCATE (index_length / 1024 / 1024, 2) AS 'index capacity (MB)' FROM information_schema.TABLES WHERE table_schema = 'mysql' ORDER BY data_length DESC Index_length DESC [object Object] after reading the above, do you have any further understanding of how to view the capacity size of database tables in MySQL? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.