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

 

 

 

 

 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.