查看mysql的存储引擎:
show plugins;
+------------+--------+----------------+--------------+---------+
| 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
mysql> show variables like "have_%";
+-------------------------+-------+
| Variable_name | Value |
+-------------------------+-------+
| have_community_features | YES |
| have_compress | YES |
| have_crypt | YES |
| have_csv | YES |
| have_dynamic_loading | YES |
| have_geometry | YES |
| have_innodb | NO |
| have_ndbcluster | NO |
| have_openssl | NO |
| have_partitioning | NO |
| have_query_cache | YES |
| have_rtree_keys | YES |
| have_ssl | NO |
| have_symlink | YES | 第二步:试着安装innodb类型: INSTALL PLUGIN INNODB SONAME 'ha_innodb.so'; 安装成功。创建innodb表也成功。 第三步:修改.cnf的参数
wait_timeout = 172800
transaction-isolation = REPEATABLE-READ
binlog_format=mixed
innodb_fast_shutdown = 1
innodb_force_recovery =0
innodb_buffer_pool_size=4000M
innodb_log_file_size = 512M
innodb_file_per_table=1
query_cache_size=32M
innodb_data_file_path= ibdata1:10M;autoextend 无法启动服务器报: InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 536870912 bytes!
120308 5:30:24 [ERROR] Plugin 'InnoDB' init function returned error.
120308 5:30:24 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
将 ib_logfile0删除mysqld服务可正常启动。
是不是这样安装的innodb的类型不支持?启动mysqld之后
查看存储引擎:
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 |
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
+------------+---------+-----------------------------------------------------------+--------------+------+------------+mysql> show variables like 'have_%';
+-------------------------+-------+
| Variable_name | Value |
+-------------------------+-------+
| have_community_features | YES |
| have_compress | YES |
| have_crypt | YES |
| have_csv | YES |
| have_dynamic_loading | YES |
| have_geometry | YES |
| have_innodb | NO |
| have_ndbcluster | NO |
| have_openssl | NO |
| have_partitioning | NO |
| have_query_cache | YES |
| have_rtree_keys | YES |
| have_ssl | NO |
| have_symlink | YES |
+-------------------------+-------+
14 rows in set (0.00 sec)
重启mysqld后为何不支持存储引擎:
show plugins;
+------------+--------+----------------+--------------+---------+
| 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
mysql> show variables like "have_%";
+-------------------------+-------+
| Variable_name | Value |
+-------------------------+-------+
| have_community_features | YES |
| have_compress | YES |
| have_crypt | YES |
| have_csv | YES |
| have_dynamic_loading | YES |
| have_geometry | YES |
| have_innodb | NO |
| have_ndbcluster | NO |
| have_openssl | NO |
| have_partitioning | NO |
| have_query_cache | YES |
| have_rtree_keys | YES |
| have_ssl | NO |
| have_symlink | YES | 第二步:试着安装innodb类型: INSTALL PLUGIN INNODB SONAME 'ha_innodb.so'; 安装成功。创建innodb表也成功。 第三步:修改.cnf的参数
wait_timeout = 172800
transaction-isolation = REPEATABLE-READ
binlog_format=mixed
innodb_fast_shutdown = 1
innodb_force_recovery =0
innodb_buffer_pool_size=4000M
innodb_log_file_size = 512M
innodb_file_per_table=1
query_cache_size=32M
innodb_data_file_path= ibdata1:10M;autoextend 无法启动服务器报: InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 536870912 bytes!
120308 5:30:24 [ERROR] Plugin 'InnoDB' init function returned error.
120308 5:30:24 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
将 ib_logfile0删除mysqld服务可正常启动。
是不是这样安装的innodb的类型不支持?启动mysqld之后
查看存储引擎:
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 |
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
+------------+---------+-----------------------------------------------------------+--------------+------+------------+mysql> show variables like 'have_%';
+-------------------------+-------+
| Variable_name | Value |
+-------------------------+-------+
| have_community_features | YES |
| have_compress | YES |
| have_crypt | YES |
| have_csv | YES |
| have_dynamic_loading | YES |
| have_geometry | YES |
| have_innodb | NO |
| have_ndbcluster | NO |
| have_openssl | NO |
| have_partitioning | NO |
| have_query_cache | YES |
| have_rtree_keys | YES |
| have_ssl | NO |
| have_symlink | YES |
+-------------------------+-------+
14 rows in set (0.00 sec)
重启mysqld后为何不支持存储引擎:
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货