The website is still using MyISAM table engine, is it necessary to change to InnoDB?
The reason I’m asking is because I recently transferred the site from mysql 5.7 to a new server with mysql 8.0.19 and I’m been having high cpu usage after running database optimization and I can’t figure out the reason.
