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

![](https://wiki.abitsystems.com.au/uploads/images/gallery/2024-06/5XtDpxJwjjF5IKEH-embedded-image-rqxlpqej.png)

### General

<table border="1" id="bkmrk-sql-mode-%22strict_tra"><colgroup><col></col><col></col></colgroup><tbody><tr><td>sql-mode</td><td>"STRICT\_TRANS\_TABLES,NO\_ZERO\_IN\_DATE,NO\_ZERO\_DATE,ERROR\_FOR\_DIVISION\_BY\_ZERO,NO\_ENGINE\_SUBSTITUTION"</td></tr><tr><td>  
</td><td>  
</td></tr></tbody></table>

### InnoDB

<table border="1" id="bkmrk-innodb_buffer_pool_s"><colgroup><col></col><col></col></colgroup><tbody><tr><td>innodb\_buffer\_pool\_size</td><td>This setting can be up to 80% of the machines physical memory (1000 MB should be adequate)</td></tr><tr><td>Innodb\_file\_per\_table</td><td valign="top" width="413">MySQL will use a separate .idb file for each table, rather than share the data in one file.

</td></tr></tbody></table>

### Performance

<table border="1" id="bkmrk-query_cache_size-rec"><colgroup><col></col><col></col></colgroup><tbody><tr><td>query\_cache\_size</td><td>Recommended value 20M</td></tr><tr><td>  
</td><td>  
</td></tr></tbody></table>

### Networking

<table border="1" id="bkmrk-max_allowed_packet-r"><colgroup><col></col><col></col></colgroup><tbody><tr><td>max\_allowed\_packet</td><td>Recommended value 1000M. This allows larger data blobs to be inserted into the database.</td></tr><tr><td>max\_connections</td><td>Recommended value is 1000. Adjust this setting depending on site size.</td></tr></tbody></table>