Posted April 10Apr 10 HalloSome weeks ago, I modified all my database tables from myisam to innodb to prepare moving to V5. It was long and boring and all seems OK.BTW, since this moment I have the impression of noticing a significant increase in response times on certain functions. For example, displaying the list of members (to validate new members) can take up to 5-6 seconds to appear, whereas it was immediate in the past...Site traffic hasn't increased; we've installed Cloudflare and .htaccess filtering to limit traffic from artificial intelligence bots/user agents...Are there any special database settings to make when switching tables to InnoDB?For info, here are my server info : MySQL Version 10.6.21-MariaDBPHP Version 8.1.31
April 10Apr 10 If you have switched to INNODB, you need to ensure your hosting is optimised for INNODB. A lot of the performance settings are different for the different table engines. Its not something on which we can advise. Thats something for your hosting company.One thing I can say is that we optimise specifically for mySQL 8. So if you want the best performance, thats what you really want to be using.
