View source for Monitoring and Tuning MySQL

<includeonly>==== Monitoring and Tuning MySQL ====</includeonly>
* Running on a 64-bit machine, there should be plenty of memory.
* 20G of memory or more should be allocated to MySQL (highly recommended).
* Allocate a good amount of memory to <tt>innodb_buffer_pool_size</tt> - the combined cached for data and the index.
* TimeOuts
: interactive_timeout, wait_timeout,innodb_lock_wait_timeout.
* Number of file descriptors (number of files that MySQL can have open)
: Open_files_limit. 
: ''Also:'' Check that you have a sufficient number of file descriptors available in the OS.
* To monitor the number of active threads, live threads, and open threads:
: <tt>show processlist</tt> or <tt>show full processlist</tt>
* After modifying tuning parameters in <tt>my.cnf</tt>, always restart mysql.

''Learn More:'' http://dev.mysql.com/doc/refman/{{MySqlVersion}}/en/server-parameters.html
<noinclude>

[[Category:Installation]]
</noinclude>