Размер таблиц

Suggest a feature

Please login or create account to add a snippet.

Follow @TagMyCode

Language: PHP

Posted by: Dmitriy Lanets

Added: Mar 28, 2017 12:47 PM

Modified: Dec 7, 2018 12:17 PM

Tags: mysql

SELECT table_schema "database_name", TABLE_NAME, ( data_length + index_length )/1024/1024 "Database size in MB"
FROM information_schema. TABLES
WHERE TABLE_SCHEMA = "ar_29auto"
#GROUP BY TABLE_SCHEMA;
#или
SEL ECT ceil(sum( data_length + index_length ) /1048576) 'dbsize' FR OM information_schema.TABLES where table_schema REGEXP '.*_kapot' AND NOT (table_name REGEXP '(_temp|_copy|_del_|^upload_session_[0-9]+)$')