The following is a list of variables, parameters, or simply comments to improve a particular situation or context:
- Use innodb_flush_method=O_DIRECT to avoid a double buffer when writing.
- Setting innodb_buffer_pool_size to load the entire InnoDB data into memory can help to avoid reading from the disk.
- Do not make innodb_log_file_size too high; with faster disks, flushing often is not bad and lowers the recovery time during crashes from your server.
- Avoid mixing these two variables: innodb_thread_concurrency and thread_concurrency. This will have a better impact on MySQL performance.
- Allocate only max_connections. When we use too many connections, the impact is that MySQL will use a lot of your RAM and needlessly slow down your MySQL server.
- Keep thread_cache at a relatively high setting; a minimum of 16 should be good enough to prevent slowness when opening...
