Comments - Aria Storage Engine

13 years, 10 months ago Daniel Bartholomew

You will need to update your tables to use the Aria storage engine.

Something like this:

ALTER TABLE `tablename` ENGINE=`MARIA` TRANSACTIONAL=1;

The Aria storage engine is still called 'Maria' in MariaDB 5.1.49.

This is not something you want to do on a large table or busy production server without bringing the server down first. Rebuilding a table can take a long time (depending on the size) and the table will be inaccessible while the change is being made.

As with any change, test it on a non-production table with example data first and test to ensure your data and applications work fine after the change has been made. Lastly, before rolling any changes out to production servers make backups.

 
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.