mysql需要安装innodb_mysql 安装innodb支持

系统环境:linux

数据库版本:mysql 5.1.47

需要要安装innodb类型支持

查看数据库是否支持innodb

mysql> show engines;

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

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

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

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

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

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

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

| MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great performance     | NO           | NO   | NO         |

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

5 rows in set (0.00 sec)

先查看mysql是否安装了innodb插件

Sql代码

[root@localhost bin]# ./mysql

mysql> show plugin;

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

| Name| Status | Type           | Library | License |

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

| binlog     | ACTIVE | STORAGE ENGINE | NULL| GPL     |

| CSV        | ACTIVE | STORAGE ENGINE | NULL| GPL     |

| MEMORY     | ACTIVE | STORAGE ENGINE | NULL| GPL     |

| MyISAM     | ACTIVE | STORAGE ENGINE | NULL| GPL     |

| MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL| GPL     |

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

[root@localhost bin]# ./mysql mysql> show plugin; +------------+--------+----------------+---------+---------+ | Name | Status | Type | Library | License | +------------+--------+----------------+---------+---------+ | binlog | ACTIVE | STORAGE ENGINE | NULL | GPL | | CSV | ACTIVE | STORAGE ENGINE | NULL | GPL | | MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL | | MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL | | MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | GPL | +------------+--------+----------------+---------+---------+

发现没有安装

Sql代码

mysql> install plugin innodb soname'ha_innodb.so';

ERROR 1126 (HY000): Can't open shared library '/usr/local/mysql/lib/mysql/plugin/ha_innodb.so' (errno: 13 cannot restore segment protafterreloc: Permission denied)

mysql> install plugin innodb soname 'ha_innodb.so'; ERROR 1126 (HY000): Can't open shared library '/usr/local/mysql/lib/mysql/plugin/ha_innodb.so' (errno: 13 cannot restore segment prot after reloc: Permission denied)

发现权限有问题

Sql代码

[root@localhost plugin]# chcon -t texrel_shlib_t /usr/local/mysql/lib/mysql/plugin/ha_innodb.so

[root@localhost plugin]# chcon -t texrel_shlib_t /usr/local/mysql/lib/mysql/plugin/ha_innodb.so

给权限再安装

Java代码

mysql> install plugin innodb soname'ha_innodb.so';

Query OK, 0rows affected (0.36sec)

mysql> show plugin;

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

| Name       | Status | Type           | Library      | License |

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

| binlog     | ACTIVE | STORAGE ENGINE | NULL         | GPL     |

| CSV        | ACTIVE | 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.so | GPL     |

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

6rows in set,1warning (0.00sec)

mysql> install plugin innodb soname 'ha_innodb.so'; Query OK, 0 rows affected (0.36 sec) mysql> show plugin; +------------+--------+----------------+--------------+---------+ | Name | Status | Type | Library | License | +------------+--------+----------------+--------------+---------+ | binlog | ACTIVE | STORAGE ENGINE | NULL | GPL | | CSV | ACTIVE | 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.so | GPL | +------------+--------+----------------+--------------+---------+ 6 rows in set, 1 warning (0.00 sec)

安装成功

修改mysql配置文件/etc/my.cnf为以下内容.只为安装.就用默认值了.

Java代码

# Uncomment the followingifyou are using InnoDB tables

innodb_data_home_dir = /usr/local/mysql/var/

innodb_data_file_path = ibdata1:10M:autoextend

innodb_log_group_home_dir = /usr/local/mysql/var/

# You can set .._buffer_pool_size up to 50-80%

# of RAM but beware of setting memory usage too high

innodb_buffer_pool_size = 16M

innodb_additional_mem_pool_size = 2M

# Set .._log_file_size to 25% of buffer pool size

innodb_log_file_size = 5M

innodb_log_buffer_size = 8M

innodb_flush_log_at_trx_commit = 1

innodb_lock_wait_timeout = 50

# Uncomment the following if you are using InnoDB tables innodb_data_home_dir = /usr/local/mysql/var/ innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /usr/local/mysql/var/ # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high innodb_buffer_pool_size = 16M innodb_additional_mem_pool_size = 2M # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 5M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50

重启数据库

Java代码

/etc/init.d/mysqld restart

/etc/init.d/mysqld restart

到此完成.