阿里云
阿里云多端小程序中小企业获客首选
发表主题 回复主题
  • 3525阅读
  • 3回复

数据库一启动马上就又关闭了

级别: 新人
发帖
13
云币
23
今晚阿里服务的cpu一直占用100%,数据知道关闭,我就手动重启数据库,但是启动之后,马上又关闭了。
贴一段从启动到知道关闭的日志,求分析下什么情况引起的。
服务器的cpu下降之后,就正常了。


  1. 161025 01:55:22 mysqld_safe Number of processes running now: 0
  2. 161025 01:55:22 mysqld_safe mysqld restarted
  3. 2016-10-25 01:55:25 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  4. 2016-10-25 01:55:30 17682 [Note] Plugin 'FEDERATED' is disabled.
  5. 2016-10-25 01:55:31 17682 [Note] InnoDB: Using atomics to ref count buffer pool pages
  6. 2016-10-25 01:55:31 17682 [Note] InnoDB: The InnoDB memory heap is disabled
  7. 2016-10-25 01:55:31 17682 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  8. 2016-10-25 01:55:31 17682 [Note] InnoDB: Memory barrier is not used
  9. 2016-10-25 01:55:31 17682 [Note] InnoDB: Compressed tables use zlib 1.2.3
  10. 2016-10-25 01:55:31 17682 [Note] InnoDB: Using Linux native AIO
  11. 2016-10-25 01:55:31 17682 [Note] InnoDB: Using CPU crc32 instructions
  12. 2016-10-25 01:55:32 17682 [Note] InnoDB: Initializing buffer pool, size = 128.0M
  13. InnoDB: mmap(137363456 bytes) failed; errno 12
  14. 2016-10-25 01:55:32 17682 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
  15. 2016-10-25 01:55:32 17682 [ERROR] Plugin 'InnoDB' init function returned error.
  16. 2016-10-25 01:55:32 17682 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
  17. 2016-10-25 01:55:32 17682 [ERROR] Unknown/unsupported storage engine: InnoDB
  18. 2016-10-25 01:55:32 17682 [ERROR] Aborting
  19. 2016-10-25 01:55:32 17682 [Note] Binlog end
  20. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'partition'
  21. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
  22. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'BLACKHOLE'
  23. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
  24. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  25. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
  26. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
  27. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  28. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  29. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  30. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  31. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  32. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
  33. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
  34. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
  35. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
  36. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  37. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
  38. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'INNODB_METRICS'
  39. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
  40. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
  41. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
  42. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
  43. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
  44. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
  45. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'INNODB_CMPMEM'
  46. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'INNODB_CMP_RESET'
  47. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'INNODB_CMP'
  48. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
  49. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'INNODB_LOCKS'
  50. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'INNODB_TRX'
  51. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'ARCHIVE'
  52. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'MyISAM'
  53. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'CSV'
  54. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'MRG_MYISAM'
  55. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'MEMORY'
  56. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'sha256_password'
  57. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'mysql_old_password'
  58. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'mysql_native_password'
  59. 2016-10-25 01:55:32 17682 [Note] Shutting down plugin 'binlog'
  60. 2016-10-25 01:55:32 17682 [Note] /alidata/server/mysql/bin/mysqld: Shutdown complete
  61. 161025 01:55:32 mysqld_safe mysqld from pid file /alidata/server/mysql/data/AY140716132949Z.pid ended


级别: 论坛版主
发帖
25
云币
34
只看该作者 沙发  发表于: 2016-10-25
去C:\WINDOWS删除MY.INI
试试
级别: 新人
发帖
13
云币
23
只看该作者 板凳  发表于: 2016-10-26
回 1楼kdk的帖子
我是linux的,没有这个文件啊
级别: 小白
发帖
30
云币
32
只看该作者 地板  发表于: 2018-03-09
Re数据库一启动马上就又关闭了
1. 首先 TOP 看一下是哪个进程消耗 ECS CPU。

2. 如果是 mysqld 消耗大量 CPU 的话考虑通过 show processlist 或者 慢日志,或者 官方版本的审计模块 看一下 具体的 SQL。

3. 考虑优化 SQL。
发表主题 回复主题
« 返回列表上一主题下一主题

限100 字节
如果您提交过一次失败了,可以用”恢复数据”来恢复帖子内容
 
验证问题: 50 - 26 = ?
上一个 下一个
      ×
      全新阿里云开发者社区, 去探索开发者的新世界吧!
      一站式的体验,更多的精彩!
      通过下面领域大门,一起探索新的技术世界吧~ (点击图标进入)