MySQL被关闭，是什么原因？

Toogle

突然发现打开网站，连接不上数据库，于是登录宝塔，发现MySQL被关闭了。看了一下，应该是2号被关闭的。日志如下：
9 [( W8 |8 K7 z9 R$ X* r
0 n9 v3 s. a1 u# ?% M4 Q2021-11-02 22:59:29 14448 [Note] Binlog end
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'partition'
3 w2 g! ^/ |1 o* i0 j# H+ p; l2021-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'
* @6 w' l3 n6 }! E7 \& E2021-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'
2021-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'
) r7 o( A2 Z) @2 j/ _( c2021-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'
+ C; Y* B+ Y$ p3 H, F2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
: {. D3 j3 N) g' m0 }6 c! ~% S- f2021-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'
( O+ S9 M5 P/ q) y, m4 j2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_METRICS'
0 O' r# F0 v  M2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
/ A8 r" y$ ?4 l9 i3 Z6 z4 R2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
; L# }& v( k, W- F2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
, V' F# H: Y8 ?: T, n  L2021-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'
2021-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'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
4 Z# q* a5 \$ n. C& |$ y7 f2021-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'
3 O/ ]3 }1 u; [! G6 \2 J2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'BLACKHOLE'
+ N7 l) G: a7 {; e2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'ARCHIVE'
. l# W$ E* ^8 J+ e% }) M2 `6 C4 H2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MRG_MYISAM'
9 \( k2 ?2 _1 V; }) Y2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MyISAM'
8 `6 T7 c* k# A5 }  |2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MEMORY'
; Z* c: {  R) E: R! l5 L& j! ~2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'CSV'
) V4 I9 j# ?) [9 |# Z2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'sha256_password'
& f3 X/ D" Z* P. n9 t+ a! `2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'mysql_old_password'
2 H, w' t: O% F$ P) V+ U2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'mysql_native_password'
0 V. a0 W2 Q$ J& D! s7 }2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'binlog'
: a/ F4 w3 z1 q; H2021-11-02 22:59:29 14448 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

$ X2 y4 r' d& J5 _9 @
谢谢！~
0 \" j+ l- C/ k3 l1 o1 G+ V' r

Toogle

检测当前服务器的MySQL端口是否安全（ 检测时间：刚刚，耗时：23.50毫秒 ，等级：中危）折叠  |  忽略  |  检测
; ^! w8 r& o0 f% k1 C检测类型：MySQL端口安全风险等级：中危
3 u  f7 h6 a) P; w" \3 n风险描述：当前MySQL端口: 3306，可被任意服务器访问，这可能导致MySQL被暴力破解，存在安全隐患
1 x: z) l+ `* ~) m  F. j5 f( l; D, r解决方案：1、若非必要，在【安全】页面将MySQL端口的放行删除
2、通过【系统防火墙】插件修改MySQL端口的放行为限定IP，以增强安全性
3、使用【Fail2ban防爆破】插件对MySQL服务进行保护

6 a6 y6 ~& y' \! ^+ [这个？？
0 J. ~$ b1 b5 @. a. G; U7 i
很少研究宝塔的使用，看来得多看看……
; y' f% I9 ^9 k9 b0 P2 }1 y

Toogle

Fail2ban防爆破是免费的，刚刚安装了，还有什么其它建议吗？
) I$ _( j2 V  v

河小马

error log 日志不全啊。。目前还是无法判断的
先重启mysql吧，然后时时观察一下mysql

老刘

日志不全.  盲猜是崩溃了
1 s% R+ f5 M4 o' {. c1 H3 X. `7 n' V升级到MYSQL5.7试试

Toogle

河小马 发表于 2021-11-9 17:00
error log 日志不全啊。。目前还是无法判断的
先重启mysql吧，然后时时观察一下mysql
...

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

应该是2号出现的，下面这个是2号全部的日志。
7 o. b" F+ o; t  B! x8 @
2021-06-27 22:54:22 4646 [Note] /www/server/mysql/bin/mysqld: ready for connections.
' F6 [# A2 H) B7 ]Version: '5.6.37-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
6 q; B: z& P4 p  I( T8 O- o, s% X
2021-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
# W' B; y, u2 r8 [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
1 t, {* B1 E  L& Z  K2 N& u! c2021-11-02 22:59:29 14448 [Note] InnoDB: Compressed tables use zlib 1.2.3
9 x: f/ s, k: i2021-11-02 22:59:29 14448 [Note] InnoDB: Using Linux native AIO
2021-11-02 22:59:29 14448 [Note] InnoDB: Using CPU crc32 instructions
2021-11-02 22:59:29 14448 [Note] InnoDB: Initializing buffer pool, size = 128.0M
8 }7 G7 U& d: r4 p2 m- S- W5 m. K) rInnoDB: mmap(137363456 bytes) failed; errno 12
9 k* `5 d. ?; ~1 {2021-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.
& S; i) k/ b! h9 ?" G2021-11-02 22:59:29 14448 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-11-02 22:59:29 14448 [ERROR] Unknown/unsupported storage engine: InnoDB
& A" b+ y$ z7 w  Q# C6 M2 ~( _5 k2021-11-02 22:59:29 14448 [ERROR] Aborting
% y5 l8 d' S; u
2021-11-02 22:59:29 14448 [Note] Binlog end
. y9 M1 n, ?# g2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'partition'
5 r# \0 o8 @* H- m3 y" ]& h2021-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'
7 }8 p, O& f) O7 V2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
3 m7 z. ?! j! w( A! Q" E/ f: f# U2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
* ?/ G. _* }1 L% V' ?2 |. F2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
8 m# g/ D$ p6 p# C2 g/ B2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
: f1 [+ U; i' I2 w! h2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
. ^, r$ k' |: ~; t3 G$ I2021-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'
: X$ D4 l( l# Y5 D, s  v9 E; x. k2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
+ u5 v2 T/ ~5 C; [" O$ A) N2021-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'
% ^/ l8 z9 t5 m% l4 p2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
3 w$ Z* y% U  Q% c  x; {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'
3 |" r* u- X+ ^- s2021-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'
% V6 ~: i8 ^: o2021-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'
! Q% G+ {' H0 }8 \/ i1 S2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
' `! M! |# S1 g: j+ ^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'
, a) d, p8 M! W8 s0 Y- g+ w' k/ _) P2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP_RESET'
& \$ M7 ]: f" {/ |. ]9 K0 F/ W2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP'
- N% g0 P4 E- L9 z9 @* M2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
0 J- Q) w* \( x& b7 o: V4 k- A2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_LOCKS'
! t- X5 x: t2 v2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_TRX'
2 u) F4 Q/ y4 J+ ]9 Y4 Y2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'BLACKHOLE'
! L% r( b. G* C. Z/ E7 `  p2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'ARCHIVE'
2021-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'
( E, W3 N! k2 `2 e& G2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'CSV'
) O0 G  q) q( S" Q; d2021-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'
+ I) [/ E# r) t4 U; `5 V" j( ?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'
2021-11-02 22:59:29 14448 [Note] /www/server/mysql/bin/mysqld: Shutdown complete
* E1 A+ n. o8 F* [& Z& D' I" e) x
0 O8 Z% \2 {' }* ~" i2021-11-09 15:13:07 2834 [Note] Plugin 'FEDERATED' is disabled.

sead

1. df -hl

复制代码

7 I4 J+ K2 w' o  k% z- u先看看硬盘是不是满了

Toogle

sead 发表于 2021-11-9 23:47
先看看硬盘是不是满了

# i6 M. x. W# E# ^4 q8 H+ r这个宝塔控制面板里也看得到，没满……

ensky

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

Toogle

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

, m8 K4 H; M6 ~1 F/ P1 T  G1核
0 T/ F) c. D# ?RAM 2GB
6 H# d! R8 v1 v5 w2 }7 x5 l
在哪里改？
9 h/ v# S; G% I2 p5 r$ u' S
; Q1 i7 y  x' s. Q  w7 `% h. f谢谢！~

ensky

Toogle 发表于 2021-11-10 15:38
1核
9 t0 v) P% G. K* I$ {RAM 2GB

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

Toogle

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

看到了，之前我还回过帖子，只是忘记了……
0 O: z2 y6 n, o6 {
& I6 J8 Y: v9 {, F- F. D, Q% c+ g. j这就搞一下。

6 k2 i9 @4 n. s谢谢！

Toogle

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

& w4 o" S$ c0 r  p: q) u$ M看了一下，没办法resize，重新建一个吗？如果是，旧的应该如何处理？
' A2 L0 i3 M; s' [3 s谢谢！~

8 }# f" s% A1 x& j

zzfree

内存不够用

ensky

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

; M( h' z- u- p' \% e, k' U不能resize，这个我没有经验了，看看其余大佬有没有办法。