Полезные команды MySQL

SHOW FULL PROCESSLIST

SELECT table_schema "direct", sum( data_length + index_length) / 1024 / 1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema ;

mysqldump -u monkey -p direct > /var/www/html/dump.sql

SELECT table_name AS `Table`, round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` FROM information_schema.TABLES WHERE table_schema = "direct";

Яндекс.Метрика