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 |
||
| 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). | ||
Revision as of 21:30, 2 October 2013
- 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.0/en/server-parameters.html