The Ultimate Guide to High Availability with MariaDB

MariaDB - online table archiving

You are viewing an old version of this question. View the current version here.

We have a script that "rotates"/archive the Syslog tables in MySQL. This script:

at Linux level, renames the "MyISAM" tables files then compress them then inside MySQL, rename these tables The 2 steps are "online". No MySQLd restart is required.

Now I built a new Syslog database in MariaDB (Debian Stretch). The tables are using InnoDB and not MyISAM. This script fails at the 2nd execution to rename the table inside MySQL after moving the file:

ERROR 1050 (42S01): Table 'SystemEvents_1' already exists

A reference of the table is kept somewhere (tablespace internal system table?) which prevents from doing that.

My question: would it work if I migrate my tables to the ARIA engine with transactional=0?

Thanks, Vince

Comments

Comments loading...
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.