Folks from MariaDB wrote this article in which they collated 10 MySQL tuning tips for peak workloads. As we head into the holiday season and the start of a new year, now is a great time to ensure your database is ready for whatever comes its way.
Some advice in this article:
- InnoDB buffer pool size
- InnoDB log file size
- InnoDB log buffer size
- InnoDB log flush interval
- Thread cache size
- Temporary tables, tmp_table_size, and max_heap_table_size
… for the rest of information please read full article linked here. We also recommend watching the on-demand webinar on Readying Databases for Anything by MariaDB. Great advice!
[Read More]