MySQL被关闭，是什么原因？

Toogle

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

) Q. U; T7 o  j' Y2 {2021-11-02 22:59:29 14448 [Note] Binlog end
, O. h/ D3 ?1 @6 `2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'partition'
# ]) x7 b5 z/ H, D' ^' c; y2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
( z, R% f  Q6 {* N2 S2021-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'
3 [/ z$ j2 A9 _2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
: c% }1 F+ S/ m9 J0 G' o2021-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'
+ f( Y. i) }( t6 ?2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
1 X+ D1 f/ _5 h5 }" K/ Y6 M2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
0 \4 @/ I! _) c0 J0 l, N7 k2021-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'
/ a* e: T1 L, H; c* E2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DELETED'
! s7 A# s$ {  G  ], [3 A9 I2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
. z$ C. l# j, |. y2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_METRICS'
3 Y, ?0 |' ~; Z/ Q! `' Y' A4 f" V2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
& f3 m5 N- ?2 z2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
% q9 Y, J% `9 |; g( I8 y1 h2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
$ n* v7 h' S3 z0 i5 ~, S2021-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'
$ r- |9 B9 h0 V' `, ?/ u  {2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
( d6 X5 W) a7 t  V# n' b2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMPMEM'
% G+ a8 n" K- g2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP_RESET'
, m, f! R* U8 p; g2021-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'
$ A6 k3 g, i# a5 ^, ^1 v9 a! k5 K2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_LOCKS'
; _, A' V: N5 i& Z/ r# e. n! c5 u2021-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'
6 N( T2 R3 P. V) @! l4 W2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MRG_MYISAM'
2 G+ u; u, f' w$ B2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MyISAM'
9 j8 x/ W" A, W2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MEMORY'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'CSV'
, _' B$ W' q5 s9 i2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'sha256_password'
& a* u3 V) o  F2021-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 b, K) I) ?# p, e' S2021-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

' }& N' F2 M7 u# a$ B5 O4 Z
5 p3 l4 M" B5 N. s0 E, B+ J$ s谢谢！~
& _" o! C% C* z  i5 s. M8 L
5 B" B  t2 f  X% F8 r  l

Toogle

检测当前服务器的MySQL端口是否安全（ 检测时间：刚刚，耗时：23.50毫秒 ，等级：中危）折叠  |  忽略  |  检测
检测类型：MySQL端口安全风险等级：中危
7 n( ^0 B. O+ p& B风险描述：当前MySQL端口: 3306，可被任意服务器访问，这可能导致MySQL被暴力破解，存在安全隐患
解决方案：1、若非必要，在【安全】页面将MySQL端口的放行删除
2、通过【系统防火墙】插件修改MySQL端口的放行为限定IP，以增强安全性
3、使用【Fail2ban防爆破】插件对MySQL服务进行保护

% Z9 w( w6 c, Z这个？？
/ l7 O+ ?5 F% N  P- [2 R3 b# D6 B0 E
3 M' x7 `# M. c: s6 I( Z很少研究宝塔的使用，看来得多看看……

Toogle

Fail2ban防爆破是免费的，刚刚安装了，还有什么其它建议吗？
  E; h! |+ x% S
) |" T# K) A' W8 M5 A* v

河小马

error log 日志不全啊。。目前还是无法判断的
# V. I" j) m4 C/ E# \' }6 l; S, M先重启mysql吧，然后时时观察一下mysql
6 V% Z# e( Q6 y: q2 Y  m$ F! J

老刘

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

Toogle

河小马 发表于 2021-11-9 17:00
3 K0 {4 O7 }% P. L/ Oerror log 日志不全啊。。目前还是无法判断的
6 {8 m5 Y: v& o  R% l  K: S先重启mysql吧，然后时时观察一下mysql
5 M- J; H4 R. U$ c1 o" K6 E5 l ...

好的，已经重启正常了……
7 X/ w  X0 l8 o/ `+ l' V) q$ H
应该是2号出现的，下面这个是2号全部的日志。

; J' H7 y( l) v  A- b0 }0 g4 i2021-06-27 22:54:22 4646 [Note] /www/server/mysql/bin/mysqld: ready for connections.
6 g  y" |0 q' Q8 o& F- NVersion: '5.6.37-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

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
, |; i! v( s) T$ f- h. d. c2021-11-02 22:59:29 14448 [Note] InnoDB: The InnoDB memory heap is disabled
7 _' f7 S* f) k' U+ O6 h2021-11-02 22:59:29 14448 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
1 k* @  w- t% l  ]) }' g2021-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
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
) B+ ]4 [6 G- Z2 f2021-11-02 22:59:29 14448 [Note] InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
2021-11-02 22:59:29 14448 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
$ `; `% z. o, h. d' |; I1 O' ^2021-11-02 22:59:29 14448 [ERROR] Plugin 'InnoDB' init function returned error.
& H6 d" _; m, y2021-11-02 22:59:29 14448 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
! c$ S6 s5 {3 _: e- E. {: G9 J2021-11-02 22:59:29 14448 [ERROR] Unknown/unsupported storage engine: InnoDB
. U* ^: \. b" W6 s) p6 D2021-11-02 22:59:29 14448 [ERROR] Aborting

0 I) u0 W+ f; \% q! _2021-11-02 22:59:29 14448 [Note] Binlog end
  a/ T# M# I; P2 i8 B* C  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'
& |# |3 G  Z. Y3 u0 a2021-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'
5 V; \4 x( s- b/ E& g9 d/ E2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
; {7 T) U/ M+ \8 h2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
: s2 P' v: z3 d1 N( D2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
6 a  K- H1 k9 k7 v( q2021-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'
% k0 y6 H1 M& x2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
- c& H' ^, |* r6 I: T" s2021-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'
+ M; H" h* {2 u) x: e2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
$ P2 p& Y5 e& ?& U2021-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'
" B" z. g6 W# j# Z* [9 f& l2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
) {9 x( @6 y& G6 i2021-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'
" c9 v. L1 k. N1 i* `. A2021-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'
$ o- u. l* ~6 E% K) g! m3 a0 x2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_LOCKS'
* O. G, \. d. ~  J2 J, [$ _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'
3 t% W/ i* n& Q6 h2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'ARCHIVE'
3 X( K4 T# b" X  ^/ U2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MRG_MYISAM'
& C+ ^7 t- A2 }" d9 n- \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'
4 m% X( [# n: n9 g/ d3 }" \2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'sha256_password'
+ `, a7 ]4 z$ C3 E) g/ O6 X2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'mysql_old_password'
" t3 ]: F. V$ a- g2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'mysql_native_password'
2 O- E2 u5 G5 o4 @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

. \$ K) K! S6 y/ T" F( S2021-11-09 15:13:07 2834 [Note] Plugin 'FEDERATED' is disabled.

sead

1. df -hl

复制代码

: l6 f9 l# c: D7 r& t& G先看看硬盘是不是满了

Toogle

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

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

ensky

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

Toogle

ensky 发表于 2021-11-10 14:57
# s& d; H8 o* g' T% E2 }1 x你这个机器什么配置？几核几GB的RAM。我以前遇到过1H1GB装宝塔有问题，需要改配置的，不改配置几天MySQL就 ...

; v- d& W" G6 A# i, B1核
/ y6 J* }) F+ m( F% i0 a, o9 }RAM 2GB

# q8 s5 A( a& u9 V! }1 @" s4 C( P在哪里改？
* o- \) i8 \% w2 J8 G6 r
谢谢！~

ensky

Toogle 发表于 2021-11-10 15:38
1核
6 M+ ], y5 {3 ?6 p) ]4 ZRAM 2GB

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

Toogle

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

: B8 D. S% S7 y' t+ K4 `$ d# n看到了，之前我还回过帖子，只是忘记了……

这就搞一下。

谢谢！

Toogle

ensky 发表于 2021-11-10 16:31
5 j8 w+ k/ G$ M$ _: m- Z& ]7 k; Y看这个地方https://www.advertcn.com/forum.php?mod=viewthread&tid=97673&page=1#pid490481

看了一下，没办法resize，重新建一个吗？如果是，旧的应该如何处理？
9 v7 l2 f- I4 f& o谢谢！~

9 h1 [/ L1 k; A

zzfree

内存不够用

ensky

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

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