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/1024AS size