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.

Revision #1
Created 21 June 2024 03:33:53 by ABit Software
Updated 21 June 2024 03:34:09 by ABit Software