Comments - Migrating from MySQL 5.1.31-community >> MariaDB 5.5

10 years, 5 months ago roberto spadim

about: what storage engine would you recommend we try, Ari or? Some of these tables contain in excess of a million rows. Is there anything I should be aware of before converting tables?

well, only table size isn't a metric to select a engine... it's read only? 10% read 90% write? 10% write 90% read? you need table or row lock?

i have some myisam tables that i converted to aria just to allow a crash safe feature, it works

i don't have centos to answer your first questions, maybe the binary is easier... just untar and change your my.cnf to point to new share,data,binary files and directories

 
10 years, 5 months ago Charlie Hoy

When I was stating the table size, I was merely wondering if there is anything I should be aware of when converting a MyISAM to one of the other storage engines and not meaning it as a metric. Apologies for not making that clear. I was also looking to find out which storage engine would be the closest to feature set, etc. to MyISAM? Many thanks!

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.