学生机,装了一个lamp,搭了一个wordpress,mysql经常崩溃?

  • 回答 (4)
  • 关注 (0)
  • 查看 (206)

学生机,装了一个lamp,搭了一个wordpress,mysql经常崩溃平时内存占用在800m左右差不多几天,mysql就会崩溃,打开网页显示连接数据库出错,重启服务器才能正常谁能帮我看下mysql的错误日志怎么解决170112 170541 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended170112 170542 mysqld_safe Logging to '/var/log/mysqld.log'.170112 170542 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql2017-01-12 170542 0 Warning TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2017-01-12 170542 0 Note /usr/sbin/mysqld (mysqld 5.6.35) starting as process 10005 ...2017-01-12 170542 10005 Note Plugin 'FEDERATED' is disabled.2017-01-12 170542 10005 Note InnoDB: Using atomics to ref count buffer pool pages2017-01-12 170542 10005 Note InnoDB: The InnoDB memory heap is disabled2017-01-12 170542 10005 Note InnoDB: Mutexes and rw_locks use GCC atomic builtins2017-01-12 170542 10005 Note InnoDB: Memory barrier is not used2017-01-12 170542 10005 Note InnoDB: Compressed tables use zlib 1.2.32017-01-12 170542 10005 Note InnoDB: Using Linux native AIO2017-01-12 170542 10005 Note InnoDB: Using CPU crc32 instructions2017-01-12 170542 10005 Note InnoDB: Initializing buffer pool, size = 128.0MInnoDB: mmap(137363456 bytes) failed; errno 122017-01-12 170542 10005 ERROR InnoDB: Cannot allocate memory for the buffer pool2017-01-12 170542 10005 ERROR Plugin 'InnoDB' init function returned error.2017-01-12 170542 10005 ERROR Plugin 'InnoDB' registration as a STORAGE ENGINE failed.2017-01-12 170542 10005 ERROR Unknown/unsupported storage engine: InnoDB2017-01-12 170542 10005 ERROR Aborting2017-01-12 170542 10005 Note Binlog end2017-01-12 170542 10005 Note Shutting down plugin 'partition'2017-01-12 170542 10005 Note Shutting down plugin 'PERFORMANCE_SCHEMA'2017-01-12 170542 10005 Note Shutting down plugin 'INNODB_SYS_DATAFILES'2017-01-12 170542 10005 Note Shutting down plugin 'INNODB_SYS_TABLESPACES'2017-01-12 170542 10005 Note Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'2017-01-12 170542 10005 Note Shutting down plugin 'INNODB_SYS_FOREIGN'2017-01-12 170542 10005 Note Shutting down plugin 'INNODB_SYS_FIELDS'2017-01-12 170542 10005 Note Shutting down plugin 'INNODB_SYS_COLUMNS'2017-01-12 170542 10005 Note Shutting down plugin 'INNODB_SYS_INDEXES'2017-01-12 170542 10005 Note Shutting down plugin 'INNODB_SYS_TABLESTATS'2017-01-12 170542 10005 Note Shutting down plugin 'INNODB_SYS_TABLES'2017-01-12 170542 10005 Note Shutting down plugin 'INNODB_FT_INDEX_TABLE'2017-01-12 170542 10005 Note Shutting down plugin 'INNODB_FT_INDEX_CACHE'2017-01-12 170542 10005 Note Shutting down plugin 'INNODB_FT_CONFIG'2017-01-12 170542 10005 Note Shutting down plugin 'INNODB_FT_BEING_DELETED'2017-01-12 170542 10005 Note Shutting down plugin 'INNODB_FT_DELETED'2017-01-12 170542 10005 Note Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'2017-01-12 170542 10005 Note Shutting down plugin 'INNODB_METRICS'2017-01-12 170542 10005 Note Shutting down plugin 'INNODB_BUFFER_POOL_STATS'2017-01-12 170542 10005 Note Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'2017-01-12 170542 10005 Note Shutting down plugin 'INNODB_BUFFER_PAGE'2017-01-12 170542 10005 Note Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'2017-01-12 170542 10005 Note Shutting down plugin 'INNODB_CMP_PER_INDEX'2017-01-12 170542 10005 Note Shutting down plugin 'INNODB_CMPMEM_RESET'2017-01-12 170542 10005 Note Shutting down plugin 'INNODB_CMPMEM'2017-01-12 170542 10005 Note Shutting down plugin 'INNODB_CMP_RESET'2017-01-12 170542 10005 Note Shutting down plugin 'INNODB_CMP'2017-01-12 170542 10005 Note Shutting down plugin 'INNODB_LOCK_WAITS'2017-01-12 170542 10005 Note Shutting down plugin 'INNODB_LOCKS'2017-01-12 170542 10005 Note Shutting down plugin 'INNODB_TRX'2017-01-12 170542 10005 Note Shutting down plugin 'BLACKHOLE'2017-01-12 170542 10005 Note Shutting down plugin 'ARCHIVE'2017-01-12 170542 10005 Note Shutting down plugin 'MRG_MYISAM'2017-01-12 170542 10005 Note Shutting down plugin 'MyISAM'2017-01-12 170542 10005 Note Shutting down plugin 'MEMORY'2017-01-12 170542 10005 Note Shutting down plugin 'CSV'2017-01-12 170542 10005 Note Shutting down plugin 'sha256_password'2017-01-12 170542 10005 Note Shutting down plugin 'mysql_old_password'2017-01-12 170542 10005 Note Shutting down plugin 'mysql_native_password'2017-01-12 170542 10005 Note Shutting down plugin 'binlog'2017-01-12 170542 10005 Note /usr/sbin/mysqld: Shutdown complete

天空$之蓝天空$之蓝提问于
上帝没注意回答于

内存不够了吧,InnoDB: Initializing buffer pool, size = 128.0M

InnoDB: mmap(137363456 bytes) failed; errno 12

你看看运行了什么占很大内存的程序,照理说不应该

公子扶苏回答于

丢了 lamp ,换成 hhvm ,保证你跑1年都不需要重启机器!

Darker我要发出我的死亡通知单了!回答于

1.检查mysql占用情况!命令

top

2.检查是否在安装在用环境之前安装过mysql

3.建议在纯净系统中重装安装环境!

回答于

WP本就是一个高占用的一个程序,2核2G勉强跑起来

扫码关注云+社区

领取腾讯云代金券