my-innodb-heavy-4g.chf启用后default-storage-engine只能使用MyISAM？
my-innodb-heavy-4g.chf启用后default-storage-engine只能使用MyISAM，而无法使用InnoDB，不知道你们是否也这样会出问题1410023:42:52 Plugin 'InnoDB' is disabled.1410023:42:52 Function 'innodb' already exists
1410023:42:52 Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
1410023:42:52 Server hostname (bind-address): '0.0.0.0'; port: 3306
1410023:42:52 - '0.0.0.0' resolves to '0.0.0.0';
1410023:42:52 Server socket created on IP: '0.0.0.0'.
1410023:42:52 Event Scheduler: Loaded 0 events
1410023:42:52 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.37-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
1410023:45:36 /usr/local/mysql/bin/mysqld: Normal shutdown
1410023:45:36 Event Scheduler: Purging the queue. 0 events
1410023:45:38 /usr/local/mysql/bin/mysqld: Forcing close of thread 445user: 'aiqu'
1410023:45:38 /usr/local/mysql/bin/mysqld: Shutdown complete
141002 03:45:38 mysqld_safe mysqld from pid file /usr/local/mysql/var/li759-91.pid ended
141002 03:45:40 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
1410023:45:40 Function 'innodb' already exists
1410023:45:40 Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
1410023:45:40 InnoDB: The InnoDB memory heap is disabled
1410023:45:40 InnoDB: Mutexes and rw_locks use GCC atomic builtins
1410023:45:40 InnoDB: Compressed tables use zlib 1.2.3
1410023:45:40 InnoDB: Initializing buffer pool, size = 16.0M
1410023:45:40 InnoDB: Completed initialization of buffer pool
1410023:45:40 InnoDB: highest supported file format is Barracuda.
1410023:45:40InnoDB: Waiting for the background threads to start
1410023:45:41 InnoDB: 5.5.37 started; log sequence number 32582219
1410023:45:41 Server hostname (bind-address): '0.0.0.0'; port: 3306
1410023:45:41 - '0.0.0.0' resolves to '0.0.0.0';
1410023:45:41 Server socket created on IP: '0.0.0.0'.
1410023:45:41 Event Scheduler: Loaded 0 events
1410023:45:41 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.37'socket: '/tmp/mysql.sock'port: 3306Source distribution
1410023:51:34 /usr/local/mysql/bin/mysqld: Normal shutdown
1410023:51:34 Event Scheduler: Purging the queue. 0 events
1410023:51:36 /usr/local/mysql/bin/mysqld: Forcing close of thread 1046user: 'aiqu'
1410023:51:36InnoDB: Starting shutdown...
1410023:51:36InnoDB: Shutdown completed; log sequence number 32582219
1410023:51:36 /usr/local/mysql/bin/mysqld: Shutdown complete
141002 03:51:36 mysqld_safe mysqld from pid file /usr/local/mysql/var/li759-91.pid ended
141002 03:51:38 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
1410023:51:38 Using unique option prefix myisam_recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
1410023:51:38 Plugin 'InnoDB' is disabled.
1410023:51:38 Function 'innodb' already exists
1410023:51:38 Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'. 安装时是否选择了innnodb？
再发一下配置文件看看
default-storage-engine现在只能设置MyISAM，一旦设置InnoDB，就报上面的错误。 可能安装时没选innodb吧
回复 4# 的帖子
军哥，安装的时候肯定选择了innodb的，我换回默认的my.cnf就是innodb引擎，但是一旦还4G这个，就必须选myisam才行 请问是哪里问题？？？ 找到原因了，因为开始都开启了innod，my.cnf 默认设置的innodb_log_file_size =8M，文件在Mysql第一次启动时候已经创建,大小为设置的8M，而4G的my.cnf，他这个设置为innodb_log_file_size =256M，这两个大小不同就会出这个问题，ibdata1文件也是设置大小不同
解决办法：
把ib_logfile0，ib_logfile1 ，ibdata1 ，都重命名或者删掉，然后启动mysql就好了
页:
[1]