MySQL tuning guide

• Overview
• Recommended MySQL Tuning for 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.