系统环境: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插件
- [root@localhostbin]#./mysql
- mysql>showplugin;
- +------------+--------+----------------+---------+---------+
- |Name|Status|Type|Library|License|
- +------------+--------+----------------+---------+---------+
- |binlog|ACTIVE|STORAGEENGINE|NULL|GPL|
- |CSV|ACTIVE|STORAGEENGINE|NULL|GPL|
- |MEMORY|ACTIVE|STORAGEENGINE|NULL|GPL|
- |MyISAM|ACTIVE|STORAGEENGINE|NULL|GPL|
- |MRG_MYISAM|ACTIVE|STORAGEENGINE|NULL|GPL|
- +------------+--------+----------------+---------+---------+
发现没有安装
- mysql>installplugininnodbsoname'ha_innodb.so';
- ERROR1126(HY000):Can'topensharedlibrary'/usr/local/mysql/lib/mysql/plugin/ha_innodb.so'(errno:13cannotrestoresegmentprotafterreloc:Permissiondenied)
发现权限有问题
- [root@localhostplugin]#chcon-ttexrel_shlib_t/usr/local/mysql/lib/mysql/plugin/ha_innodb.so
给权限再安装
- mysql>installplugininnodbsoname'ha_innodb.so';
- QueryOK,0rowsaffected(0.36sec)
- mysql>showplugin;
- +------------+--------+----------------+--------------+---------+
- |Name|Status|Type|Library|License|
- +------------+--------+----------------+--------------+---------+
- |binlog|ACTIVE|STORAGEENGINE|NULL|GPL|
- |CSV|ACTIVE|STORAGEENGINE|NULL|GPL|
- |MEMORY|ACTIVE|STORAGEENGINE|NULL|GPL|
- |MyISAM|ACTIVE|STORAGEENGINE|NULL|GPL|
- |MRG_MYISAM|ACTIVE|STORAGEENGINE|NULL|GPL|
- |InnoDB|ACTIVE|STORAGEENGINE|ha_innodb.so|GPL|
- +------------+--------+----------------+--------------+---------+
- 6rowsinset,1warning(0.00sec)
安装成功
修改mysql配置文件/etc/my.cnf为以下内容.只为安装.就用默认值了.
- #UncommentthefollowingifyouareusingInnoDBtables
- innodb_data_home_dir=/usr/local/mysql/var/
- innodb_data_file_path=ibdata1:10M:autoextend
- innodb_log_group_home_dir=/usr/local/mysql/var/
- #Youcanset.._buffer_pool_sizeupto50-80%
- #ofRAMbutbewareofsettingmemoryusagetoohigh
- innodb_buffer_pool_size=16M
- innodb_additional_mem_pool_size=2M
- #Set.._log_file_sizeto25%ofbufferpoolsize
- innodb_log_file_size=5M
- innodb_log_buffer_size=8M
- innodb_flush_log_at_trx_commit=1
- innodb_lock_wait_timeout=50
重启数据库
- /etc/init.d/mysqldrestart
到此完成.