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

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]+)$')
#размер бд на сервере
SELECT database_name, SUM(size) FROM(
SELECT table_schema AS database_name, TABLE_NAME, ( data_length + index_length )/1024/1024 AS size
FROM information_schema. TABLES
WHERE TABLE_SCHEMA LIKE "ar%"
GROUP BY TABLE_SCHEMA
) AS s
GROUP BY database_name
;