How to check the capacity size of database tables in MySQL

MySQL how to view the capacity of the database table size, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

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

two。 View the capacity size of each table in 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 size

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 capacity size of each table in 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'

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.