linux下安装mysql插件 出现ERROR 1146 (42S02): Table 'mysql.plugin' doesn't exist 安装插件时报错 不让安装 INSTALL PLUGIN handlersocket soname 'handlersocket.so';大家帮我看看吧 什么原因 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 mysql.plugin应为mysql5.1所有,如果你尝试在mysql5.0安装plugin,肯定会提示mysql.plugin不存在。更具体的原因,需要额外的信息来分析。 准备加载InnoDB Plugin插件这一步是比较复杂的,为了加载Plugin,需要先将built-in禁用。首先将配置配置文件中所有innodb相关的选择注释掉(也可以使用loose前缀);然后在配置文件中添加忽略InnoDB built-in的参数:ignore_builtin_innodb #忽略InnoDB built-ininnodb_file_format=barracuda #据说该文件格式对性能提升很高innodb_file_per_table #要使用barracuda文件个数,必须独享表空间#注释InnoDB选择#innodb_flush_method = O_DIRECT#innodb_file_per_table = 1#innodb_flush_log_at_trx_commit = 2#innodb_lock_wait_timeout = 100......5.3 启动MySQL并加载InnoDB Plugin这里需要登入MySQL并手动加载Plugin相关的插件:$./bin/mysqld_safe & #启动数据库$mysql -urootroot>INSTALL PLUGIN INNODB SONAME 'ha_innodb_plugin.so';root>INSTALL PLUGIN INNODB_TRX SONAME 'ha_innodb_plugin.so';root>INSTALL PLUGIN INNODB_LOCKS SONAME 'ha_innodb_plugin.so';root>INSTALL PLUGIN INNODB_LOCK_WAITS SONAME 'ha_innodb_plugin.so';root>INSTALL PLUGIN INNODB_CMP SONAME 'ha_innodb_plugin.so';root>INSTALL PLUGIN INNODB_CMP_RESET SONAME 'ha_innodb_plugin.so';root>INSTALL PLUGIN INNODB_CMPMEM SONAME 'ha_innodb_plugin.so';root>INSTALL PLUGIN INNODB_CMPMEM_RESET SONAME 'ha_innodb_plugin.so'成功执行后,在启用INNODB的选项。5.4 查看版本安装完成,可以通过如下命令查看安装是否成功:mysql> select @@innodb_version;+------------------+| @@innodb_version |+------------------+| 1.0.15 |+------------------+1 row in set (0.00 sec) mysql> show plugins;+---------------------+----------+--------------------+---------------------+---------+| Name | Status | Type | Library | License |+---------------------+----------+--------------------+---------------------+---------+| binlog | ACTIVE | STORAGE ENGINE | NULL | GPL || partition | ACTIVE | STORAGE ENGINE | NULL | GPL || ARCHIVE | ACTIVE | STORAGE ENGINE | NULL | GPL || BLACKHOLE | ACTIVE | STORAGE ENGINE | NULL | GPL || CSV | ACTIVE | STORAGE ENGINE | NULL | GPL || FEDERATED | DISABLED | STORAGE ENGINE | NULL | GPL || MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL || MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL || MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | GPL || InnoDB | ACTIVE | STORAGE ENGINE | ha_innodb_plugin.so | GPL || INNODB_TRX | ACTIVE | INFORMATION SCHEMA | ha_innodb_plugin.so | GPL || INNODB_LOCKS | ACTIVE | INFORMATION SCHEMA | ha_innodb_plugin.so | GPL || INNODB_LOCK_WAITS | ACTIVE | INFORMATION SCHEMA | ha_innodb_plugin.so | GPL || INNODB_CMP | ACTIVE | INFORMATION SCHEMA | ha_innodb_plugin.so | GPL || INNODB_CMP_RESET | ACTIVE | INFORMATION SCHEMA | ha_innodb_plugin.so | GPL || INNODB_CMPMEM | ACTIVE | INFORMATION SCHEMA | ha_innodb_plugin.so | GPL || INNODB_CMPMEM_RESET | ACTIVE | INFORMATION SCHEMA | ha_innodb_plugin.so | GPL |+---------------------+----------+--------------------+---------------------+---------+17 rows in set (0.00 sec) mysql>innodb plugin 在INDEX操作方面比buildin 的强太多了。 调用这个存储过程,程序为什么会死掉? mysql4如何改编码 如何将本地MYSQL数据库导入服务器中? 安装mysql时出现10061错误,急!!!!! mysql数据库建模大家用什么工具? MySQL的MySQL Administrator是如何实现备份、恢复的? 多个mysql表中的相同字段如何求和。 急,在线等待:Linux下Mysql锁定的问题 高分求教 关于mysql的多表性能 300分 MySql 数据库管理-30 MySQL 函数如何返回一张表 sum求和问题
这一步是比较复杂的,为了加载Plugin,需要先将built-in禁用。首先将配置配置文件中所有innodb相关的选择注释掉(也可以使用loose前缀);然后在配置文件中添加忽略InnoDB built-in的参数:
ignore_builtin_innodb #忽略InnoDB built-in
innodb_file_format=barracuda #据说该文件格式对性能提升很高
innodb_file_per_table #要使用barracuda文件个数,必须独享表空间
#注释InnoDB选择
#innodb_flush_method = O_DIRECT
#innodb_file_per_table = 1
#innodb_flush_log_at_trx_commit = 2
#innodb_lock_wait_timeout = 100
......
5.3 启动MySQL并加载InnoDB Plugin这里需要登入MySQL并手动加载Plugin相关的插件:
$./bin/mysqld_safe & #启动数据库
$mysql -uroot
root>INSTALL PLUGIN INNODB SONAME 'ha_innodb_plugin.so';
root>INSTALL PLUGIN INNODB_TRX SONAME 'ha_innodb_plugin.so';
root>INSTALL PLUGIN INNODB_LOCKS SONAME 'ha_innodb_plugin.so';
root>INSTALL PLUGIN INNODB_LOCK_WAITS SONAME 'ha_innodb_plugin.so';
root>INSTALL PLUGIN INNODB_CMP SONAME 'ha_innodb_plugin.so';
root>INSTALL PLUGIN INNODB_CMP_RESET SONAME 'ha_innodb_plugin.so';
root>INSTALL PLUGIN INNODB_CMPMEM SONAME 'ha_innodb_plugin.so';
root>INSTALL PLUGIN INNODB_CMPMEM_RESET SONAME 'ha_innodb_plugin.so'成功执行后,在启用INNODB的选项。
5.4 查看版本安装完成,可以通过如下命令查看安装是否成功:
mysql> select @@innodb_version;
+------------------+
| @@innodb_version |
+------------------+
| 1.0.15 |
+------------------+
1 row in set (0.00 sec)
mysql> show plugins;
+---------------------+----------+--------------------+---------------------+---------+
| Name | Status | Type | Library | License |
+---------------------+----------+--------------------+---------------------+---------+
| binlog | ACTIVE | STORAGE ENGINE | NULL | GPL |
| partition | ACTIVE | STORAGE ENGINE | NULL | GPL |
| ARCHIVE | ACTIVE | STORAGE ENGINE | NULL | GPL |
| BLACKHOLE | ACTIVE | STORAGE ENGINE | NULL | GPL |
| CSV | ACTIVE | STORAGE ENGINE | NULL | GPL |
| FEDERATED | DISABLED | STORAGE ENGINE | NULL | GPL |
| MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL |
| MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
| MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
| InnoDB | ACTIVE | STORAGE ENGINE | ha_innodb_plugin.so | GPL |
| INNODB_TRX | ACTIVE | INFORMATION SCHEMA | ha_innodb_plugin.so | GPL |
| INNODB_LOCKS | ACTIVE | INFORMATION SCHEMA | ha_innodb_plugin.so | GPL |
| INNODB_LOCK_WAITS | ACTIVE | INFORMATION SCHEMA | ha_innodb_plugin.so | GPL |
| INNODB_CMP | ACTIVE | INFORMATION SCHEMA | ha_innodb_plugin.so | GPL |
| INNODB_CMP_RESET | ACTIVE | INFORMATION SCHEMA | ha_innodb_plugin.so | GPL |
| INNODB_CMPMEM | ACTIVE | INFORMATION SCHEMA | ha_innodb_plugin.so | GPL |
| INNODB_CMPMEM_RESET | ACTIVE | INFORMATION SCHEMA | ha_innodb_plugin.so | GPL |
+---------------------+----------+--------------------+---------------------+---------+
17 rows in set (0.00 sec)
mysql>innodb plugin 在INDEX操作方面比buildin 的强太多了。