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%'; |
MySQL >
MySQL >
Basic maintenance commands
|