MySQL被关闭，是什么原因？

Toogle

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

2021-11-02 22:59:29 14448 [Note] Binlog end
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'partition'
2021-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'
1 w; |" n: {$ U' [8 v. ]4 C2021-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'
- b# f- d7 P. q) k' n+ V# {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'
8 n4 S- @; W8 e2021-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'
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'
/ ]4 B" L; [6 U0 L2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
. f1 C( Q- _: S2 s/ }6 T$ r2021-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'
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'
1 P* x) C5 h/ \" E$ s- R2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
0 L5 {2 c+ ?% M* Z+ y% Q2021-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'
+ o& O" I- ]- s0 w  V' Z+ `2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
  L( \% L9 o% s5 \2 m6 E2021-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'
4 m! i$ P4 }. u+ Z& A* V2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'BLACKHOLE'
( `" p4 h. a: {" C% c3 ^  _2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'ARCHIVE'
. |( r3 m1 w% D& v% U6 Z2 ]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'
7 E6 j" F7 w: u! N; L2021-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'
# Q5 ~3 b9 [3 h/ d) t: {2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'mysql_old_password'
" n1 j  r/ E$ @: T: v0 e1 q2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'mysql_native_password'
+ H/ I/ M) ]- ~8 s3 }  t- d2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'binlog'
- G+ @% e+ `, V- I& `* L& W2021-11-02 22:59:29 14448 [Note] /www/server/mysql/bin/mysqld: Shutdown complete
+ G3 `5 p% \" `% C7 g! f

/ L6 S, A! t2 c3 z2 ~' s& ^谢谢！~
) y$ D8 z! C( B
) w& m. x( b; ]0 x2 W1 `, |

Toogle

检测当前服务器的MySQL端口是否安全（ 检测时间：刚刚，耗时：23.50毫秒 ，等级：中危）折叠  |  忽略  |  检测
检测类型：MySQL端口安全风险等级：中危
风险描述：当前MySQL端口: 3306，可被任意服务器访问，这可能导致MySQL被暴力破解，存在安全隐患
4 U: t  [* ^9 r' b3 |$ b解决方案：1、若非必要，在【安全】页面将MySQL端口的放行删除
2、通过【系统防火墙】插件修改MySQL端口的放行为限定IP，以增强安全性
# `/ ]: u% Q) X! G* Z3、使用【Fail2ban防爆破】插件对MySQL服务进行保护
5 W8 m7 A) w, o# L; P( X, Q9 e
9 v: ~1 f, V8 V" x这个？？

很少研究宝塔的使用，看来得多看看……
) E8 N9 j' n' S' s" b

Toogle

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

: C1 y0 S* A, U) r5 S/ E

河小马

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

老刘

日志不全.  盲猜是崩溃了
/ q6 r8 E- s  _升级到MYSQL5.7试试

Toogle

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

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

! t2 Q! k5 B5 F: {应该是2号出现的，下面这个是2号全部的日志。
/ C: ]; B& S6 c5 q. w! A
& H0 s" K4 H6 d3 M& A% Q2021-06-27 22:54:22 4646 [Note] /www/server/mysql/bin/mysqld: ready for connections.
( S' F0 N4 E( t2 [Version: '5.6.37-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

# e. B8 _" J& C! o2021-11-02 22:59:29 14448 [Note] Plugin 'FEDERATED' is disabled.
5 f3 w' w# u) D9 A) ^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
" Q6 @4 d$ a5 H6 Z0 w2 J2021-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
: W6 L, M+ u0 G% ^3 Z2021-11-02 22:59:29 14448 [Note] InnoDB: Compressed tables use zlib 1.2.3
2021-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
- I  @, V# S' dInnoDB: mmap(137363456 bytes) failed; errno 12
! z9 G+ p, O) N! Q2 Z& n) m" @4 r: 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.
2021-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
4 M+ i0 D; C/ Q8 i3 _2021-11-02 22:59:29 14448 [ERROR] Aborting
8 I/ a' Z1 Y. f; Q+ Q
2021-11-02 22:59:29 14448 [Note] Binlog end
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'partition'
2021-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'
9 Y5 w& F+ B* c( j3 \2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
/ h8 \$ u5 Q5 k0 Q' S, k; A0 r2021-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 A! U6 h3 B+ J/ e! e: j; D- T& \2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2 m1 G$ E2 Y3 I4 V1 V& R2021-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'
1 N6 Y% P" t! G. 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'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
$ Y- I' U* ?8 |, j- Z1 k2 A% p2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DELETED'
: @+ b7 \+ c# J: ]# i; ?+ E; z: ?2021-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'
4 d# |* O- P( G% i3 L3 C2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
% G2 y* D. N4 v4 Z# s% ~2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
4 d: m7 b, l; \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'
0 _: ]3 l/ [, y! E2 _- }, Y5 @" }2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
. `7 ~/ N) h$ ~2 d) Q2 B7 u5 }' p5 ^& g2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMPMEM'
; G5 J1 H8 b% T2 y+ ^" G2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2 N& o0 K& }6 l6 \2 N, \4 x2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP'
( ^: a- p: U/ u4 q2 a* k! W2021-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'
+ A# a/ E8 T7 O/ k2021-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'
1 p) Y! D* ^. H1 @% p3 i* |8 R5 i2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MRG_MYISAM'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MyISAM'
9 ]0 M' m! X4 L( [9 }: J2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MEMORY'
% j- C/ ^# ~5 j& B2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'CSV'
+ I5 [7 _" v5 @. K  d9 F5 j2021-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'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'mysql_native_password'
4 K! U& s0 Y1 d" n* \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
# z1 f& {" Z& N& E+ b8 w
: c( S. T6 f+ ]) h( U2021-11-09 15:13:07 2834 [Note] Plugin 'FEDERATED' is disabled.

sead

1. df -hl

复制代码

& I3 i  M- U# M6 i9 H( h先看看硬盘是不是满了

Toogle

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

# |& B; v* z* }* R: n) v* H0 _$ O这个宝塔控制面板里也看得到，没满……

ensky

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

Toogle

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

1核
" ?6 ~) u3 _$ s! YRAM 2GB

2 U( R' o. y: N在哪里改？

谢谢！~

ensky

Toogle 发表于 2021-11-10 15:38
. \( c  K8 p3 ?1核
RAM 2GB

& Q9 y; G6 O% t看这个地方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

3 i! l" k# J2 S# y8 E看到了，之前我还回过帖子，只是忘记了……

这就搞一下。
. K# [* e3 h/ L# U2 q8 ?/ i! N! P
谢谢！

Toogle

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

* y- P% C) o, W看了一下，没办法resize，重新建一个吗？如果是，旧的应该如何处理？
" Y) P, a- i  D0 D2 A; Y) H3 a谢谢！~
% r  d, q) H" @# b/ }. D) @& V

; w8 Z+ G) E8 R, c1 @( v  m

zzfree

内存不够用

ensky

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

不能resize，这个我没有经验了，看看其余大佬有没有办法。