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

  1. log slow queries;

log_slow_queries = 1


  1. to check and summarise permissions from the command line


  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

Ad blocker interference detected!

Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.