解决Linux上Mysql服务器异常挂掉的一次经历

待我称王封你为后i 2022-04-02 05:42 422阅读 0赞

2018-12-25 14:49:57 25873 \[Note\] Plugin ‘FEDERATED’ is disabled.  
2018-12-25 14:49:57 25873 \[Note\] InnoDB: Using atomics to ref count buffer pool pages  
2018-12-25 14:49:57 25873 \[Note\] InnoDB: The InnoDB memory heap is disabled  
2018-12-25 14:49:57 25873 \[Note\] InnoDB: Mutexes and rw\_locks use GCC atomic builtins  
2018-12-25 14:49:57 25873 \[Note\] InnoDB: Memory barrier is not used  
2018-12-25 14:49:57 25873 \[Note\] InnoDB: Compressed tables use zlib 1.2.11  
2018-12-25 14:49:57 25873 \[Note\] InnoDB: Using Linux native AIO  
2018-12-25 14:49:57 25873 \[Note\] InnoDB: Using CPU crc32 instructions  
2018-12-25 14:49:57 25873 \[Note\] InnoDB: Initializing buffer pool, size = 128.0M  
InnoDB: mmap(137363456 bytes) failed; errno 12  
2018-12-25 14:49:57 25873 \[ERROR\] InnoDB: Cannot allocate memory for the buffer pool  
2018-12-25 14:49:57 25873 \[ERROR\] Plugin ‘InnoDB’ init function returned error.  
2018-12-25 14:49:57 25873 \[ERROR\] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.  
2018-12-25 14:49:57 25873 \[ERROR\] Unknown/unsupported storage engine: InnoDB  
2018-12-25 14:49:57 25873 \[ERROR\] Aborting

2018-12-25 14:49:57 25873 \[Note\] Binlog end  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘partition’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘INNODB\_SYS\_DATAFILES’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘INNODB\_SYS\_TABLESPACES’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘INNODB\_SYS\_FOREIGN\_COLS’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘INNODB\_SYS\_FOREIGN’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘INNODB\_SYS\_FIELDS’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘INNODB\_SYS\_COLUMNS’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘INNODB\_SYS\_INDEXES’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘INNODB\_SYS\_TABLESTATS’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘INNODB\_SYS\_TABLES’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘INNODB\_FT\_INDEX\_TABLE’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘INNODB\_FT\_INDEX\_CACHE’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘INNODB\_FT\_CONFIG’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘INNODB\_FT\_BEING\_DELETED’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘INNODB\_FT\_DELETED’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘INNODB\_FT\_DEFAULT\_STOPWORD’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘INNODB\_METRICS’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘INNODB\_BUFFER\_POOL\_STATS’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘INNODB\_BUFFER\_PAGE\_LRU’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘INNODB\_BUFFER\_PAGE’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘INNODB\_CMP\_PER\_INDEX\_RESET’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘INNODB\_CMP\_PER\_INDEX’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘INNODB\_CMPMEM\_RESET’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘INNODB\_CMPMEM’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘INNODB\_CMP\_RESET’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘INNODB\_CMP’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘INNODB\_LOCK\_WAITS’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘INNODB\_LOCKS’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘INNODB\_TRX’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘PERFORMANCE\_SCHEMA’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘BLACKHOLE’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘ARCHIVE’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘MyISAM’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘CSV’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘MEMORY’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘MRG\_MYISAM’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘sha256\_password’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘mysql\_old\_password’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘mysql\_native\_password’  
2018-12-25 14:49:57 25873 \[Note\] Shutting down plugin ‘binlog’  
2018-12-25 14:49:57 25873 \[Note\] /usr/sbin/mysqld: Shutdown complete

之前一直动不动mysql隔一段时间就挂掉，因为对服务器上mysql的文件不太熟悉，找了很多帖子也没看到原因。  
下面记录一下我解决的经历  
service mysqld start 启动失败  
1.先进入到 var/log/mysql.log （安装的时候linux上默认的路径）  
2. 查看mysql的日志，会发现最近日志的错误记录，为啥失败  
3. 以上是我的错误日志，百度后发现是mysql的默认INNODB分配内存大小为128M，而我买的是最初级的服务器，内存比较小，所有需要调整内存  
4. 进入etc/my.cnf windos系统下配置文件为my.ini  
5. 编辑my.cnf文件 ，在mysql下加入：  
innodb\_buffer\_pool\_size=50M  
6. 保存，启动serivce mysqld start 成功  
7. 当时对这些mysql配置文件不熟，现在想想这问题也挺简单，耽误这么多时间真的是够了。  
8. ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM1MTUyMDM3_size_16_color_FFFFFF_t_70]  
谢谢  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM1MTUyMDM3_size_16_color_FFFFFF_t_70 1]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM1MTUyMDM3_size_16_color_FFFFFF_t_70]: /images/20220402/77ec2d983b4e4231a12fdb9f14824edc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM1MTUyMDM3_size_16_color_FFFFFF_t_70 1]: /images/20220402/92cf0d69184143528b314d6173e5185e.png