MySQL被关闭，是什么原因？

Toogle

突然发现打开网站，连接不上数据库，于是登录宝塔，发现MySQL被关闭了。看了一下，应该是2号被关闭的。日志如下：
! m& q4 B9 i+ Y3 W; d' ~
2021-11-02 22:59:29 14448 [Note] Binlog end
( K# A1 c5 U% D. x' K+ _! P2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'partition'
5 `" {# ]4 B. m) B7 H# @2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
6 ~. K6 h, K2 v, C7 q6 @2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
8 H$ ?1 @% w9 \2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
6 B' s4 J3 w4 V, I& R2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
9 C, \, h( }/ T3 T2021-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'
! }; E3 O+ ~0 q) O" ^1 ^& s2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  ?- B7 b$ d! s% Z2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
- ?9 L! |) F  l7 t4 q+ D* l2021-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'
) T, k0 y: z4 I. ]: h1 t2021-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'
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'
2 E8 v2 c. H, d$ [$ D& x2021-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'
. P) k& x. c. h+ j7 ]' l2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
, `1 h8 v8 \+ C8 |0 ~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'
, F0 C( L% H8 ?- `7 m2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
) c1 g2 V& u3 g2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
- F$ Z  W5 S( M, n% ^6 `; h2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMPMEM'
2 O, D8 W: y# d  |: S2 B2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP_RESET'
6 X- z$ _9 A+ z2 W( W* `8 r2021-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'
1 _% j. g) g8 [. y2021-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'
5 Z4 J4 _4 X; ^7 ]0 E, I2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'BLACKHOLE'
" _2 t4 e' ~8 g7 q2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'ARCHIVE'
/ j* ]- `8 I8 k2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MRG_MYISAM'
2021-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'
# l" n7 V! _% Q3 X2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'sha256_password'
( x9 G% a2 ]7 M& L. O2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'mysql_old_password'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'mysql_native_password'
$ U7 h, F; {5 C  l2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'binlog'
  L- R  R2 F! i# d( }7 Y+ p2021-11-02 22:59:29 14448 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

  J7 s/ y9 E* C3 ~& D
谢谢！~
) y8 t. J2 W7 j( ]5 q3 B
3 z6 o" I5 O5 M1 I' r

Toogle

检测当前服务器的MySQL端口是否安全（ 检测时间：刚刚，耗时：23.50毫秒 ，等级：中危）折叠  |  忽略  |  检测
- |, D5 l& h4 {+ ?/ E检测类型：MySQL端口安全风险等级：中危
. u9 d( I2 }. N# q+ B1 L3 |风险描述：当前MySQL端口: 3306，可被任意服务器访问，这可能导致MySQL被暴力破解，存在安全隐患
. [5 h2 x) n4 W4 K( l1 R6 T! E. k& p解决方案：1、若非必要，在【安全】页面将MySQL端口的放行删除
2、通过【系统防火墙】插件修改MySQL端口的放行为限定IP，以增强安全性
3、使用【Fail2ban防爆破】插件对MySQL服务进行保护

这个？？

很少研究宝塔的使用，看来得多看看……
4 J5 u: C3 g( [2 S7 [

Toogle

Fail2ban防爆破是免费的，刚刚安装了，还有什么其它建议吗？
' C0 U2 v+ O' r4 r- ?7 t. r) H8 |
8 ]  [" c& P6 X1 E* \

河小马

error log 日志不全啊。。目前还是无法判断的
先重启mysql吧，然后时时观察一下mysql
# g6 h5 m8 u# \6 W2 W( G9 p/ L

老刘

日志不全.  盲猜是崩溃了
升级到MYSQL5.7试试

Toogle

河小马 发表于 2021-11-9 17:00
1 Y& k$ W- t: ?error log 日志不全啊。。目前还是无法判断的
. P) C% C1 s/ T/ Q$ D先重启mysql吧，然后时时观察一下mysql
- M+ \' |" |+ y% E$ _! h ...

好的，已经重启正常了……

; L( y# a/ `* ?) T0 R; |% F应该是2号出现的，下面这个是2号全部的日志。

' {4 C4 q4 ~- j5 z2021-06-27 22:54:22 4646 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '5.6.37-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

! e* S/ [- @' W2 b; W2021-11-02 22:59:29 14448 [Note] Plugin 'FEDERATED' is disabled.
2021-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
- P; x( o4 `1 h: f2021-11-02 22:59:29 14448 [Note] InnoDB: Memory barrier is not used
3 X- H; i) T; a1 E2021-11-02 22:59:29 14448 [Note] InnoDB: Compressed tables use zlib 1.2.3
+ `& n$ T/ }7 ]) m7 T2021-11-02 22:59:29 14448 [Note] InnoDB: Using Linux native AIO
1 ~6 ?2 q1 b3 L: [2021-11-02 22:59:29 14448 [Note] InnoDB: Using CPU crc32 instructions
9 O) a% Z8 M, d& `- e4 n2021-11-02 22:59:29 14448 [Note] InnoDB: Initializing buffer pool, size = 128.0M
! F1 @( S+ d. e& NInnoDB: mmap(137363456 bytes) failed; errno 12
0 L8 _, O' `' [3 Q2 B. x( ]( f2021-11-02 22:59:29 14448 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
3 z1 }' `( A8 u5 D( K+ G+ Y1 U2021-11-02 22:59:29 14448 [ERROR] Plugin 'InnoDB' init function returned error.
2021-11-02 22:59:29 14448 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
8 c- K. g, J4 ^( a8 D5 L+ g1 g2021-11-02 22:59:29 14448 [ERROR] Unknown/unsupported storage engine: InnoDB
2021-11-02 22:59:29 14448 [ERROR] Aborting

5 _% r- G% `. E0 S# c2021-11-02 22:59:29 14448 [Note] Binlog end
: N8 }+ O0 F3 M. x2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'partition'
- l( {' x# o1 ]6 j- R0 m8 _2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
3 f+ I0 s! c7 g- _2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
- t# E( D' i" n4 H2021-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'
9 v# d) p1 ~! B# ?7 S8 ]! J/ h+ G5 G2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
. W$ [7 j8 c+ _5 W$ \5 X0 u9 z" V2021-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'
7 H+ Q% a* D! d* t7 H, [2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  i$ {7 p; R/ D2 y' t+ K, U2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
. u5 V: |& x7 u* {5 n/ p2021-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'
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'
# Q- f6 s) o% `9 P2021-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'
; R" U5 L  c. n2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
& x- F1 d6 b! N2021-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'
2 ], ~! w: @' I$ x6 ?1 b2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
0 h/ }) V/ _5 A  T* K2021-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'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP'
; {- \! C5 r+ L3 [0 |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'
. j, ?5 ~. F( f2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'ARCHIVE'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MRG_MYISAM'
: k+ H" }+ U) X  A4 R. r2021-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'
& r( {# y. a' n3 t  j* t/ t2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'mysql_old_password'
- o% j( g" l! E' _3 e9 @2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'mysql_native_password'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'binlog'
* `/ w: |) n* y2021-11-02 22:59:29 14448 [Note] /www/server/mysql/bin/mysqld: Shutdown complete
( O/ O* b6 p5 |$ l
2021-11-09 15:13:07 2834 [Note] Plugin 'FEDERATED' is disabled.

sead

1. df -hl

复制代码

先看看硬盘是不是满了

Toogle

sead 发表于 2021-11-9 23:47
5 O3 K. P! C5 z' F8 J先看看硬盘是不是满了

  T# S+ {/ I" {. b+ D这个宝塔控制面板里也看得到，没满……

ensky

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

Toogle

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

; s$ r; S8 p8 k* `1核
RAM 2GB

在哪里改？
# Q  A, C8 o! F0 p" T: u( O
谢谢！~

ensky

Toogle 发表于 2021-11-10 15:38
1核
8 f& k% g5 O+ R4 s4 z1 CRAM 2GB

看这个地方https://www.advertcn.com/forum.p ... mp;page=1#pid490481

Toogle

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

2 S' L8 V$ Z! S  _* z看到了，之前我还回过帖子，只是忘记了……
/ j9 O9 p" I/ o' J
这就搞一下。
* [: ^) r1 n- N- R1 Z1 j$ }, A* ]& x
谢谢！

Toogle

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

5 E* m# o, i! e. Z& h看了一下，没办法resize，重新建一个吗？如果是，旧的应该如何处理？
谢谢！~

) h& f. X- E) Q0 E/ }, i, [. i9 {8 @
! ?$ S; x1 [- I- }7 P: o

zzfree

内存不够用

ensky

Toogle 发表于 2021-11-10 22:09
看了一下，没办法resize，重新建一个吗？如果是，旧的应该如何处理？
谢谢！~

, v# D* R# w/ l1 S) r# C$ v不能resize，这个我没有经验了，看看其余大佬有没有办法。