Show MySQL configuration settings

mysql> SHOW VARIABLES;

Show MySQL running threads

mysql > SHOW PROCESSLIST;

Check the status of the tables of a database

$ mysqlcheck -c <database>