软件分享 - 开发笔记分享

最后修改人	果农
最后修改时间	2020-12-21 00:32:07
创建人	果农
创建时间	2019-12-20 16:09:49

该文档由果农创建于 2019-12-20 16:09:49 ，果农在 2020-12-21 00:32:07 修改了该文档。

[TOCM]

![](/storage/45/images/0b343f569cff18e52de2907140ce8043.png)  
默认的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  
```