# Mysql Database performance issue

**URL:** <https://forums.percona.com/t/mysql-database-performance-issue/12736>\
**Category:** Other MySQL® Questions\
**Tags:** mysql, closed-no-reply\
**Created:** [October 26, 2021, 3:13am UTC](https://forums.percona.com/t/mysql-database-performance-issue/12736 "2021-10-26T03:13:29Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![pkelaska](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pkelaska/32/4868_2.png) [@pkelaska](https://forums.percona.com/u/pkelaska)\
**Post date:** [October 26, 2021, 3:13am UTC](https://forums.percona.com/t/mysql-database-performance-issue/12736/1 "2021-10-26T03:13:29Z")

</div>

Hello Team ,

Hello,

A month ago (on September 28th), we migrated an application to AWS.  
Our previous environment was run with a MySQL 5.6 database.

We have several database issues on which we would like your support:

1. Much longer insertion time in MyISAM tables  
(see attachment saturn-prd-myisam-insertion-comparison.png)  
What optimization could we operate on the system variables? (buffer size, etc.)  
The documentation seems to suggest that disabling sync\_binlog could improve this insertion time.  
What is the risk of passing sync\_binlog to 0 on a system where we use both MyISAM and InnoDB?

2. Increase in the number of deadlocks  
What settings would allow us to reduce the number of deadlocks?  
We know that there would be code improvements to be made but they are not easy / quick to do (they are located in the framework’s core that we use), but we would like to obtain support on parameter tuning on the server side, that would still allow us to improve the situation.

3. Schema performance detailed stats  
We already have Performance Insights enabled.  
But in order to gain a better understanding of indexes usage on the various tables of our databases :

- how to activate the detailed stats of the schema performance?
- how to access usage statistics such as for example  
performance\_schema.table\_io\_waits\_summary\_by\_table  
performance\_schema.table\_io\_waits\_summary\_by\_index\_usage ?

Thanks you in advance for your help.

Best regards,