VPS侦探论坛

 找回密码
 注册
查看: 541|回复: 7

最近数据库无缘无故中断,导致网站连接不上

[复制链接]
发表于 2023-9-1 15:54:24 | 显示全部楼层 |阅读模式

如标题:本周一直出现这个现象,显示:ERROR! MySQL server PID file could not be found!,每次都要重启数据库,但这样也不是方法,网上百度教程也查了原因,但还是无法解决。我看了一下服务器内存还是够用的,下面是mysql出错日志,不是很会看

  1. 2023-09-01 03:51:20 7347 [Note] Plugin 'FEDERATED' is disabled.
  2. 2023-09-01 03:51:20 7347 [Note] InnoDB: Using atomics to ref count buffer pool pages
  3. 2023-09-01 03:51:20 7347 [Note] InnoDB: The InnoDB memory heap is disabled
  4. 2023-09-01 03:51:20 7347 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  5. 2023-09-01 03:51:20 7347 [Note] InnoDB: Memory barrier is not used
  6. 2023-09-01 03:51:20 7347 [Note] InnoDB: Compressed tables use zlib 1.2.11
  7. 2023-09-01 03:51:20 7347 [Note] InnoDB: Using Linux native AIO
  8. 2023-09-01 03:51:20 7347 [Note] InnoDB: Not using CPU crc32 instructions
  9. 2023-09-01 03:51:20 7347 [Note] InnoDB: Initializing buffer pool, size = 256.0M
  10. 2023-09-01 03:51:20 7347 [Note] InnoDB: Completed initialization of buffer pool
  11. 2023-09-01 03:51:20 7347 [Note] InnoDB: Highest supported file format is Barracuda.
  12. 2023-09-01 03:51:20 7347 [Note] InnoDB: The log sequence numbers 974900664 and 974900664 in ibdata files do not match the log sequence number 978023737 in the ib_logfiles!
  13. 2023-09-01 03:51:20 7347 [Note] InnoDB: Database was not shutdown normally!
  14. 2023-09-01 03:51:20 7347 [Note] InnoDB: Starting crash recovery.
  15. 2023-09-01 03:51:20 7347 [Note] InnoDB: Reading tablespace information from the .ibd files...
  16. 2023-09-01 03:51:20 7347 [Note] InnoDB: Restoring possible half-written data pages
  17. 2023-09-01 03:51:20 7347 [Note] InnoDB: from the doublewrite buffer...
  18. InnoDB: Last MySQL binlog file position 0 663425, file name mysql-bin.000047
  19. 2023-09-01 03:51:20 7347 [Note] InnoDB: 128 rollback segment(s) are active.
  20. 2023-09-01 03:51:20 7347 [Note] InnoDB: Waiting for purge to start
  21. 2023-09-01 03:51:20 7347 [Note] InnoDB: 5.6.51 started; log sequence number 978023737
  22. 2023-09-01 03:51:20 7347 [Note] Recovering after a crash using mysql-bin
  23. 2023-09-01 03:51:21 7347 [Note] Starting crash recovery...
  24. 2023-09-01 03:51:21 7347 [Note] Crash recovery finished.
  25. 2023-09-01 03:51:21 7347 [Note] RSA private key file not found: /usr/local/mysql/var//private_key.pem. Some authentication plugins will not work.
  26. 2023-09-01 03:51:21 7347 [Note] RSA public key file not found: /usr/local/mysql/var//public_key.pem. Some authentication plugins will not work.
  27. 2023-09-01 03:51:21 7347 [Note] Server hostname (bind-address): '*'; port: 3306
  28. 2023-09-01 03:51:21 7347 [Note] IPv6 is available.
  29. 2023-09-01 03:51:21 7347 [Note]   - '::' resolves to '::';
  30. 2023-09-01 03:51:21 7347 [Note] Server socket created on IP: '::'.
  31. 2023-09-01 03:51:21 7347 [Note] Event Scheduler: Loaded 0 events
  32. 2023-09-01 03:51:21 7347 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
  33. Version: '5.6.51-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
  34. 2023-09-01 03:51:24 7384 [Note] Plugin 'FEDERATED' is disabled.
  35. 2023-09-01 03:51:24 7384 [Note] InnoDB: Using atomics to ref count buffer pool pages
  36. 2023-09-01 03:51:24 7384 [Note] InnoDB: The InnoDB memory heap is disabled
  37. 2023-09-01 03:51:24 7384 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  38. 2023-09-01 03:51:24 7384 [Note] InnoDB: Memory barrier is not used
  39. 2023-09-01 03:51:24 7384 [Note] InnoDB: Compressed tables use zlib 1.2.11
  40. 2023-09-01 03:51:24 7384 [Note] InnoDB: Using Linux native AIO
  41. 2023-09-01 03:51:24 7384 [Note] InnoDB: Not using CPU crc32 instructions
  42. 2023-09-01 03:51:24 7384 [Note] InnoDB: Initializing buffer pool, size = 256.0M
  43. 2023-09-01 03:51:24 7384 [Note] InnoDB: Completed initialization of buffer pool
  44. 2023-09-01 03:51:24 7384 [Note] InnoDB: Highest supported file format is Barracuda.
  45. 2023-09-01 03:51:24 7384 [Note] InnoDB: The log sequence numbers 974900664 and 974900664 in ibdata files do not match the log sequence number 978023747 in the ib_logfiles!
  46. 2023-09-01 03:51:24 7384 [Note] InnoDB: Database was not shutdown normally!
  47. 2023-09-01 03:51:24 7384 [Note] InnoDB: Starting crash recovery.
  48. 2023-09-01 03:51:24 7384 [Note] InnoDB: Reading tablespace information from the .ibd files...
  49. 2023-09-01 03:51:24 7384 [Note] InnoDB: Restoring possible half-written data pages
  50. 2023-09-01 03:51:24 7384 [Note] InnoDB: from the doublewrite buffer...
  51. InnoDB: Last MySQL binlog file position 0 663425, file name mysql-bin.000047
  52. 2023-09-01 03:51:25 7384 [Note] InnoDB: 128 rollback segment(s) are active.
  53. 2023-09-01 03:51:25 7384 [Note] InnoDB: Waiting for purge to start
  54. 2023-09-01 03:51:25 7384 [Note] InnoDB: 5.6.51 started; log sequence number 978023747
  55. 2023-09-01 03:51:25 7384 [Note] Recovering after a crash using mysql-bin
  56. 2023-09-01 03:51:25 7384 [Note] Starting crash recovery...
  57. 2023-09-01 03:51:25 7384 [Note] Crash recovery finished.
  58. 2023-09-01 03:51:25 7384 [Note] RSA private key file not found: /usr/local/mysql/var//private_key.pem. Some authentication plugins will not work.
  59. 2023-09-01 03:51:25 7384 [Note] RSA public key file not found: /usr/local/mysql/var//public_key.pem. Some authentication plugins will not work.
  60. 2023-09-01 03:51:25 7384 [Note] Server hostname (bind-address): '*'; port: 3306
  61. 2023-09-01 03:51:25 7384 [Note] IPv6 is available.
  62. 2023-09-01 03:51:25 7384 [Note]   - '::' resolves to '::';
  63. 2023-09-01 03:51:25 7384 [Note] Server socket created on IP: '::'.
  64. 2023-09-01 03:51:25 7384 [Note] Event Scheduler: Loaded 0 events
  65. 2023-09-01 03:51:25 7384 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
  66. Version: '5.6.51-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
  67. 2023-09-01 03:51:55 7433 [Note] Plugin 'FEDERATED' is disabled.
  68. 2023-09-01 03:51:55 7433 [Note] InnoDB: Using atomics to ref count buffer pool pages
  69. 2023-09-01 03:51:55 7433 [Note] InnoDB: The InnoDB memory heap is disabled
  70. 2023-09-01 03:51:55 7433 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  71. 2023-09-01 03:51:55 7433 [Note] InnoDB: Memory barrier is not used
  72. 2023-09-01 03:51:55 7433 [Note] InnoDB: Compressed tables use zlib 1.2.11
  73. 2023-09-01 03:51:55 7433 [Note] InnoDB: Using Linux native AIO
  74. 2023-09-01 03:51:55 7433 [Note] InnoDB: Not using CPU crc32 instructions
  75. 2023-09-01 03:51:55 7433 [Note] InnoDB: Initializing buffer pool, size = 256.0M
  76. 2023-09-01 03:51:55 7433 [Note] InnoDB: Completed initialization of buffer pool
  77. 2023-09-01 03:51:55 7433 [Note] InnoDB: Highest supported file format is Barracuda.
  78. 2023-09-01 03:51:55 7433 [Note] InnoDB: The log sequence numbers 974900664 and 974900664 in ibdata files do not match the log sequence number 978024421 in the ib_logfiles!
  79. 2023-09-01 03:51:55 7433 [Note] InnoDB: Database was not shutdown normally!
  80. 2023-09-01 03:51:55 7433 [Note] InnoDB: Starting crash recovery.
  81. 2023-09-01 03:51:55 7433 [Note] InnoDB: Reading tablespace information from the .ibd files...
  82. 2023-09-01 03:51:55 7433 [Note] InnoDB: Restoring possible half-written data pages
  83. 2023-09-01 03:51:55 7433 [Note] InnoDB: from the doublewrite buffer...
  84. InnoDB: Last MySQL binlog file position 0 472, file name mysql-bin.000049
  85. 2023-09-01 03:51:55 7433 [Note] InnoDB: 128 rollback segment(s) are active.
  86. 2023-09-01 03:51:55 7433 [Note] InnoDB: Waiting for purge to start
  87. 2023-09-01 03:51:55 7433 [Note] InnoDB: 5.6.51 started; log sequence number 978024421
  88. 2023-09-01 03:51:55 7433 [Note] Recovering after a crash using mysql-bin
  89. 2023-09-01 03:51:55 7433 [Note] Starting crash recovery...
  90. 2023-09-01 03:51:55 7433 [Note] Crash recovery finished.
  91. 2023-09-01 03:51:55 7433 [Note] RSA private key file not found: /usr/local/mysql/var//private_key.pem. Some authentication plugins will not work.
  92. 2023-09-01 03:51:55 7433 [Note] RSA public key file not found: /usr/local/mysql/var//public_key.pem. Some authentication plugins will not work.
  93. 2023-09-01 03:51:55 7433 [Note] Server hostname (bind-address): '*'; port: 3306
  94. 2023-09-01 03:51:55 7433 [Note] IPv6 is available.
  95. 2023-09-01 03:51:55 7433 [Note]   - '::' resolves to '::';
  96. 2023-09-01 03:51:55 7433 [Note] Server socket created on IP: '::'.
  97. 2023-09-01 03:51:56 7433 [Note] Event Scheduler: Loaded 0 events
  98. 2023-09-01 03:51:56 7433 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
复制代码




美国VPS推荐: 遨游主机LinodeLOCVPS主机云搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
 楼主| 发表于 2023-9-1 15:54:55 | 显示全部楼层


  1. Version: '5.6.51-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
  2. 2023-09-01 03:52:09 7500 [Note] Plugin 'FEDERATED' is disabled.
  3. 2023-09-01 03:52:09 7500 [Note] InnoDB: Using atomics to ref count buffer pool pages
  4. 2023-09-01 03:52:09 7500 [Note] InnoDB: The InnoDB memory heap is disabled
  5. 2023-09-01 03:52:09 7500 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  6. 2023-09-01 03:52:09 7500 [Note] InnoDB: Memory barrier is not used
  7. 2023-09-01 03:52:09 7500 [Note] InnoDB: Compressed tables use zlib 1.2.11
  8. 2023-09-01 03:52:09 7500 [Note] InnoDB: Using Linux native AIO
  9. 2023-09-01 03:52:09 7500 [Note] InnoDB: Not using CPU crc32 instructions
  10. 2023-09-01 03:52:09 7500 [Note] InnoDB: Initializing buffer pool, size = 256.0M
  11. 2023-09-01 03:52:09 7500 [Note] InnoDB: Completed initialization of buffer pool
  12. 2023-09-01 03:52:09 7500 [Note] InnoDB: Highest supported file format is Barracuda.
  13. 2023-09-01 03:52:09 7500 [Note] InnoDB: The log sequence numbers 974900664 and 974900664 in ibdata files do not match the log sequence number 978024461 in the ib_logfiles!
  14. 2023-09-01 03:52:09 7500 [Note] InnoDB: Database was not shutdown normally!
  15. 2023-09-01 03:52:09 7500 [Note] InnoDB: Starting crash recovery.
  16. 2023-09-01 03:52:09 7500 [Note] InnoDB: Reading tablespace information from the .ibd files...
  17. 2023-09-01 03:52:09 7500 [Note] InnoDB: Restoring possible half-written data pages
  18. 2023-09-01 03:52:09 7500 [Note] InnoDB: from the doublewrite buffer...
  19. InnoDB: Last MySQL binlog file position 0 472, file name mysql-bin.000049
  20. 2023-09-01 03:52:09 7500 [Note] InnoDB: 128 rollback segment(s) are active.
  21. 2023-09-01 03:52:09 7500 [Note] InnoDB: Waiting for purge to start
  22. 2023-09-01 03:52:09 7500 [Note] InnoDB: 5.6.51 started; log sequence number 978024461
  23. 2023-09-01 03:52:09 7500 [Note] Recovering after a crash using mysql-bin
  24. 2023-09-01 03:52:09 7500 [Note] Starting crash recovery...
  25. 2023-09-01 03:52:09 7500 [Note] Crash recovery finished.
  26. 2023-09-01 03:52:09 7500 [Note] RSA private key file not found: /usr/local/mysql/var//private_key.pem. Some authentication plugins will not work.
  27. 2023-09-01 03:52:09 7500 [Note] RSA public key file not found: /usr/local/mysql/var//public_key.pem. Some authentication plugins will not work.
  28. 2023-09-01 03:52:09 7500 [Note] Server hostname (bind-address): '*'; port: 3306
  29. 2023-09-01 03:52:09 7500 [Note] IPv6 is available.
  30. 2023-09-01 03:52:09 7500 [Note] - '::' resolves to '::';
  31. 2023-09-01 03:52:09 7500 [Note] Server socket created on IP: '::'.
  32. 2023-09-01 03:52:09 7500 [Note] Event Scheduler: Loaded 0 events
  33. 2023-09-01 03:52:09 7500 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
  34. Version: '5.6.51-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
  35. 2023-09-01 03:52:11 7537 [Note] Plugin 'FEDERATED' is disabled.
  36. 2023-09-01 03:52:11 7537 [Note] InnoDB: Using atomics to ref count buffer pool pages
  37. 2023-09-01 03:52:11 7537 [Note] InnoDB: The InnoDB memory heap is disabled
  38. 2023-09-01 03:52:11 7537 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  39. 2023-09-01 03:52:11 7537 [Note] InnoDB: Memory barrier is not used
  40. 2023-09-01 03:52:11 7537 [Note] InnoDB: Compressed tables use zlib 1.2.11
  41. 2023-09-01 03:52:11 7537 [Note] InnoDB: Using Linux native AIO
  42. 2023-09-01 03:52:11 7537 [Note] InnoDB: Not using CPU crc32 instructions
  43. 2023-09-01 03:52:11 7537 [Note] InnoDB: Initializing buffer pool, size = 256.0M
  44. 2023-09-01 03:52:11 7537 [Note] InnoDB: Completed initialization of buffer pool
  45. 2023-09-01 03:52:12 7537 [Note] InnoDB: Highest supported file format is Barracuda.
  46. 2023-09-01 03:52:12 7537 [Note] InnoDB: Log scan progressed past the checkpoint lsn 978024461
  47. 2023-09-01 03:52:12 7537 [Note] InnoDB: Database was not shutdown normally!
  48. 2023-09-01 03:52:12 7537 [Note] InnoDB: Starting crash recovery.
  49. 2023-09-01 03:52:12 7537 [Note] InnoDB: Reading tablespace information from the .ibd files...
  50. 2023-09-01 03:52:12 7537 [Note] InnoDB: Restoring possible half-written data pages
  51. 2023-09-01 03:52:12 7537 [Note] InnoDB: from the doublewrite buffer...
  52. InnoDB: Doing recovery: scanned up to log sequence number 978024471
  53. InnoDB: Last MySQL binlog file position 0 472, file name mysql-bin.000049
  54. 2023-09-01 03:52:12 7537 [Note] InnoDB: 128 rollback segment(s) are active.
  55. 2023-09-01 03:52:12 7537 [Note] InnoDB: Waiting for purge to start
  56. 2023-09-01 03:52:12 7537 [Note] InnoDB: 5.6.51 started; log sequence number 978024471
  57. 2023-09-01 03:52:12 7537 [Note] Recovering after a crash using mysql-bin
  58. 2023-09-01 03:52:12 7537 [Note] Starting crash recovery...
  59. 2023-09-01 03:52:12 7537 [Note] Crash recovery finished.
  60. 2023-09-01 03:52:12 7537 [Note] RSA private key file not found: /usr/local/mysql/var//private_key.pem. Some authentication plugins will not work.
  61. 2023-09-01 03:52:12 7537 [Note] RSA public key file not found: /usr/local/mysql/var//public_key.pem. Some authentication plugins will not work.
  62. 2023-09-01 03:52:12 7537 [Note] Server hostname (bind-address): '*'; port: 3306
  63. 2023-09-01 03:52:12 7537 [Note] IPv6 is available.
  64. 2023-09-01 03:52:12 7537 [Note] - '::' resolves to '::';
  65. 2023-09-01 03:52:12 7537 [Note] Server socket created on IP: '::'.
  66. 2023-09-01 03:52:13 7572 [Note] Plugin 'FEDERATED' is disabled.
  67. 2023-09-01 03:52:13 7572 [Note] InnoDB: Using atomics to ref count buffer pool pages
  68. 2023-09-01 03:52:13 7572 [Note] InnoDB: The InnoDB memory heap is disabled
  69. 2023-09-01 03:52:13 7572 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  70. 2023-09-01 03:52:13 7572 [Note] InnoDB: Memory barrier is not used
  71. 2023-09-01 03:52:13 7572 [Note] InnoDB: Compressed tables use zlib 1.2.11
  72. 2023-09-01 03:52:13 7572 [Note] InnoDB: Using Linux native AIO
  73. 2023-09-01 03:52:13 7572 [Note] InnoDB: Not using CPU crc32 instructions
  74. 2023-09-01 03:52:13 7572 [Note] InnoDB: Initializing buffer pool, size = 256.0M
  75. 2023-09-01 03:52:13 7572 [Note] InnoDB: Completed initialization of buffer pool
  76. 2023-09-01 03:52:13 7572 [Note] InnoDB: Highest supported file format is Barracuda.
  77. 2023-09-01 03:52:13 7572 [Note] InnoDB: Log scan progressed past the checkpoint lsn 978024461
  78. 2023-09-01 03:52:13 7572 [Note] InnoDB: Database was not shutdown normally!
  79. 2023-09-01 03:52:13 7572 [Note] InnoDB: Starting crash recovery.
  80. 2023-09-01 03:52:13 7572 [Note] InnoDB: Reading tablespace information from the .ibd files...
  81. 2023-09-01 08:59:05 17387 [Note] Plugin 'FEDERATED' is disabled.
  82. 2023-09-01 08:59:05 17387 [Note] InnoDB: Using atomics to ref count buffer pool pages
  83. 2023-09-01 08:59:05 17387 [Note] InnoDB: The InnoDB memory heap is disabled
  84. 2023-09-01 08:59:05 17387 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  85. 2023-09-01 08:59:05 17387 [Note] InnoDB: Memory barrier is not used
  86. 2023-09-01 08:59:05 17387 [Note] InnoDB: Compressed tables use zlib 1.2.11
  87. 2023-09-01 08:59:05 17387 [Note] InnoDB: Using Linux native AIO
  88. 2023-09-01 08:59:05 17387 [Note] InnoDB: Not using CPU crc32 instructions
  89. 2023-09-01 08:59:05 17387 [Note] InnoDB: Initializing buffer pool, size = 256.0M
  90. 2023-09-01 08:59:05 17387 [Note] InnoDB: Completed initialization of buffer pool
  91. 2023-09-01 08:59:05 17387 [Note] InnoDB: Highest supported file format is Barracuda.
  92. 2023-09-01 08:59:05 17387 [Note] InnoDB: Log scan progressed past the checkpoint lsn 978024461
  93. 2023-09-01 08:59:05 17387 [Note] InnoDB: Database was not shutdown normally!
  94. 2023-09-01 08:59:05 17387 [Note] InnoDB: Starting crash recovery.
  95. 2023-09-01 08:59:05 17387 [Note] InnoDB: Reading tablespace information from the .ibd files...
  96. 2023-09-01 08:59:05 17387 [Note] InnoDB: Restoring possible half-written data pages
  97. 2023-09-01 08:59:05 17387 [Note] InnoDB: from the doublewrite buffer...
  98. InnoDB: Doing recovery: scanned up to log sequence number 978024471
  99. InnoDB: Last MySQL binlog file position 0 472, file name mysql-bin.000049
  100. 2023-09-01 08:59:05 17387 [Note] InnoDB: 128 rollback segment(s) are active.
  101. 2023-09-01 08:59:05 17387 [Note] InnoDB: Waiting for purge to start
  102. 2023-09-01 08:59:05 17387 [Note] InnoDB: 5.6.51 started; log sequence number 978024471
  103. 2023-09-01 08:59:05 17387 [Note] Recovering after a crash using mysql-bin
  104. 2023-09-01 08:59:05 17387 [Note] Starting crash recovery...
  105. 2023-09-01 08:59:05 17387 [Note] Crash recovery finished.
  106. 2023-09-01 08:59:05 17387 [Note] RSA private key file not found: /usr/local/mysql/var//private_key.pem. Some authentication plugins will not work.
  107. 2023-09-01 08:59:05 17387 [Note] RSA public key file not found: /usr/local/mysql/var//public_key.pem. Some authentication plugins will not work.
  108. 2023-09-01 08:59:05 17387 [Note] Server hostname (bind-address): '*'; port: 3306
  109. 2023-09-01 08:59:05 17387 [Note] IPv6 is available.
  110. 2023-09-01 08:59:05 17387 [Note] - '::' resolves to '::';
  111. 2023-09-01 08:59:05 17387 [Note] Server socket created on IP: '::'.
  112. 2023-09-01 08:59:06 17387 [Note] Event Scheduler: Loaded 0 events
  113. 2023-09-01 08:59:06 17387 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
复制代码
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
 楼主| 发表于 2023-9-1 15:55:00 | 显示全部楼层

  1. Version: '5.6.51-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
  2. 2023-09-01 14:11:53 26214 [Note] Plugin 'FEDERATED' is disabled.
  3. 2023-09-01 14:11:53 26214 [Note] InnoDB: Using atomics to ref count buffer pool pages
  4. 2023-09-01 14:11:53 26214 [Note] InnoDB: The InnoDB memory heap is disabled
  5. 2023-09-01 14:11:53 26214 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  6. 2023-09-01 14:11:53 26214 [Note] InnoDB: Memory barrier is not used
  7. 2023-09-01 14:11:53 26214 [Note] InnoDB: Compressed tables use zlib 1.2.11
  8. 2023-09-01 14:11:53 26214 [Note] InnoDB: Using Linux native AIO
  9. 2023-09-01 14:11:53 26214 [Note] InnoDB: Not using CPU crc32 instructions
  10. 2023-09-01 14:11:53 26214 [Note] InnoDB: Initializing buffer pool, size = 256.0M
  11. 2023-09-01 14:11:53 26214 [Note] InnoDB: Completed initialization of buffer pool
  12. 2023-09-01 14:11:53 26214 [Note] InnoDB: Highest supported file format is Barracuda.
  13. 2023-09-01 14:11:53 26214 [Note] InnoDB: The log sequence numbers 974900664 and 974900664 in ibdata files do not match the log sequence number 978547493 in the ib_logfiles!
  14. 2023-09-01 14:11:53 26214 [Note] InnoDB: Database was not shutdown normally!
  15. 2023-09-01 14:11:53 26214 [Note] InnoDB: Starting crash recovery.
  16. 2023-09-01 14:11:53 26214 [Note] InnoDB: Reading tablespace information from the .ibd files...
  17. 2023-09-01 14:11:54 26214 [Note] InnoDB: Restoring possible half-written data pages
  18. 2023-09-01 14:11:54 26214 [Note] InnoDB: from the doublewrite buffer...
  19. InnoDB: Last MySQL binlog file position 0 288483, file name mysql-bin.000053
  20. 2023-09-01 14:11:54 26214 [Note] InnoDB: 128 rollback segment(s) are active.
  21. 2023-09-01 14:11:54 26214 [Note] InnoDB: Waiting for purge to start
  22. 2023-09-01 14:11:54 26214 [Note] InnoDB: 5.6.51 started; log sequence number 978547493
  23. 2023-09-01 14:11:54 26214 [Note] Recovering after a crash using mysql-bin
  24. 2023-09-01 14:11:54 26214 [Note] Starting crash recovery...
  25. 2023-09-01 14:11:54 26214 [Note] Crash recovery finished.
  26. 2023-09-01 14:11:54 26214 [Note] RSA private key file not found: /usr/local/mysql/var//private_key.pem. Some authentication plugins will not work.
  27. 2023-09-01 14:11:54 26214 [Note] RSA public key file not found: /usr/local/mysql/var//public_key.pem. Some authentication plugins will not work.
  28. 2023-09-01 14:11:54 26214 [Note] Server hostname (bind-address): '*'; port: 3306
  29. 2023-09-01 14:11:54 26214 [Note] IPv6 is available.
  30. 2023-09-01 14:11:54 26214 [Note] - '::' resolves to '::';
  31. 2023-09-01 14:11:54 26214 [Note] Server socket created on IP: '::'.
  32. 2023-09-01 14:11:54 26214 [Note] Event Scheduler: Loaded 0 events
  33. 2023-09-01 14:11:54 26214 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
  34. Version: '5.6.51-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
  35. 2023-09-01 14:12:22 26321 [Note] Plugin 'FEDERATED' is disabled.
  36. 2023-09-01 14:12:22 26321 [Note] InnoDB: Using atomics to ref count buffer pool pages
  37. 2023-09-01 14:12:22 26321 [Note] InnoDB: The InnoDB memory heap is disabled
  38. 2023-09-01 14:12:22 26321 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  39. 2023-09-01 14:12:22 26321 [Note] InnoDB: Memory barrier is not used
  40. 2023-09-01 14:12:22 26321 [Note] InnoDB: Compressed tables use zlib 1.2.11
  41. 2023-09-01 14:12:22 26321 [Note] InnoDB: Using Linux native AIO
  42. 2023-09-01 14:12:22 26321 [Note] InnoDB: Not using CPU crc32 instructions
  43. 2023-09-01 14:12:22 26321 [Note] InnoDB: Initializing buffer pool, size = 256.0M
  44. 2023-09-01 14:12:22 26321 [Note] InnoDB: Completed initialization of buffer pool
  45. 2023-09-01 14:12:22 26321 [Note] InnoDB: Highest supported file format is Barracuda.
  46. 2023-09-01 14:12:22 26321 [Note] InnoDB: Log scan progressed past the checkpoint lsn 978547503
  47. 2023-09-01 14:12:22 26321 [Note] InnoDB: Database was not shutdown normally!
  48. 2023-09-01 14:12:22 26321 [Note] InnoDB: Starting crash recovery.
  49. 2023-09-01 14:12:22 26321 [Note] InnoDB: Reading tablespace information from the .ibd files...
  50. 2023-09-01 15:14:24 29040 [Note] Plugin 'FEDERATED' is disabled.
  51. 2023-09-01 15:14:24 29040 [Note] InnoDB: Using atomics to ref count buffer pool pages
  52. 2023-09-01 15:14:24 29040 [Note] InnoDB: The InnoDB memory heap is disabled
  53. 2023-09-01 15:14:24 29040 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  54. 2023-09-01 15:14:24 29040 [Note] InnoDB: Memory barrier is not used
  55. 2023-09-01 15:14:24 29040 [Note] InnoDB: Compressed tables use zlib 1.2.11
  56. 2023-09-01 15:14:24 29040 [Note] InnoDB: Using Linux native AIO
  57. 2023-09-01 15:14:24 29040 [Note] InnoDB: Not using CPU crc32 instructions
  58. 2023-09-01 15:14:24 29040 [Note] InnoDB: Initializing buffer pool, size = 256.0M
  59. 2023-09-01 15:14:24 29040 [Note] InnoDB: Completed initialization of buffer pool
  60. 2023-09-01 15:14:24 29040 [Note] InnoDB: Highest supported file format is Barracuda.
  61. 2023-09-01 15:14:24 29040 [Note] InnoDB: Log scan progressed past the checkpoint lsn 978547503
  62. 2023-09-01 15:14:24 29040 [Note] InnoDB: Database was not shutdown normally!
  63. 2023-09-01 15:14:24 29040 [Note] InnoDB: Starting crash recovery.
  64. 2023-09-01 15:14:24 29040 [Note] InnoDB: Reading tablespace information from the .ibd files...
  65. 2023-09-01 15:14:24 29040 [Note] InnoDB: Restoring possible half-written data pages
  66. 2023-09-01 15:14:24 29040 [Note] InnoDB: from the doublewrite buffer...
  67. InnoDB: Doing recovery: scanned up to log sequence number 978548164
  68. 2023-09-01 15:14:24 29040 [Note] InnoDB: Starting an apply batch of log records to the database...
  69. InnoDB: Progress in percent: 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
  70. InnoDB: Apply batch completed
  71. InnoDB: Last MySQL binlog file position 0 473, file name mysql-bin.000054
  72. 2023-09-01 15:14:25 29040 [Note] InnoDB: 128 rollback segment(s) are active.
  73. 2023-09-01 15:14:25 29040 [Note] InnoDB: Waiting for purge to start
  74. 2023-09-01 15:14:25 29040 [Note] InnoDB: 5.6.51 started; log sequence number 978548164
  75. 2023-09-01 15:14:25 29040 [Note] Recovering after a crash using mysql-bin
  76. 2023-09-01 15:14:25 29040 [Note] Starting crash recovery...
  77. 2023-09-01 15:14:25 29040 [Note] Crash recovery finished.
  78. 2023-09-01 15:14:25 29040 [Note] RSA private key file not found: /usr/local/mysql/var//private_key.pem. Some authentication plugins will not work.
  79. 2023-09-01 15:14:25 29040 [Note] RSA public key file not found: /usr/local/mysql/var//public_key.pem. Some authentication plugins will not work.
  80. 2023-09-01 15:14:25 29040 [Note] Server hostname (bind-address): '*'; port: 3306
  81. 2023-09-01 15:14:25 29040 [Note] IPv6 is available.
  82. 2023-09-01 15:14:25 29040 [Note] - '::' resolves to '::';
  83. 2023-09-01 15:14:25 29040 [Note] Server socket created on IP: '::'.
  84. 2023-09-01 15:14:25 29040 [Note] Event Scheduler: Loaded 0 events
  85. 2023-09-01 15:14:25 29040 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
  86. Version: '5.6.51-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
复制代码
美国VPS推荐: 遨游主机LinodeLOCVPS主机云搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 2023-9-2 09:57:26 | 显示全部楼层



你看一下系统日志,搜一下有没有 Out Of Memory 或 killed 之类的信息,有的话就是内存不够用
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
 楼主| 发表于 2023-9-2 13:17:38 | 显示全部楼层

licess 发表于 2023-9-2 09:57
你看一下系统日志,搜一下有没有 Out Of Memory 或 killed 之类的信息,有的话就是内存不够用
...

谢谢军哥的回复,我查看了一下/var/log/messages这个文件,确实有如你所说的out of memory:ikill process 1380 或者kidded process 1380这些字眼,如下图:

但我查看我服务器内存使用情况好像还有很多,如下图:

像这种情况,难道是要再加大内存吗?或者除了这个,还有其他方法吗?

军哥运维代购:http://shop63846532.taobao.com/

发表于 2023-9-3 10:51:13 | 显示全部楼层

caiheqing 发表于 2023-9-2 13:17
谢谢军哥的回复,我查看了一下/var/log/messages这个文件,确实有如你所说的out of memory:ikill process ...

可以通过OOM Killer不让系统kill
不过加内存一般才会真正解决
 楼主| 发表于 2023-9-3 17:13:36 | 显示全部楼层

licess 发表于 2023-9-3 10:51
可以通过OOM Killer不让系统kill
不过加内存一般才会真正解决

谢谢军哥回复,这个oom killer如何设置呢?在你论坛搜索没有,百度上也很少,这个是直接开启还是?
美国VPS推荐: 遨游主机LinodeLOCVPS主机云搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 2023-9-5 16:21:52 | 显示全部楼层

caiheqing 发表于 2023-9-3 17:13
谢谢军哥回复,这个oom killer如何设置呢?在你论坛搜索没有,百度上也很少,这个是直接开启还是? ...

比如mysql被kill掉了,ps aux|grep mysqld 确定mysqld的进程ID,如PID为1234
则 echo -15 > /proc/1234/oom_score_adj
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|VPS侦探 ( 鲁ICP备16040043号-1 )

GMT+8, 2024-4-22 01:02 , Processed in 0.028498 second(s), 16 queries .

Powered by Discuz! X3.4

© 2001-2023 Discuz! Team.

快速回复 返回顶部 返回列表