FANDOM


  1. optimising mysql performance;

http://dev.mysql.com/tech-resources/presentations/presentation-oscon2000-20000719/index.html

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


  1. log slow queries;

log_slow_queries = 1

SHOW INNODB STATUS\G;


  1. to check and summarise permissions from the command line

mysqlaccess

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


  1. change the number of max connections on the the fly;

set @@global.max_connections = 400;


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/