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/

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.