my-innodb-heavy-4g.chf启用后default-storage-engine只能使用MyISAM？

monface

my-innodb-heavy-4g.chf启用后default-storage-engine只能使用MyISAM，而无法使用InnoDB，不知道你们是否也这样会出问题

1. 141002  3:42:52 [Note] Plugin 'InnoDB' is disabled.
   
2. 141002  3:42:52 [ERROR] Function 'innodb' already exists
   
3. 141002  3:42:52 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
   
4. 141002  3:42:52 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
   
5. 141002  3:42:52 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
   
6. 141002  3:42:52 [Note] Server socket created on IP: '0.0.0.0'.
   
7. 141002  3:42:52 [Note] Event Scheduler: Loaded 0 events
   
8. 141002  3:42:52 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
   
9. Version: '5.5.37-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
   
10. 141002  3:45:36 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown
    
11. 
    
12. 141002  3:45:36 [Note] Event Scheduler: Purging the queue. 0 events
    
13. 141002  3:45:38 [Warning] /usr/local/mysql/bin/mysqld: Forcing close of thread 445  user: 'aiqu'
    
14. 
    
15. 141002  3:45:38 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
    
16. 
    
17. 141002 03:45:38 mysqld_safe mysqld from pid file /usr/local/mysql/var/li759-91.pid ended
    
18. 141002 03:45:40 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
    
19. 141002  3:45:40 [ERROR] Function 'innodb' already exists
    
20. 141002  3:45:40 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
    
21. 141002  3:45:40 InnoDB: The InnoDB memory heap is disabled
    
22. 141002  3:45:40 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    
23. 141002  3:45:40 InnoDB: Compressed tables use zlib 1.2.3
    
24. 141002  3:45:40 InnoDB: Initializing buffer pool, size = 16.0M
    
25. 141002  3:45:40 InnoDB: Completed initialization of buffer pool
    
26. 141002  3:45:40 InnoDB: highest supported file format is Barracuda.
    
27. 141002  3:45:40  InnoDB: Waiting for the background threads to start
    
28. 141002  3:45:41 InnoDB: 5.5.37 started; log sequence number 32582219
    
29. 141002  3:45:41 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    
30. 141002  3:45:41 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    
31. 141002  3:45:41 [Note] Server socket created on IP: '0.0.0.0'.
    
32. 141002  3:45:41 [Note] Event Scheduler: Loaded 0 events
    
33. 141002  3:45:41 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
    
34. Version: '5.5.37'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
    
35. 141002  3:51:34 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown
    
36. 
    
37. 141002  3:51:34 [Note] Event Scheduler: Purging the queue. 0 events
    
38. 141002  3:51:36 [Warning] /usr/local/mysql/bin/mysqld: Forcing close of thread 1046  user: 'aiqu'
    
39. 
    
40. 141002  3:51:36  InnoDB: Starting shutdown...
    
41. 141002  3:51:36  InnoDB: Shutdown completed; log sequence number 32582219
    
42. 141002  3:51:36 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
    
43. 
    
44. 141002 03:51:36 mysqld_safe mysqld from pid file /usr/local/mysql/var/li759-91.pid ended
    
45. 141002 03:51:38 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
    
46. 141002  3:51:38 [Warning] 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.
    
47. 141002  3:51:38 [Note] Plugin 'InnoDB' is disabled.
    
48. 141002  3:51:38 [ERROR] Function 'innodb' already exists
    
49. 141002  3:51:38 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.

复制代码

licess

安装时是否选择了innnodb？
再发一下配置文件看看

monface

default-storage-engine现在只能设置MyISAM，一旦设置InnoDB，就报上面的错误。

licess

可能安装时没选innodb吧

monface

军哥，安装的时候肯定选择了innodb的，我换回默认的my.cnf就是innodb引擎，但是一旦还4G这个，就必须选myisam才行

monface

请问是哪里问题？？？

monface

找到原因了，因为开始都开启了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就好了