成人午夜视频全免费观看高清-秋霞福利视频一区二区三区-国产精品久久久久电影小说-亚洲不卡区三一区三区一区

Mysql如何在線安裝其它引擎

這篇文章主要介紹MySQL如何在線安裝其它引擎，文中介紹的非常詳細，具有一定的參考價值，感興趣的小伙伴們一定要看完！

成都網站建設哪家好，找成都創(chuàng)新互聯！專注于網頁設計、成都網站建設、微信開發(fā)、微信小程序、集團成都定制網站等服務項目。核心團隊均擁有互聯網行業(yè)多年經驗，服務眾多知名企業(yè)客戶；涵蓋的客戶類型包括：活動板房等眾多領域，積累了大量豐富的經驗，同時也獲得了客戶的一致贊許！

mysql 在線安裝sphinx存儲引擎  


需要在現有mysql中安裝sphinx的存儲引擎，要保證現有mysql運行的情況下完成。mysql也的確支持存儲引擎的在線熱插拔，下面介紹安裝步驟：


1、查看現有mysql的運行版本

[root@localhost plugin]# mysqladmin  -uroot -proot version  

Warning: Using a password on the command line interface can be insecure.

mysqladmin  Ver 8.42 Distrib 5.6.16, for Linux on x86_64

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.


Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.


Server version          5.6.16

Protocol version        10

Connection              Localhost via UNIX socket

UNIX socket             /var/lib/mysql/mysql.sock

Uptime:                 1 day 6 hours 26 min 58 sec


Threads: 1  Questions: 35  Slow queries: 0  Opens: 67  Flush tables: 1  Open tables: 60  Queries per second avg: 0.000



2、下載mysql和sphinx

mysql：wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.16.tar.gz

sphinx：http://sphinxsearch.com/downloads/release/ 進去后下載：

Sphinx 2.1.7-release (r4638; Mar 30, 2014)
Mysql如何在線安裝其它引擎 Source tarball (tar.gz) 2.1.7-release 2.3M Download


注意：mysql源碼包的版本一定要與當前運行的mysql版本一致！


解壓

# tar -xzvf mysql-5.6.16.tar.gz

# tar -xzvf sphinx-2.1.7-release.tar.gz


3、將sphinx-2.1.7-release下的mysqlse目錄復制到mysql目錄中

#cp -r sphinx-2.1.7-release/mysqlse/ mysql-5.6.16/storage/sphinx


build

# cd mysql-5.6.16

# sh BUILD/autorun.sh

#./configure （此步可以需要yum一些依賴的軟件包，否則會有錯誤或警告）

# make


注意：這里到make這步即可，不用install


4、將make好的文件復制到當前運行的mysql目錄中

[root@localhost sphinx]# pwd

/u/opt/mysql-5.6.16/storage/sphinx

cp ha_sphinx.so /usr/lib64/mysql/plugin/

更改所有者（這邊試不改也可以）

# chown mysql.mysql /usr/lib64/mysql/plugin/*


注：我當前運行的mysql目錄在/usr/local/mysql


5、登陸mysql加載sphinx引擎模塊

mysql> show engines;

+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+

| Engine             | Support | Comment                                                        | Transactions | XA   | Savepoints |

+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+

| InnoDB             | DEFAULT | Supports transactions, row-level locking, and foreign keys     | YES          | YES  | YES        |

| CSV                | YES     | CSV storage engine                                             | NO           | NO   | NO         |

| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   | NO         |

| BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears) | NO           | NO   | NO         |

| MRG_MYISAM         | YES     | Collection of identical MyISAM tables                          | NO           | NO   | NO         |

| MyISAM             | YES     | MyISAM storage engine                                          | NO           | NO   | NO         |

| ARCHIVE            | YES     | Archive storage engine                                         | NO           | NO   | NO         |

| FEDERATED          | NO      | Federated MySQL storage engine                                 | NULL         | NULL | NULL       |

| PERFORMANCE_SCHEMA | YES     | Performance Schema                                             | NO           | NO   | NO         |

+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+

9 rows in set (0.01 sec)


mysql> INSTALL PLUGIN sphinx SONAME 'ha_sphinx.so';

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

這里ERROR發(fā)現第一次是ha_sphinx.so位置拷錯了，拷正確后：

mysql> INSTALL PLUGIN sphinx SONAME 'ha_sphinx.so';

Query OK, 0 rows affected (0.05 sec)


mysql> show engines;

+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+

| Engine             | Support | Comment                                                        | Transactions | XA   | Savepoints |

+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+

| InnoDB             | DEFAULT | Supports transactions, row-level locking, and foreign keys     | YES          | YES  | YES        |

| CSV                | YES     | CSV storage engine                                             | NO           | NO   | NO         |

| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   | NO         |

| BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears) | NO           | NO   | NO         |

| MRG_MYISAM         | YES     | Collection of identical MyISAM tables                          | NO           | NO   | NO         |

| SPHINX             | YES     | Sphinx storage engine 2.1.7-release                            | NO           | NO   | NO         |

| MyISAM             | YES     | MyISAM storage engine                                          | NO           | NO   | NO         |

| ARCHIVE            | YES     | Archive storage engine                                         | NO           | NO   | NO         |

| FEDERATED          | NO      | Federated MySQL storage engine                                 | NULL         | NULL | NULL       |

| PERFORMANCE_SCHEMA | YES     | Performance Schema                                             | NO           | NO   | NO         |

+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+

10 rows in set (0.00 sec)


mysql> 

安裝完成！如果要卸載存儲模塊使用

mysql> UNINSTALL PLUGIN sphinx;  

安裝好后,過了幾天:

mysql> show engines;
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine             | Support | Comment                                                        | Transactions | XA   | Savepoints |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| InnoDB             | DEFAULT | Supports transactions, row-level locking, and foreign keys     | YES          | YES  | YES        |
| CSV                | YES     | CSV storage engine                                             | NO           | NO   | NO         |
| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   | NO         |
| BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears) | NO           | NO   | NO         |
| MRG_MYISAM         | YES     | Collection of identical MyISAM tables                          | NO           | NO   | NO         |
| MyISAM             | YES     | MyISAM storage engine                                          | NO           | NO   | NO         |
| ARCHIVE            | YES     | Archive storage engine                                         | NO           | NO   | NO         |
| FEDERATED          | NO      | Federated MySQL storage engine                                 | NULL         | NULL | NULL       |
| PERFORMANCE_SCHEMA | YES     | Performance Schema                                             | NO           | NO   | NO         |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
9 rows in set (0.00 sec)

mysql>

不知道為什么找不到 SPHINX 引擎

只有重新安裝一遍看,于是參考網上的:

mysql> INSTALL PLUGIN sphinx SONAME 'ha_sphinx.so';
ERROR 1062 (23000): Duplicate entry 'sphinx' for key 'PRIMARY'
mysql>

mysql> UNINSTALL PLUGIN sphinx;
ERROR 1305 (42000): PLUGIN sphinx does not exist
mysql> 
mysql> 
mysql>  select * from mysql.plugin;
+--------+--------------+
| name   | dl           |
+--------+--------------+
| sphinx | ha_sphinx.so |
+--------+--------------+
1 row in set (0.00 sec)

mysql> UNINSTALL PLUGIN sphinx;
ERROR 1305 (42000): PLUGIN sphinx does not exist
mysql> 
mysql> 
mysql>  select * from mysql.plugin;
+--------+--------------+
| name   | dl           |
+--------+--------------+
| sphinx | ha_sphinx.so |
+--------+--------------+
1 row in set (0.00 sec)

mysql> 
mysql> delete from mysql.plugin where name='SPHINX';
Query OK, 1 row affected (0.02 sec)

mysql> 
mysql> 
mysql> select * from mysql.plugin;
Empty set (0.00 sec)

mysql> install plugin SPHINX soname 'ha_sphinx.so';
Query OK, 0 rows affected (0.00 sec)

mysql> show engines;
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine             | Support | Comment                                                        | Transactions | XA   | Savepoints |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| InnoDB             | DEFAULT | Supports transactions, row-level locking, and foreign keys     | YES          | YES  | YES        |
| CSV                | YES     | CSV storage engine                                             | NO           | NO   | NO         |
| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   | NO         |
| BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears) | NO           | NO   | NO         |
| MRG_MYISAM         | YES     | Collection of identical MyISAM tables                          | NO           | NO   | NO         |
| SPHINX             | YES     | Sphinx storage engine 2.1.7-release                            | NO           | NO   | NO         |
| MyISAM             | YES     | MyISAM storage engine                                          | NO           | NO   | NO         |
| ARCHIVE            | YES     | Archive storage engine                                         | NO           | NO   | NO         |
| FEDERATED          | NO      | Federated MySQL storage engine                                 | NULL         | NULL | NULL       |
| PERFORMANCE_SCHEMA | YES     | Performance Schema                                             | NO           | NO   | NO         |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
10 rows in set (0.00 sec)

mysql>

在開始安裝之前,查檢一下mysql.plugin表,里邊是不是留有老版本的SPHINXSE沒有完全清理掉.

以上是“Mysql如何在線安裝其它引擎”這篇文章的所有內容，感謝各位的閱讀！希望分享的內容對大家有幫助，更多相關知識，歡迎關注創(chuàng)新互聯行業(yè)資訊頻道！

本文名稱：Mysql如何在線安裝其它引擎
標題路徑：http://jinyejixie.com/article14/jposde.html

成都網站建設公司_創(chuàng)新互聯，為您提供定制開發(fā)、網站制作、小程序開發(fā)、App設計、外貿網站建設、商城網站

廣告

聲明：本網站發(fā)布的內容（圖片、視頻和文字）以用戶投稿、用戶轉載內容為主，如果涉及侵權請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網站立場，如需處理請聯系客服。電話：028-86922220；郵箱：631063699@qq.com。內容未經允許不得轉載，或轉載時需注明來源： 創(chuàng)新互聯

網站托管運營
于田县| 郓城县| 和田县| 临海市| 新昌县| 邢台市| 自治县| 贵南县| 昌黎县| 三台县| 上高县| 赞皇县| 丰都县| 桓仁| 甘洛县| 汉川市| 扎赉特旗| 台北市| 建宁县| 安顺市| 达日县| 兴和县| 晋江市| 贵溪市| 景洪市| 龙里县| 且末县| 阿拉尔市| 海盐县| 玉环县| 监利县| 北碚区| 济阳县| 禹城市| 凌海市| 邯郸县| 海原县| 玉林市| 招远市| 沙湾县| 阳信县|