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 的强太多了。 求一份地区数据 特特特简单一个问题 你不知道的常识 【求助】第一次设master/slave,不同步,不知道原因。100元报酬当我请顿饭 索引选择是独立的还是复合的 这个错误怎么解决:Query execution was interrupted 关于MYSQL数据库性能问题! 解决mysql4.0.17导出乱码问题 mysql to mssql 导数据乱码问题 在mysql--front中不能编辑 MYSQL的简单问题 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 的强太多了。