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 |
Remove "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"ONLY_FULL_GROUP_BY" from this setting |
|
|
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.
|
| 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. |
