好久不玩的服务器，突然想起来用一下，发现数据库关闭了，就去启动，结果却一直报错，在这里记录一下
- 通过配置文件找到日志文件，命令：
cat /usr/local/mysql/my.cnf
- 找到日志文件所在的路径；
log-error=/usr/local/mysql/mysqld.errorlog
- 打开日志文件
cat /usr/local/mysql/mysqld.errorlog
- 查到如下信息
190327 15:07:11 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
2019-03-27 15:07:11 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-03-27 15:07:11 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.6.29) starting as process 23465 ...
2019-03-27 15:07:11 23465 [Note] Plugin 'FEDERATED' is disabled.
2019-03-27 15:07:11 23465 [Note] InnoDB: Using atomics to ref count buffer pool pages
2019-03-27 15:07:11 23465 [Note] InnoDB: The InnoDB memory heap is disabled
2019-03-27 15:07:11 23465 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-03-27 15:07:11 23465 [Note] InnoDB: Memory barrier is not used
2019-03-27 15:07:11 23465 [Note] InnoDB: Compressed tables use zlib 1.2.3
2019-03-27 15:07:11 23465 [Note] InnoDB: Using CPU crc32 instructions
2019-03-27 15:07:11 23465 [Note] InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
2019-03-27 15:07:11 23465 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2019-03-27 15:07:11 23465 [ERROR] Plugin 'InnoDB' init function returned error.
2019-03-27 15:07:11 23465 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-03-27 15:07:11 23465 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-03-27 15:07:11 23465 [ERROR] Aborting
2019-03-27 15:07:11 23465 [Note] Binlog end
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'partition'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'BLACKHOLE'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'ARCHIVE'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'INNODB_METRICS'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
▽
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'INNODB_CMPMEM'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'INNODB_CMP'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'INNODB_LOCKS'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'INNODB_TRX'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'MRG_MYISAM'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'MyISAM'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'CSV'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'MEMORY'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'sha256_password'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'mysql_old_password'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'mysql_native_password'
2019-03-27 15:07:11 23465 [Note] Shutting down plugin 'binlog'
2019-03-27 15:07:11 23465 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
190327 15:07:11 mysqld_safe mysqld from pid file /usr/local/mysql/data/VM_0_3_centos.pid ended
- 看到
Cannot allocate memory for the buffer pool的错误信息，觉得是内存的问题，所以将 Tomcat 重启一下
cd /usr/local/tomcat/tomcat8
./shutdown.sh
./startup.sh
- 然后启动 MySQL
cd /usr/local/mysql/support-files/
./mysql.server start
- 启动成功，问题解决
网友评论