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.
I have finally gotten around to giving this a whirl on a test server. Please correct me if I have taken some incorrect steps here in the migration for testing purposes. I have installed MariaDB 5.5.34-1 . I then did a complete dump of my DB from MySQL and then created two new databases on MariaDB test server so that I could do some A/B testing. I imported the dump file into both databases. All tables were using the MyISAM storage engine.
I then converted all tables in DB-A to Aria and left all tables in DB-B as MyISAM, after which I optimized all tables in both DB's. I have run various simple select statements on each DB and it appears that Aria is slower and in some cases considerably slower compared to MyISAM.
One such result below: MyISAM results 56044 rows in set (4.05 sec) Aria results 56044 rows in set (6.77 sec)
Now is this performance hit a result of Aria being crash proof? Is there something else I should be doing to the tables other than what I have done with the import, converting to Aria and then optimizing them to squeeze out better performance?