Changing table engine to innodb manually
Dear all,
Good day!! Recently we are facing a huge performance problem with one of our Mariadb
Version:10.1.32. We have increased the innodb buffer pool size, but didn’t get any performance benefit. Later found, some of the biggest table in the database usage mysiam emgine, a small number of table using innodb. Now , we are thinking of altering the table engine to innodb to get performance benefits.
But my concern is, changing the engine to innodb might cause malfunctioning of the application?? Or what should I do to get the benefit of my resources available to get better performance??
Please suggest..
Regards
Subject
Views
Written By
Posted
Changing table engine to innodb manually
818
January 14, 2021 07:45AM
388
January 14, 2021 12:08PM
380
January 14, 2021 09:07PM
400
January 14, 2021 11:29PM
326
January 15, 2021 12:35PM
419
January 15, 2021 03:50AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.