开发者社区> 问答> 正文

mysql数据库经常挂掉 这是什么原因


2016-03-12 17:16:11 1193 [Warning] IP address '139.196.30.82' could not be resolved: Name or service not known
2016-03-12 18:01:16 1193 [Warning] IP address '27.50.134.171' could not be resolved: Name or service not known
2016-03-12 20:28:43 1193 [Warning] IP address '218.244.254.49' could not be resolved: Name or service not known
2016-03-12 20:53:44 1193 [Warning] IP address '114.215.239.202' could not be resolved: Name or service not known
2016-03-12 20:54:33 1193 [Warning] IP address '182.92.114.42' could not be resolved: Name or service not known
2016-03-13 04:59:01 1193 [Warning] IP address '114.215.185.137' could not be resolved: Name or service not known
2016-03-13 04:59:01 1193 [Warning] IP address '114.215.185.137' could not be resolved: Name or service not known
2016-03-14 15:08:17 1193 [ERROR] Can't create thread to handle request (errno= 11)
160314 15:08:35 mysqld_safe Number of processes running now: 0
160314 15:08:35 mysqld_safe mysqld restarted
2016-03-14 15:08:36 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-03-14 15:08:36 12753 [Note] Plugin 'FEDERATED' is disabled.
2016-03-14 15:08:36 12753 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-03-14 15:08:36 12753 [Note] InnoDB: The InnoDB memory heap is disabled
2016-03-14 15:08:36 12753 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-03-14 15:08:36 12753 [Note] InnoDB: Memory barrier is not used
2016-03-14 15:08:36 12753 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-03-14 15:08:36 12753 [Note] InnoDB: Using Linux native AIO
2016-03-14 15:08:36 12753 [Note] InnoDB: Using CPU crc32 instructions
2016-03-14 15:08:36 12753 [Note] InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
2016-03-14 15:08:36 12753 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2016-03-14 15:08:36 12753 [ERROR] Plugin 'InnoDB' init function returned error.
2016-03-14 15:08:36 12753 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-03-14 15:08:36 12753 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-03-14 15:08:36 12753 [ERROR] Aborting


2016-03-14 15:08:36 12753 [Note] Binlog end
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'partition'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'BLACKHOLE'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'INNODB_METRICS'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'INNODB_CMP'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'INNODB_TRX'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'ARCHIVE'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'MyISAM'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'CSV'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'MRG_MYISAM'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'MEMORY'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'sha256_password'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'mysql_old_password'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'mysql_native_password'
2016-03-14 15:08:36 12753 [Note] Shutting down plugin 'binlog'
2016-03-14 15:08:36 12753 [Note] /alidata/server/mysql/bin/mysqld: Shutdown complete

展开
收起
芒果柠檬 2016-03-14 17:59:41 18481 0
4 条回答
写回答
取消 提交回答
  • https://gitee.com/minlearn/minlearnprogramming/:minlearn的一云多端云OS/统一编程栈方案。
    用windows加bitnami wordpress stack
    2016-03-17 01:39:06
    赞同 展开评论 打赏
  • 旺旺:nectar2。
    楼主您好,

    三楼的意见可以参考下。

    为您在网上查找,可能有不少类似的案例,如这个: http://www.webtrafficexchange.com/solved-mysql-crash-fatal-error-cannot-allocate-memory-buffer-pool
    2016-03-16 11:06:56
    赞同 展开评论 打赏
  • Remysql数据库经常挂掉 这是什么原因
    这一行 Initializing buffer pool, size = 128.0M
    InnoDB: mmap(137363456 bytes) failed; errno 12

    初始化buffer pool失败,为mysql分配128M的内存不够,修改配置文件 mycnf
    innodb_buffer_pool_size=64M
    或者增大内存
    2016-03-16 10:42:43
    赞同 展开评论 打赏
  • 论坛总版主
    这个应该是插件的问题,有个插件有问题,关闭看看
    2016-03-14 18:15:20
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
冬季实战营第三期:MySQL数据库进阶实战 立即下载
《阿里云数据库 MongoDB 专属集群版》 立即下载
PostgreSQL复制原理及高可用集群 立即下载