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. |