MySQL - Process Management

Monitor queries:

sudo apt-get install mytop
mytop -u user -ppassword

Monitor queries another way:

SHOW FULL PROCESSLIST;

Check database size:

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

Process management:

Mysql> Kill (id);
mysqladmin -u debian-sys-maint processlist -p