The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

MariaDB - online table archiving

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

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.