MySQL‎ > ‎

Basic maintenance commands

To see table sizes in a database:

show table status from yourdatabasename;

To optimize a table:

Optimize table yourtablename

show status where `variable_name` = 'Threads_connected';

SHOW PROCESSLIST;

show status LIKE '%onn%';
Comments