Comments - Migrating from MySQL 5.1.31-community >> MariaDB 5.5
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.
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
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!