Mysql Database performance issue

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,

1 Like