MySQL被关闭，是什么原因？

Toogle

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

, B% }1 e: M" V+ M& T$ r& m2021-11-02 22:59:29 14448 [Note] Binlog end
; n: ^, Q* y7 P. D9 `) d2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'partition'
, t; a2 A$ I8 s* X, k$ o& A2021-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'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
+ ?4 l+ o# i& C$ Y1 Q/ |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'
3 {3 Y; g; p" }, V$ `5 p2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  N' Z5 I; t( {2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
1 h" m* r+ a6 E$ x) g& S& F9 @& ~. P2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
; o* p; o! {% X" [( Y2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
9 X9 Z1 O/ n: q2021-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'
0 [* W3 m% N2 G& x' B% F2021-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'
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'
5 H8 u6 q1 o: d" y0 k( S+ @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'
7 |  i; f: {, d1 r) r2021-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'
+ @- k! |# r1 _! |$ h8 _8 s' {2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMPMEM'
5 w, {2 |" c# q$ W: s2021-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'
9 C( w2 v, }6 s2021-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'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'ARCHIVE'
' Z' z& U& b3 J/ a, d2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MRG_MYISAM'
$ u; k& A5 \2 `( c2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MyISAM'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MEMORY'
. J: n" H0 R$ ?' r% f! P2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'CSV'
, h+ O3 ~7 Q( C6 b) z2021-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'
. t$ ?0 e# |! h, m0 p; k2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'binlog'
9 ?$ ?% ^- o7 F( s2021-11-02 22:59:29 14448 [Note] /www/server/mysql/bin/mysqld: Shutdown complete


谢谢！~
# h$ C8 O5 k! _3 g8 c' D
: {/ v" g$ J8 f; @

Toogle

检测当前服务器的MySQL端口是否安全（ 检测时间：刚刚，耗时：23.50毫秒 ，等级：中危）折叠  |  忽略  |  检测
检测类型：MySQL端口安全风险等级：中危
9 |3 m( f* m, d5 }风险描述：当前MySQL端口: 3306，可被任意服务器访问，这可能导致MySQL被暴力破解，存在安全隐患
' Y/ @' [9 ^7 m& I1 {3 u解决方案：1、若非必要，在【安全】页面将MySQL端口的放行删除
( G& N5 u& i7 {5 Y2、通过【系统防火墙】插件修改MySQL端口的放行为限定IP，以增强安全性
- W: h" h: e) u+ R' q$ x, z* R3、使用【Fail2ban防爆破】插件对MySQL服务进行保护
3 d+ i0 ~. U: }. I0 D: m: s& i
这个？？
. y8 f2 ^5 `( I9 {" g3 g
很少研究宝塔的使用，看来得多看看……

Toogle

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

3 p( `7 ~" @7 A  S/ F

河小马

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

老刘

日志不全.  盲猜是崩溃了
/ D. s- M* {! L升级到MYSQL5.7试试

Toogle

河小马 发表于 2021-11-9 17:00
error log 日志不全啊。。目前还是无法判断的
# c0 X# ^; K" ?3 h; G- @) p; i先重启mysql吧，然后时时观察一下mysql
...

* W. I3 s, V5 D' u9 X" [好的，已经重启正常了……
" t& |) ^6 t3 f
9 R. n3 b- p) C; Q; G" I) f应该是2号出现的，下面这个是2号全部的日志。

) o5 S7 h4 y9 V! ?+ b/ o% V2021-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

$ s( c+ t2 A$ I2021-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
7 t$ Z$ I( @9 ~( f# C" l  b& x/ b2021-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
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
, d  d: ~1 W5 `2 W( v3 F2021-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
% K) S) S. E- AInnoDB: mmap(137363456 bytes) failed; errno 12
2021-11-02 22:59:29 14448 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
4 ]$ }, H3 S3 ^2021-11-02 22:59:29 14448 [ERROR] Plugin 'InnoDB' init function returned error.
0 G. }  C; r8 z4 {' u8 v2021-11-02 22:59:29 14448 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
, Z: h/ }! i% G! w6 ]& N2021-11-02 22:59:29 14448 [ERROR] Unknown/unsupported storage engine: InnoDB
2021-11-02 22:59:29 14448 [ERROR] Aborting

, k) V7 l) l7 L% U4 w+ [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'
7 ?7 T! b9 p$ h# N) K" f2021-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'
) B: j5 [0 B& F, h& [1 T2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
; h' s  g7 J% v" f2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
. I2 [. F5 |) J( [& V+ H2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
* h5 n$ P' Z( c9 j% f2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
+ ^* A. w4 S7 u; O  p9 y2021-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'
$ F: k# z& k5 g' i2021-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'
5 y5 N' ]3 k( }$ ~% D2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DELETED'
/ ?: ?. R9 t( f0 s2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
, y$ s( G' A; e% |% _5 H2021-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'
3 @, [; ]0 b/ P+ K2021-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'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
, c9 g! h# [% B& }. R8 n2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMPMEM'
2 I9 l# l  K/ w6 Z, C6 O2021-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'
, q5 m% D  q/ G! J) [1 |3 u' ?7 A2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
3 K1 E$ d# R  X" t. ?9 [" |5 ?1 g4 O2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_LOCKS'
- r" a' w9 P* e& l7 t7 ?, p: ^& G; `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'
! w7 D/ c) [) W( D! T2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'ARCHIVE'
' E2 N7 _8 `1 _, {$ s0 h2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MRG_MYISAM'
4 Z0 ?- x. U; H: ]9 E% A2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MyISAM'
- |/ `" _) R: h8 i- k4 g  T2021-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'
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'
, I0 l" [9 {! W# l2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'binlog'
) M9 X' H0 N0 {1 `, G2021-11-02 22:59:29 14448 [Note] /www/server/mysql/bin/mysqld: Shutdown complete
5 B0 K' [, T  p. q
2021-11-09 15:13:07 2834 [Note] Plugin 'FEDERATED' is disabled.

sead

1. df -hl

复制代码

- T7 C" S, }( j0 j先看看硬盘是不是满了

Toogle

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

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

ensky

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

Toogle

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

1核
0 H  v" _0 U2 p% I4 R7 @RAM 2GB

9 W# [% f; A/ X$ x  p3 {在哪里改？
4 |1 }8 k$ M% P4 x3 ?
谢谢！~

ensky

Toogle 发表于 2021-11-10 15:38
) z, a. B$ P, w9 |1核
! o& T! a" U; k  u% H9 |, K) lRAM 2GB

- n! v& O  N- W9 Q: Z看这个地方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

0 n6 P8 M1 R% d+ {看到了，之前我还回过帖子，只是忘记了……

这就搞一下。
+ V' a; ~- a% _+ Y4 ^
" b9 ~  u* ~6 v谢谢！

Toogle

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

9 X! J2 Y  @( |3 Y+ [看了一下，没办法resize，重新建一个吗？如果是，旧的应该如何处理？
谢谢！~
3 y) P2 D, [6 ~9 [% ~: W

zzfree

内存不够用

ensky

Toogle 发表于 2021-11-10 22:09
' c* K; N8 r1 i5 Y4 H. \+ _& n看了一下，没办法resize，重新建一个吗？如果是，旧的应该如何处理？
7 p! k' T+ V4 s" t谢谢！~

6 s, q/ \" {" d+ o不能resize，这个我没有经验了，看看其余大佬有没有办法。