- General information
- Data readiness
- Calibration
- Database
- Quality Assurance
- Grid
- Infrastructure
- Offline Software
- Production
Performance and Tunning Parameters
Submitted by deph on Thu, 2006-12-07 15:43.
Under:
Below is a listing of adjustable mysql performance parameters, their descriptions and their current settings. Where applicable, the reasons and decisions that went into the current setting is provied. Also presented is the health of the parameter with the date the study was done. These parmaters should be reveiwed every six months or when the system warrents a review.
| Parameter | Setting | Definition | Mysql Default | Reasoning | Health | Last Checked | ||
|---|---|---|---|---|---|---|---|---|
| bulk_insert_buffer_size | 8388608 | |||||||
| join_buffer_size | 131072 | |||||||
| table_cache | 1024 | Increases the amount of table that can be held open | 64 | |||||
| key_buffer_size | 268435456 | amount of memory available for index buffer | 523264 | |||||
| myisam_sort_buffer_size | 67108864 | |||||||
| net_buffer_length | 16384 | |||||||
| read_buffer_size | 1044480 | |||||||
| read_rnd_buffer_size | 262144 | |||||||
| sort_buffer_size | 1048568 | Each thread that needs to do a sort allocates a buffer of this size. Increasing the variable gives faster ORDER BY or GROUP BY operations |
