禅道使用
4558

mysql重启失败,查看日志报错“The InnoDB memory heap is disabled”已解决 悬赏20积分

提问者方宝蓉 答案数1 阅读数6570 发表时间2017-03-17 15:19:22
强制关闭mysql,重启失败,查看日志报错“The InnoDB memory heap is disabled”。怎么处理呢,急求

禅道版本:8.4.1

安装包类型:Linux安装包

操作系统:CentOS

客户端浏览器:Chrome

备注
161229 15:15:16 mysqld_safe Starting mysqld daemon with databases from /opt/zbox/data/mysql
161229 15:15:16 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
161229 15:15:16 [Note] /opt/zbox/run/mysql/mysqld (mysqld 5.5.45) starting as process 11097 ...
161229 15:15:16 InnoDB: The InnoDB memory heap is disabled
161229 15:15:16 InnoDB: Mutexes and rw_locks use GCC atomic builtins
161229 15:15:16 InnoDB: Compressed tables use zlib 1.2.3.4
161229 15:15:16 InnoDB: Initializing buffer pool, size = 128.0M
161229 15:15:16 InnoDB: Completed initialization of buffer pool
161229 15:15:16 InnoDB: highest supported file format is Barracuda.
161229 15:15:17  InnoDB: Waiting for the background threads to start
161229 15:15:18 InnoDB: 5.5.45 started; log sequence number 1595745
161229 15:15:18 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
161229 15:15:18 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
161229 15:15:18 [Note] Server socket created on IP: '127.0.0.1'.
161229 15:15:18 [Note] Event Scheduler: Loaded 0 events
161229 15:15:18 [Note] /opt/zbox/run/mysql/mysqld: ready for connections.
Version: '5.5.45'  socket: '/opt/zbox/tmp/mysql/mysql.sock'  port: 3306  Source distribution
161229 15:15:46 [Note] /opt/zbox/run/mysql/mysqld: Normal shutdown

161229 15:15:46 [Note] Event Scheduler: Purging the queue. 0 events
161229 15:15:46  InnoDB: Starting shutdown...
161229 15:15:46  InnoDB: Shutdown completed; log sequence number 1595745
161229 15:15:46 [Note] /opt/zbox/run/mysql/mysqld: Shutdown complete

161229 15:15:46 mysqld_safe mysqld from pid file /opt/zbox/tmp/mysql/mysqld.pid ended
161229 15:16:00 mysqld_safe Starting mysqld daemon with databases from /opt/zbox/data/mysql
161229 15:16:00 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
161229 15:16:00 [Note] /opt/zbox/run/mysql/mysqld (mysqld 5.5.45) starting as process 11556 ...
161229 15:16:00 InnoDB: The InnoDB memory heap is disabled
161229 15:16:00 InnoDB: Mutexes and rw_locks use GCC atomic builtins
161229 15:16:00 InnoDB: Compressed tables use zlib 1.2.3.4
161229 15:16:00 InnoDB: Initializing buffer pool, size = 128.0M
161229 15:16:00 InnoDB: Completed initialization of buffer pool
161229 15:16:00 InnoDB: highest supported file format is Barracuda.
161229 15:16:00  InnoDB: Waiting for the background threads to start
161229 15:16:01 InnoDB: 5.5.45 started; log sequence number 1595745
161229 15:16:01 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
161229 15:16:01 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
161229 15:16:01 [Note] Server socket created on IP: '127.0.0.1'.
161229 15:16:01 [Note] Event Scheduler: Loaded 0 events
161229 15:16:01 [Note] /opt/zbox/run/mysql/mysqld: ready for connections.
Version: '5.5.45'  socket: '/opt/zbox/tmp/mysql/mysql.sock'  port: 3306  Source distribution

设置备注
内容
答案列表
2017-03-17 17:07:12
ls -al /opt/zbox/etc/mysql/  结果发出来看一下。
🎿
2017/03/17
[root@SZB-L0047254 ~]# ls -al /opt/zbox/etc/mysql/
total 4
drwxrwxrwx 2 root root 19 Mar 17 14:42 .
drwxrwxrwx 5 root root 41 Mar 30 2016 ..
-rwxrwxrwx 1 root root 928 Mar 17 15:56 my.cnf
🎿
2017/03/17
更改了my.cnf文件,
default-storage-engine=MyISAM

MyISAM改成INNODB

重启成功。
请问这个修改是否会其他有影响。
2017/03/20
/opt/zbox/etc/mysql/my.cnf 的权限为什么会变成777?改回 644就可以正常启动了。
联系我们
联系人
丁芝/高级客户经理
电话(微信)
17663906485
QQ号码
1481227768
联系邮箱
dingzhi@chandao.com
返回顶部
丁芝
高级客户经理
17663906485
1481227768
统一服务热线 4006-8899-23
我要提问提问有任何问题,您都可以在这里提问。 问题反馈反馈点击这里,让我们聆听您的建议与反馈。