MySQL被关闭，是什么原因？

Toogle

突然发现打开网站，连接不上数据库，于是登录宝塔，发现MySQL被关闭了。看了一下，应该是2号被关闭的。日志如下：

1 }- P" p4 o5 K2021-11-02 22:59:29 14448 [Note] Binlog end
! a* }" x2 t2 ?; q5 [  i& K2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'partition'
+ z4 W* N1 X7 d% K2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
/ Y4 @& Y+ Y) R2 H/ {' u2 x# T2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
, e  n- z1 I3 ?2 R% q2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
7 V) i2 O# y% C2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DELETED'
- b9 o( m& E1 X8 W$ Z2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_METRICS'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
# {* V/ e% X0 G9 t  \3 ?0 y' B2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMPMEM'
* ^; @" U/ t7 O. v2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP_RESET'
8 k( f8 W; ?. s  S( P2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP'
; W' m" ]# t2 |# m9 c' l2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_LOCKS'
' ~3 B3 x" P8 ^& ?1 V2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_TRX'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'BLACKHOLE'
1 w1 Z4 A  o4 u; P$ ]9 X' \2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'ARCHIVE'
8 E, G- N. S  ^- m% N+ {2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MRG_MYISAM'
1 _( G4 l2 G% i/ v! h1 O2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MyISAM'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MEMORY'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'CSV'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'sha256_password'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'mysql_old_password'
( m6 x- v, Y# S! T2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'mysql_native_password'
6 U- d. c! z$ B  u2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'binlog'
6 r0 L$ h" r! Z4 f2021-11-02 22:59:29 14448 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

  C" U8 {( R' _7 U6 ]2 X: q/ ]- D9 D
谢谢！~

Toogle

检测当前服务器的MySQL端口是否安全（ 检测时间：刚刚，耗时：23.50毫秒 ，等级：中危）折叠  |  忽略  |  检测
检测类型：MySQL端口安全风险等级：中危
! v, I  h3 V7 {风险描述：当前MySQL端口: 3306，可被任意服务器访问，这可能导致MySQL被暴力破解，存在安全隐患
: o+ X; w3 C0 @解决方案：1、若非必要，在【安全】页面将MySQL端口的放行删除
2、通过【系统防火墙】插件修改MySQL端口的放行为限定IP，以增强安全性
8 f# e  l- ?8 T3、使用【Fail2ban防爆破】插件对MySQL服务进行保护
5 U  u( s4 ?" t/ U, F
; ^) Y' E% c( w6 R" X+ i% y" X+ @4 m这个？？

* @" y- R6 S. z7 F# d- b很少研究宝塔的使用，看来得多看看……
: @' K; Q) k0 U' q# s) N* A
0 D8 Z3 y8 g6 [& u) b; B

Toogle

Fail2ban防爆破是免费的，刚刚安装了，还有什么其它建议吗？

7 [- W1 {7 p+ I. i% i: @

河小马

error log 日志不全啊。。目前还是无法判断的
先重启mysql吧，然后时时观察一下mysql
1 l, l7 @, R, y2 k2 F- Y

老刘

日志不全.  盲猜是崩溃了
' \: v1 f5 Z: P' B& ?升级到MYSQL5.7试试

Toogle

河小马 发表于 2021-11-9 17:00
error log 日志不全啊。。目前还是无法判断的
先重启mysql吧，然后时时观察一下mysql
8 e, r+ s# E; H  h- L8 a ...

; J$ p7 p1 K: _, c% K' t8 L; V好的，已经重启正常了……
  L4 T& \8 E7 y. S
. v/ d# v- b0 y8 Y  r! U% f应该是2号出现的，下面这个是2号全部的日志。

4 |1 }3 a* w& K+ ^' u' e# Q2021-06-27 22:54:22 4646 [Note] /www/server/mysql/bin/mysqld: ready for connections.
5 L) l% n( ^2 ^: I$ ^+ j4 vVersion: '5.6.37-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

" y! s3 U. d, j0 G0 A1 t: m2021-11-02 22:59:29 14448 [Note] Plugin 'FEDERATED' is disabled.
1 B$ N1 I7 p; n9 W' T& K( ?" U2021-11-02 22:59:29 14448 [Note] InnoDB: Using atomics to ref count buffer pool pages
2021-11-02 22:59:29 14448 [Note] InnoDB: The InnoDB memory heap is disabled
2021-11-02 22:59:29 14448 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-11-02 22:59:29 14448 [Note] InnoDB: Memory barrier is not used
2021-11-02 22:59:29 14448 [Note] InnoDB: Compressed tables use zlib 1.2.3
6 v% l7 D6 M) @3 o( [7 X" S2021-11-02 22:59:29 14448 [Note] InnoDB: Using Linux native AIO
" }1 Q! n# k7 \8 Z( M3 T2021-11-02 22:59:29 14448 [Note] InnoDB: Using CPU crc32 instructions
9 [9 P& o& K7 L. M; t5 ?% ^2021-11-02 22:59:29 14448 [Note] InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
, N4 Q/ x9 M8 C5 q3 j2021-11-02 22:59:29 14448 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2021-11-02 22:59:29 14448 [ERROR] Plugin 'InnoDB' init function returned error.
+ n+ v3 S& U; h# H2021-11-02 22:59:29 14448 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
3 {7 a6 {/ }2 V! l8 K' G" N2021-11-02 22:59:29 14448 [ERROR] Unknown/unsupported storage engine: InnoDB
2021-11-02 22:59:29 14448 [ERROR] Aborting
' g7 B5 l8 n, K2 B( \! w' C
- X3 U$ J& y: Y4 @2021-11-02 22:59:29 14448 [Note] Binlog end
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'partition'
2 h  F8 ^% ~; u: F; l2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
" r( F* H# j: ~/ F3 M7 ~2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
. N9 A, K  S8 ?. ?4 {, K6 |9 ~1 w2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
/ z( m- x/ Q  U, t2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
6 S1 b# h& D+ C/ q# \/ x2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
# A' e* l6 I# ?- o& j2 i) G2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
, P9 i+ A, S  W, s5 H7 y3 k2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_METRICS'
0 R; ^$ Z& _& U) @2 A5 B5 x1 G2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
, T- r7 e+ a/ t- w: ^2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
% f3 ~( H4 {7 Y! E& f( p2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2 \0 @% `9 d$ L) g7 L, Z2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMPMEM'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP_RESET'
' J& B4 A7 U& m2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_LOCKS'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_TRX'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'BLACKHOLE'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'ARCHIVE'
) [( `* g1 b' x: Q2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MRG_MYISAM'
2 h1 h( ^* c( ]/ B2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MyISAM'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MEMORY'
3 |  ?* j! c. F9 w+ O2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'CSV'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'sha256_password'
3 D$ K+ H1 l1 e# b2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'mysql_old_password'
' A0 R* ~6 u( V2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'mysql_native_password'
- V+ M- b) A6 ^! H  u2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'binlog'
: h$ q7 n1 F: i2021-11-02 22:59:29 14448 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

/ r; E7 V6 Y% U/ {) ]) \2021-11-09 15:13:07 2834 [Note] Plugin 'FEDERATED' is disabled.

sead

1. df -hl

复制代码

先看看硬盘是不是满了

Toogle

sead 发表于 2021-11-9 23:47
' I+ Y  e. C6 p+ w/ h) i先看看硬盘是不是满了

+ X# v; e6 W8 [( ?" z" }这个宝塔控制面板里也看得到，没满……

ensky

你这个机器什么配置？几核几GB的RAM。我以前遇到过1H1GB装宝塔有问题，需要改配置的，不改配置几天MySQL就自动宕机一次。

Toogle

ensky 发表于 2021-11-10 14:57
你这个机器什么配置？几核几GB的RAM。我以前遇到过1H1GB装宝塔有问题，需要改配置的，不改配置几天MySQL就 ...

1核
- D) J5 B1 U; xRAM 2GB
; ^+ q6 b. x! Z, T
在哪里改？
! I% L4 w8 a$ N8 h* a7 C/ W- B2 ]
谢谢！~

ensky

Toogle 发表于 2021-11-10 15:38
1核
RAM 2GB

8 {9 ?3 m; E2 `7 [+ I! c) ?看这个地方https://www.advertcn.com/forum.p ... mp;page=1#pid490481

Toogle

ensky 发表于 2021-11-10 16:31
! E" C: E0 t4 h0 V- _1 x: @看这个地方https://www.advertcn.com/forum.php?mod=viewthread&tid=97673&page=1#pid490481

看到了，之前我还回过帖子，只是忘记了……

8 i$ I; @9 B# n7 W这就搞一下。
3 z* f  g' n4 U* w1 }
谢谢！

Toogle

ensky 发表于 2021-11-10 16:31
看这个地方https://www.advertcn.com/forum.php?mod=viewthread&tid=97673&page=1#pid490481

+ l( c1 c* T3 \% E' @2 Z# J2 X看了一下，没办法resize，重新建一个吗？如果是，旧的应该如何处理？
谢谢！~

zzfree

内存不够用

ensky

Toogle 发表于 2021-11-10 22:09
看了一下，没办法resize，重新建一个吗？如果是，旧的应该如何处理？
, I( |, V6 n* T( ^' \  g. t' [7 S/ k谢谢！~

' g+ c! E8 Z  H不能resize，这个我没有经验了，看看其余大佬有没有办法。