MariaDB:如何将OQGRAPH作为DB引擎安装在Arch上

Question

是否可以在Arch上为MariaDB安装OQGRAPH？如果是这样的话，是怎么做的？

以下是我目前安装的引擎：

MariaDB [(none)]> show engines;
+--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+
| Engine             | Support | Comment                                                                                          | Transactions | XA   | Savepoints |
+--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+
| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables                                        | NO           | NO   | NO         |
| MRG_MyISAM         | YES     | Collection of identical MyISAM tables                                                            | NO           | NO   | NO         |
| CSV                | YES     | Stores tables as CSV files                                                                       | NO           | NO   | NO         |
| BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears)                                   | NO           | NO   | NO         |
| MyISAM             | YES     | Non-transactional engine with good performance and small data footprint                          | NO           | NO   | NO         |
| ARCHIVE            | YES     | gzip-compresses tables for a low storage footprint                                               | NO           | NO   | NO         |
| Aria               | YES     | Crash-safe tables with MyISAM heritage                                                           | NO           | NO   | NO         |
| InnoDB             | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, foreign keys and encryption for tables | YES          | YES  | YES        |
| PERFORMANCE_SCHEMA | YES     | Performance Schema                                                                               | NO           | NO   | NO         |
| SEQUENCE           | YES     | Generated tables filled with sequential values                                                   | YES          | NO   | YES        |
+--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+
10 rows in set (0.00 sec)

按照我找到的安装oqgraph的说明，下面是我的结果：

MariaDB [(none)]> install plugin oqgraph soname 'ha_oqgraph.so';

ERROR 1126 (HY000): Can't open shared library '/usr/lib/mysql/plugin/ha_oqgraph.so' (errno: 2, cannot open shared object file: No such file or directory)

该文件不存在：

ls /usr/lib/mysql/plugin/ha_oqgraph.so
ls: cannot access '/usr/lib/mysql/plugin/ha_oqgraph.so': No such file or directory

这两种方法都没有返回结果：

pacman -Ss oqgraph
pacman -Ss "open query graph"

相关网页：

在Arch页面上没有提到OQGraph：

https://wiki.archlinux.org/index.php/MySQL

没有OQGraph在我的MariaDB？

接受的解决方案对我不起作用。

https://mariadb.com/kb/en/library/installing-oqgraph/

该页面没有提供Arch解决方案

Answer 1

这是一个解决方案，不是一个理想的解决方案。然而，它起作用了。

将下载库的版本与已安装的MariaDB版本匹配。

下载libJudy.so.1。我没有在拱形回购中找到libJudy。更新：来自Kevin (请参阅评论)：

libJudy现在在社区回购中，所以sudo社区/judy就足够了。

离开我的老路，以防它们对任何人有帮助。否则跳到下面的Next。

以前，我使用过amd64.deb。然后按照以下步骤安装库。

extract libJudy.so.1.0.3
cd /lib
sudo mv libJudy.so.1.0.3 .
sudo ln -s libJudy.so.1.0.3 libJudy.so.1
sudo chmod 644 libJudy.so.1.0.3

Next您需要ha_oqgraph.so。我下载了MariaDB的全部官方tarball以获得该文件，并将该版本与从Arch安装的MariaDB版本相匹配。

extract ha_oqgraph.so
sudo mv ha_oqgraph.so /usr/lib/mysql/plugin/ha_oqgraph.so
sudo chmod 755 /usr/lib/mysql/plugin/ha_oqgraph.so

以根用户身份登录到MariaDB并运行：

MariaDB > install plugin oqgraph soname 'ha_oqgraph.so';
Query OK, 0 rows affected (0.00 sec)

然后运行它来确认安装了OQGRAPH：

MariaDB > show engines;

以下是我的结果：

+--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+
| Engine             | Support | Comment                                                                                          | Transactions | XA   | Savepoints |
+--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+
| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables                                        | NO           | NO   | NO         |
| MRG_MyISAM         | YES     | Collection of identical MyISAM tables                                                            | NO           | NO   | NO         |
| CSV                | YES     | Stores tables as CSV files                                                                       | NO           | NO   | NO         |
| BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears)                                   | NO           | NO   | NO         |
| MyISAM             | YES     | Non-transactional engine with good performance and small data footprint                          | NO           | NO   | NO         |
| ARCHIVE            | YES     | gzip-compresses tables for a low storage footprint                                               | NO           | NO   | NO         |
| Aria               | YES     | Crash-safe tables with MyISAM heritage                                                           | NO           | NO   | NO         |
| InnoDB             | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, foreign keys and encryption for tables | YES          | YES  | YES        |
| PERFORMANCE_SCHEMA | YES     | Performance Schema                                                                               | NO           | NO   | NO         |
| OQGRAPH            | YES     | Open Query Graph Computation Engine (http://openquery.com/graph)                                 | NO           | NO   | NO         |
| SEQUENCE           | YES     | Generated tables filled with sequential values                                                   | YES          | NO   | YES        |
+--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+
11 rows in set (0.02 sec)