# MySQL performance improvement

MySQL 5.7 and 5.6 performance improvement

By Default MySQL performs a flush operation per commit which is inoffensive on not demanding environments but on medium and high demanding environment, it could induce to I/O Bottleneck issues, even when the storage could be a SSD or a most sophisticated storage solution like a raid.

<span id="bkmrk--1"></span>

# AWS Database instances

For AWS MySQL Databases create a new parameter group based on the version that is running

Parameters Groups → Create Parameter Group

Finally on **Instances** choose the MySQL Database to use for UTP and **modify** it, assigning it the new parameter group and reboot the database.

<span id="bkmrk--3"></span>

# Local databases

For local database parameters setup, just add these parameter to my\*.ini configuration files on windows environment and my.cnf on Linux distros, procedure could be different depending on platform and MySQL version and release.

In windows the my.ini could be here

C:\\ProgramData\\MySQL\\MySQL Server 5.6 or here

C:\\ProgramData\\MySQL\\MySQL Server 5.7

It is not located here

C:\\Program Files\\MySQL\\MySQL Server 5.6\\my-default.ini. This is just a basic template

<span id="bkmrk--5"></span><span id="bkmrk--6"></span>

#### Parameters

set the following values, take care could be exceptions depending on the exact MySQL version, but in any case, this is intended only for 5.6 and 5.7 versions.

lower\_case\_table\_names=2 #Windows

max\_allowed\_packet=524288000

<div id="bkmrk-last-updated%3A-june-0">---

Last updated: <span class="mc-variable General.NewDateTimeVariable variable">June 02, 2023</span>

If you have any feedback on this topic, please contact us at <documentation@appvance.ai>

</div>