Migrating SQL Server to MySQL Heatwave Service

Check MySQL InnoDB Settings using MySQL Shell Utility

 Check and review recommended MySQL InnoDB setting using MySQL Shell for optimal Performance. 

Performance of MySQL is always top priority for each organisations because data holds valuable insight into organizational productivity and proactive decision making. 

High-performing databases help organizations stay ahead by enabling faster insights, quicker adaptation to changes, and superior customer experiences. 

When performance of MySQL is slow it impacts user experience and data driven innovation. 
Performance has different meaning at different context however it’s important to keep MySQL instance healthy by balancing the hardware vis-à-vis InnoDB settings. 
I have been asked multiple times by MySQL customer about 

1. Does MySQL has right set of InnoDB configurations ? 
   
2. What are the InnoDB parameters to tune ? 

Great news!!! , MySQL Shell starting with 8.4.x version will check MySQL InnoDB configurations and suggest the possible recommendations. 

I suggest you to follow below steps to review the current settings. 

Step 1:- Download MySQL shell 8.4.x version from below links.               https://dev.mysql.com/downloads/shell/   Step 2:- Install downloaded MySQL shell               rpm -Uhv mysql-shell-8.4.1-1.el7.x86_64.rpm   Step 3:- Connect the MySQL Instance which you wanted to review the recommendations

mysqlsh -hxxxxx -uxxxx -pxxxx -P3306

    Step 4:- check for upgrade compatibility issues and InnoDB settings 

JS > util.checkForServerUpgrade()

 Step 5:- Review the output 

Conclusion :- 

These above settings require benchmark against your workloads , you might have to try each parameters one by one to check how MySQL server is performing in testing environment and then eventually move into production.