MySQL

Show Databases

mysql> show databases;

Show Status/variables

mysql> show status;

mysql> show variables;

$ mysqladmin variables

$ mysqladmin processlist extended-status -i5

Delete database

mysql> drop database vanilla_db;

Change default mysql database location.

 /etc/my.cnf

Backup

mysqldump -u root -p my_db > my_db.sql

Restore

mysql -p -u root  my_db < my_db.sql

QCache and exam qcache_lowmem_prunes

show  status like "ques%";

show  status like "qcache%";