OQGRAPH Overview:
The Open Query GRAPH computation engine, or OQGRAPH as the engine itself is called, allows you to handle hierarchies (tree structures) and complex graphs (nodes having many connections in several directions).
OQGRAPH is unlike other storage engines, consisting of an entirely different architecture to a regular storage engine such as Aria, MyISAM or InnoDB.
It is intended to be used for retrieving hierarchical information, such as those used for graphs, routes or social relationships, in plain SQL.
OQGRAPH存储引擎作为MariaDB 10.0.7及更高版本的存储库中的单独包存在。 在Ubuntu和Debian上mariadb-oqgraph-engine-10.0
或者mariadb-plugin-oqgraph
。在Red Hat,CentOS和Fedora上MariaDB-oqgraph-engine
。要安装插件,首先安装相应的软件包,然后使用INSTALL SONAME或INSTALL PLUGIN命令安装插件。
Debian和Ubuntu:
sudo apt-get install mariadb-plugin-oqgraph
或者(对于MariaDB 10.0)
sudo apt-get install mariadb-oqgraph-engine-10.0
Fedora/Red Hat/CentOS:
请注意,OQGRAPH v3需要libjudy,它不在官方的Red Hat / Fedora存储库中。
这需要先安装(如果没有,我的系统存在了因此省略这步):
wget http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm rpm -Uvh epel-release-6-8.noarch.rpm
安装
sudo yum install MariaDB-oqgraph-engine
安装插件:
启动Mysql命令行客户端并在MariaDB中安装插件:
INSTALL SONAME 'ha_oqgraph';
题外话:
其实我当前不知道这个是干什么的对于我现在使用有用处只是在搭建新的环境在升级MariaDB时发现了有这个就安装并且水一发。至于是否对Wordpress有帮助就不得而知了。
参考:
Installing OQGRAPHhttps://mariadb.com/kb/en/library/installing-oqgraph/
OQGRAPH Overviewhttps://mariadb.com/kb/en/library/oqgraph-overview/#creating-a-table
题外参考:
OQGRAPH Exampleshttps://mariadb.com/kb/en/library/oqgraph-examples/
INSTALL PLUGINhttps://mariadb.com/kb/en/library/install-plugin/
INSTALL SONAMEhttps://mariadb.com/kb/en/library/install-soname/
Ps:不过既然发现了这个可能就会研究一番了(前提是不咕咕)
ChiuYut
2019年7月20日