Difference between revisions of "Monitoring and Tuning MySQL"
From AgileApps Support Wiki
imported>Aeric m (Text replace - 'Category:System Administration' to 'Category:Installation') |
imported>Aeric |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
==== Monitoring and Tuning MySQL ==== | <includeonly>==== Monitoring and Tuning MySQL ====</includeonly> | ||
* Running on a 64-bit machine, there should be plenty of memory. | * Running on a 64-bit machine, there should be plenty of memory. | ||
* 20G of memory or more should be allocated to MySQL (highly recommended). | * 20G of memory or more should be allocated to MySQL (highly recommended). | ||
| Line 12: | Line 12: | ||
* After modifying tuning parameters in <tt>my.cnf</tt>, always restart mysql. | * After modifying tuning parameters in <tt>my.cnf</tt>, always restart mysql. | ||
''Learn More:'' http://dev.mysql.com/doc/refman/ | ''Learn More:'' http://dev.mysql.com/doc/refman/{{MySqlVersion}}/en/server-parameters.html | ||
<noinclude> | |||
[[Category:Installation]] | [[Category:Installation]] | ||
</noinclude> | |||
Latest revision as of 02:31, 19 March 2014
- 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 innodb_buffer_pool_size - 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:
- show processlist or show full processlist
- After modifying tuning parameters in my.cnf, always restart mysql.
Learn More: http://dev.mysql.com/doc/refman/5.5/en/server-parameters.html