 默认的MariaDB不带Archive引擎，需要手动安装： ``` mysql -p ``` 输入root密码，连接成功后输入： ```mysql INSTALL PLUGIN archive SONAME 'ha_archive.so'; ``` 检查安装是否成功 ``` show engines \G ``` 看到有如下提示即可正常使用： ``` Engine: ARCHIVE Support: YES Comment: gzip-compresses tables for a low storage footprint Transactions: NO XA: NO Savepoints: NO ``` 以上操作方法来自：[stackoverflow](https://stackoverflow.com/questions/26996618/install-mariadb-archive-engine) 原文摘抄如下： ``` Try to install plugin using SQL shell. MariaDB> INSTALL PLUGIN archive SONAME 'ha_archive.so'; Show Plugins MariaDB> show engines \G EDIT: I have installed mariadb-10.x on ubuntu and ARCHIVE is by default enabled. MariaDB> show engines \G *************************** 7. row *************************** Engine: ARCHIVE Support: YES Comment: Archive storage engine Transactions: NO XA: NO Savepoints: NO ``` 最后修改：6年前 © 著作权归作者所有