MySQL tuning guide
MySQL tuning guide for use with ABit Software
Overview
Tuning MySQL depends on many variables, such as server resources, database sizes, and number of connections.
The following tool can be helpful for providing suggestions.
https://github.com/pmachapman/mysqltuner
Recommended MySQL Tuning for ABit Software
It's advisable to optimize the MySQL configuration. Using MySQL workbench is recommended. Select Options File and search for option.
General
sql-mode | "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION" |
InnoDB
innodb_buffer_pool_size | This setting can be up to 80% of the machines physical memory (1000 MB should be adequate) |
Innodb_file_per_table |
MySQL will use a separate .idb file for each table, rather than share the data in one file. |
Performance
query_cache_size | Recommended value 20M |
Networking
max_allowed_packet | Recommended value 1000M. This allows larger data blobs to be inserted into the database. |
max_connections | Recommended value is 1000. Adjust this setting depending on site size. |