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



是否可以在Arch Linux上为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 Wiki页面上没有提到OQGraph:
https://wiki.archlinux.org/index.php/MySQL

我的MariaDB中没有OQGraph
接受的解决方案对我不起作用。

https://mariadb.com/kb/en/library/installing-oqgraph/
该页面没有提供Arch Linux解决方案

这是一个变通方案,而不是理想的解决方案。然而,它是有效的。

将下载的库的版本与您安装的MariaDB的版本进行匹配。

下载libJudy.so.1。我在拱门上找不到libJudy更新:来自Kevin Andrews(见评论(:

libJudy现在在社区回购中,所以一个sudo pacman-S社区/judy就足够了。

离开我的旧步骤,以防它们对任何人都有帮助。否则,跳到下面的下一步

以前,我使用http://ftp.br.debian.org/debian/pool/main/j/judy/libjudydebian1_1.0.5-5_amd64.deb.然后按照以下步骤安装lib。

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

下一步您需要ha_oqgraph.so。我下载了MariaDB的完整官方tarball以获得该文件,将该版本与从Arch repos安装的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

以root用户身份登录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)

最新更新