MySQL Cheat Sheet

http://dev.mysql.com/tech-resources/presentations/presentation-oscon2000-20000719/index.html
 * 1) optimising mysql performance;

to see locks on tables and objects - do >mysqladmin debug and view the output in the msyqld.log file in /var/log/mysqld.log

log_slow_queries = 1
 * 1) log slow queries;

SHOW INNODB STATUS\G;

mysqlaccess
 * 1) to check and summarise permissions from the command line

http://dev.mysql.com/doc/refman/5.0/en/mysql-find-rows.html

set @@global.max_connections = 400;
 * 1) change the number of max connections on the the fly;

how to enable the mysql log in 5.0 http://www.mysqlperformanceblog.com/2007/09/13/enablingdisabling-query-log-without-server-restart-in-mysql-50/