“Mysql8源码安装”与“Mysql Can't find messagefile errmsg.sys解决方法”:页面之间的差异
(页面间差异)
小 导入1个版本 |
小 导入1个版本 |
||
第1行: | 第1行: | ||
mysql Can't find messagefile errmsg.sys解决方法 | |||
[ | =故障来了= | ||
<pre> | |||
mysql 启动不了 ,报错如下 | |||
[root@ ~]# /etc/init.d/mysqld start | |||
Starting MySQL.. ERROR! The server quit without updating PID file (/usr/local/mysql/data/vultr.guest.pid). </pre> | |||
[ | =分析处理过程= | ||
<pre> | |||
为了查看深入而不表面的原因 当然是得查看 err log嘛 | |||
[root@ ~]# cat /data/mysqld-error.log | |||
[[category:mysql]] | 171024 03:12:11 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data | ||
171024 3:12:11 [ERROR] Can't find messagefile '/usr/local/mysql/share/errmsg.sys' | |||
171024 3:12:11 InnoDB: The InnoDB memory heap is disabled | |||
171024 3:12:11 InnoDB: Mutexes and rw_locks use GCC atomic builtins | |||
171024 3:12:11 InnoDB: Compressed tables use zlib 1.2.3 | |||
171024 3:12:11 InnoDB: Initializing buffer pool, size = 16.0M | |||
171024 3:12:11 InnoDB: Completed initialization of buffer pool | |||
171024 3:12:11 InnoDB: highest supported file format is Barracuda. | |||
171024 3:12:11 InnoDB: Waiting for the background threads to start | |||
171024 3:12:12 InnoDB: 1.1.8 started; log sequence number 6183085273 | |||
171024 3:12:12 [ERROR] Aborting | |||
171024 3:12:12 InnoDB: Starting shutdown... | |||
171024 3:12:12 InnoDB: Shutdown completed; log sequence number 6183085273 | |||
网上查看了很多方法 很多 小伙伴还说是内存问题 哈哈 那为什么以前才512M ram都可以 跑呢 而现在 1G ram不能跑 哈哈 | |||
实在没办法 我打算重新编译安装一个新的mysql ,但不和老的同目录的,但是后来试一下 将源码包里面的sql/share/ 复制到 mysql/share 就好 ,回想起来 可能是我上次不小心删除了 share目录 | |||
</pre> | |||
=参考= | |||
[[category:mysql]] |
2019年10月14日 (一) 13:52的最新版本
mysql Can't find messagefile errmsg.sys解决方法
故障来了
mysql 启动不了 ,报错如下 [root@ ~]# /etc/init.d/mysqld start Starting MySQL.. ERROR! The server quit without updating PID file (/usr/local/mysql/data/vultr.guest.pid).
分析处理过程
为了查看深入而不表面的原因 当然是得查看 err log嘛 [root@ ~]# cat /data/mysqld-error.log 171024 03:12:11 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 171024 3:12:11 [ERROR] Can't find messagefile '/usr/local/mysql/share/errmsg.sys' 171024 3:12:11 InnoDB: The InnoDB memory heap is disabled 171024 3:12:11 InnoDB: Mutexes and rw_locks use GCC atomic builtins 171024 3:12:11 InnoDB: Compressed tables use zlib 1.2.3 171024 3:12:11 InnoDB: Initializing buffer pool, size = 16.0M 171024 3:12:11 InnoDB: Completed initialization of buffer pool 171024 3:12:11 InnoDB: highest supported file format is Barracuda. 171024 3:12:11 InnoDB: Waiting for the background threads to start 171024 3:12:12 InnoDB: 1.1.8 started; log sequence number 6183085273 171024 3:12:12 [ERROR] Aborting 171024 3:12:12 InnoDB: Starting shutdown... 171024 3:12:12 InnoDB: Shutdown completed; log sequence number 6183085273 网上查看了很多方法 很多 小伙伴还说是内存问题 哈哈 那为什么以前才512M ram都可以 跑呢 而现在 1G ram不能跑 哈哈 实在没办法 我打算重新编译安装一个新的mysql ,但不和老的同目录的,但是后来试一下 将源码包里面的sql/share/ 复制到 mysql/share 就好 ,回想起来 可能是我上次不小心删除了 share目录