MySQL被关闭，是什么原因？

Toogle

突然发现打开网站，连接不上数据库，于是登录宝塔，发现MySQL被关闭了。看了一下，应该是2号被关闭的。日志如下：
6 P+ X7 U* ^% [# q- B- T$ e' l
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'
1 z& R5 o1 f; \! Z& c2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
, e+ Q9 ?6 i) ^7 g% `2 _. ?: W2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
" v: F% q, v: C7 |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'
& h9 i. S7 }0 O4 k' E0 k2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
( j# z1 W/ d9 ~7 F  Z4 j2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
% x1 K: C& Z8 y& p+ v0 \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'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
) R8 i4 n, ^1 H2 u9 K; v& l2021-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'
: H2 H/ r+ q( y! U! T' v3 W+ I$ E- E2021-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'
9 z3 F: h! s6 D( D  O4 p' N2021-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'
: q# \7 V" i8 n! T2021-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'
# M% }3 X; A! W. h0 X2 w. q2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
: v* r, k8 N. Q; e4 O4 }2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMPMEM'
7 B5 o" s+ Y; W- w& U/ V( Q2021-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'
( E; Z" y, I5 {' \8 `. I2 C6 z6 w' i2021-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'
! j* \% D8 X: j% Y9 Z2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'BLACKHOLE'
8 K* u* {: |0 H, y2 a. p2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'ARCHIVE'
1 y5 R# x4 ~' ~' _2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MRG_MYISAM'
; ^2 a2 X5 V9 s+ [. L% z2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MyISAM'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MEMORY'
5 j- [, w, q* Q& C0 x. L2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'CSV'
& w+ u6 W2 S/ G" Y) r2021-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'
& m+ k- m- i& P6 U" M2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'binlog'
' R8 v, B: B: K9 o: _2021-11-02 22:59:29 14448 [Note] /www/server/mysql/bin/mysqld: Shutdown complete


谢谢！~

Toogle

检测当前服务器的MySQL端口是否安全（ 检测时间：刚刚，耗时：23.50毫秒 ，等级：中危）折叠  |  忽略  |  检测
! |: l/ H, p7 J检测类型：MySQL端口安全风险等级：中危
/ g* o' ]0 p4 x0 t( V/ k& E风险描述：当前MySQL端口: 3306，可被任意服务器访问，这可能导致MySQL被暴力破解，存在安全隐患
! P2 H3 V6 V0 Y0 p. {解决方案：1、若非必要，在【安全】页面将MySQL端口的放行删除
: I% J4 q% c- }1 O2、通过【系统防火墙】插件修改MySQL端口的放行为限定IP，以增强安全性
3、使用【Fail2ban防爆破】插件对MySQL服务进行保护
; k8 h* h0 @8 {6 T4 [( v  @
8 k# C8 ^: U( Q这个？？
8 F4 s, U0 `% n9 N) O' E/ M
/ J8 L4 V# S4 u) Y) Z很少研究宝塔的使用，看来得多看看……
7 P7 w. h3 Y+ G. P- g
/ v& b# @) a+ B

Toogle

Fail2ban防爆破是免费的，刚刚安装了，还有什么其它建议吗？
! \7 B6 b; P% U; l! b0 |

河小马

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

老刘

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

Toogle

河小马 发表于 2021-11-9 17:00
error log 日志不全啊。。目前还是无法判断的
2 k* H/ d1 f" J) o+ r! h7 `先重启mysql吧，然后时时观察一下mysql
...

# p  [) D' A/ r6 s好的，已经重启正常了……

* u7 I6 K6 Q9 q; y5 _+ N应该是2号出现的，下面这个是2号全部的日志。

2021-06-27 22:54:22 4646 [Note] /www/server/mysql/bin/mysqld: ready for connections.
1 A" e9 N% L% F0 [/ R- lVersion: '5.6.37-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
+ ^9 d% U1 t0 Q9 G
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
) a" D2 J. ], m) Z1 |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
3 H  X$ s; L9 c& F1 {. Z2021-11-02 22:59:29 14448 [Note] InnoDB: Compressed tables use zlib 1.2.3
. c( ?. D: H; \% h; ]: m8 ^( ~2021-11-02 22:59:29 14448 [Note] InnoDB: Using Linux native AIO
9 \3 _, @; F' B9 @2021-11-02 22:59:29 14448 [Note] InnoDB: Using CPU crc32 instructions
# r7 b; }/ Y6 `. E: r2021-11-02 22:59:29 14448 [Note] InnoDB: Initializing buffer pool, size = 128.0M
  }# ]" `: I7 s1 Z4 r) ~+ aInnoDB: mmap(137363456 bytes) failed; errno 12
$ a. v$ z9 J9 v* a8 t2021-11-02 22:59:29 14448 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
7 V4 ]$ N( h, L  G! n' {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
2021-11-02 22:59:29 14448 [ERROR] Aborting
3 q" U5 C# p( h5 t! n, P. i
* S. F! i- W* g; O% P) N0 E* {. D. f2021-11-02 22:59:29 14448 [Note] Binlog end
+ s; _7 J8 y3 d$ b2021-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'
- h  |/ Y0 N. f3 F. |: b, q# 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'
2 h. B/ c+ Z# Q( b. s' _2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  \3 f+ d9 t  C  \! D2021-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'
0 E7 }* H7 g! o7 N2021-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'
) K. o& v+ E6 d4 q1 Z/ |8 f2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
9 Y* ?0 l" r) ^2 y$ s3 k; ^2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2 H; i4 B" |3 z3 N0 G2021-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'
; U' V6 |* j) p3 b6 R5 F. q' w4 @2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
0 }5 {# g& R9 e% v3 s5 X2021-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'
! y: a' x8 l. H$ P7 ~" l2021-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'
: s1 x# @2 m# T- \  x2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
8 h, A9 k7 D% H3 s3 Q9 ~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'
5 C+ T) B' r/ q1 E6 K2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMPMEM'
. {& r& l: x0 _  b5 H2021-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'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_LOCKS'
# T1 @; y2 L6 z5 w8 Q2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_TRX'
+ X) f# E( v$ l* F1 n2 p$ R" `- v& F2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'BLACKHOLE'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'ARCHIVE'
. N! X+ J/ }& S9 Z# R3 F2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MRG_MYISAM'
2 U+ Z. V; R9 m0 X& n2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MyISAM'
7 w8 c1 r/ k- N6 z. f2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MEMORY'
9 T: z: F* _4 Z; E2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'CSV'
& S! Y6 L5 P% A, g& ]; `2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'sha256_password'
) Q6 A- d1 \' g8 q; ^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'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'binlog'
! g0 I3 j/ V+ G% B! x" A  x2021-11-02 22:59:29 14448 [Note] /www/server/mysql/bin/mysqld: Shutdown complete
% z' R8 F8 d1 x# s9 l: l
$ O% l" m& S( n0 z9 _, \( @/ x2021-11-09 15:13:07 2834 [Note] Plugin 'FEDERATED' is disabled.

sead

1. df -hl

复制代码

先看看硬盘是不是满了

Toogle

sead 发表于 2021-11-9 23:47
% R8 f, W0 a7 a" o先看看硬盘是不是满了

这个宝塔控制面板里也看得到，没满……

ensky

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

Toogle

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

1核
RAM 2GB
2 `, N* C: j1 y  e5 Q( q
2 d& _  e1 W( k; n" X/ u在哪里改？
) A! Z2 J( Z0 g* s5 Z* W9 N0 M7 }' H
" h* v2 d. C& e; m) A* S. e谢谢！~

ensky

Toogle 发表于 2021-11-10 15:38
1核
* e9 h9 t$ G! i! ~RAM 2GB

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

Toogle

ensky 发表于 2021-11-10 16:31
5 r7 S- l* \9 ^" o& R6 ]7 D% O5 _2 A看这个地方https://www.advertcn.com/forum.php?mod=viewthread&tid=97673&page=1#pid490481

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

这就搞一下。

" \, V- l4 K. s谢谢！

Toogle

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

看了一下，没办法resize，重新建一个吗？如果是，旧的应该如何处理？
& G/ |" ]6 V- _5 _谢谢！~

zzfree

内存不够用

ensky

Toogle 发表于 2021-11-10 22:09
7 z* S/ J8 y7 q  g4 m' U看了一下，没办法resize，重新建一个吗？如果是，旧的应该如何处理？
谢谢！~

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