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%';