MySQL被关闭，是什么原因？

Toogle

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

3 I% I1 W' E2 u' F2021-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'
$ F& Y8 \$ _8 N2 {1 C9 g6 m2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
* J$ b( F7 `$ N5 ^9 g/ i9 ]( Z2021-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'
1 Z6 I$ C7 ^; Z6 c- {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'
% p1 J7 P# P& S$ p  R8 j/ P2021-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'
: \" w# y1 m  c1 E/ f" m" n2021-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'
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'
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'
2021-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'
, i" [% ~" X$ {" K) ~0 m) T2021-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'
- ^9 ~( }6 \' ?9 G. R6 ^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'
5 S+ S% v3 C, e& |3 F2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP'
: z% R* n, q: r) b& @5 s4 r% ]2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
7 Y! r$ m3 K! S3 F' R- d2021-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'
/ Q8 ^/ S7 h0 h. z2021-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'
- n1 @0 L+ e2 T& E2021-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'
; D4 Z6 |+ P" X8 x+ _5 k& H) Z2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'mysql_native_password'
& U6 N6 p7 K1 Q( S) k2021-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
% v4 K/ T& Z. p4 B0 B2 i5 ?
( I7 f  q' T( |
' ], L+ Z$ C% }7 B2 L3 g0 n7 |8 l- z谢谢！~
# x  J; c9 a8 r: j$ a

Toogle

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

3 q3 y' J0 E3 T2 q这个？？
5 ~$ L$ |5 y4 F- R$ k( U
很少研究宝塔的使用，看来得多看看……
5 f3 p4 b( n. b- T$ B
- k/ p: E7 O& {; u6 z& j

Toogle

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

: F2 N' P5 k; }

河小马

error log 日志不全啊。。目前还是无法判断的
" U4 v: F! T5 @, W# C先重启mysql吧，然后时时观察一下mysql

老刘

日志不全.  盲猜是崩溃了
) X- a* Z+ x# q/ J2 K升级到MYSQL5.7试试

Toogle

河小马 发表于 2021-11-9 17:00
6 B0 W) S2 X# o" v: a, s0 d- Perror log 日志不全啊。。目前还是无法判断的
先重启mysql吧，然后时时观察一下mysql
) l, H6 @. c' j" A# Y ...

5 P8 N+ l0 |! I% h好的，已经重启正常了……

应该是2号出现的，下面这个是2号全部的日志。

( l* ?& C1 P8 x- ^& ]$ S$ V: H- M2021-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
) _! c1 x- a) i3 C
2021-11-02 22:59:29 14448 [Note] Plugin 'FEDERATED' is disabled.
: }3 q0 b7 O: }, X3 d2021-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
) m  z! b# S: y1 I2021-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
) F1 z! S9 e3 |# {+ c! ]2021-11-02 22:59:29 14448 [Note] InnoDB: Using Linux native AIO
+ G$ e, w. A, C- B8 b1 C7 s2021-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
2 _+ ~( n" b- N! m: t3 [7 wInnoDB: mmap(137363456 bytes) failed; errno 12
. i! m# ]: a& D. Q# z  n3 R2021-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.
2 ?, w* ^: P8 n6 ~0 K1 O3 h2021-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
$ L7 D  O! j3 E2 B  M0 s) z) y* `2021-11-02 22:59:29 14448 [ERROR] Aborting

- l% p1 n0 ~7 \/ d9 d( j5 g$ G2021-11-02 22:59:29 14448 [Note] Binlog end
& x& C  d. s; O, e: M3 p7 h2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'partition'
, g; a  w/ n) V2 C- e2 H+ i2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2 X8 n1 Z+ z0 _  w2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
4 H& `: H: T( l$ G5 F+ \2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
( i% @6 S# V% {' A9 A! k2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
% T, w# l( y3 D( O' M$ d3 N2021-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'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
; u* l7 u$ J( d! e+ p. I2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
0 V/ }" Z1 s- @2 }2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
* Z$ q  X. U$ B2021-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'
2 Y( }1 |( n9 y5 C8 U/ R2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
8 x! ^) p; p0 Z+ v5 ^+ w+ w2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DELETED'
' o" d% H5 F: r5 B7 d. s8 f2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
. @. k, D1 t! |# f) L; j1 u2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_METRICS'
+ L4 A  y' ~$ Q8 I  v4 ~( o2021-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'
. X0 y( _! j9 m. F4 }2021-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'
8 V9 x! {" s% n2 H( I2 F8 D2021-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'
+ M, i: J) @4 U4 M5 Y  I5 O2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMPMEM'
$ c! D  S4 ~2 h, v1 v2021-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'
. i* P# b. o3 K" M4 c$ V" T' C# _; 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'
5 A& y" [7 \! M. m/ d  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'
( l6 c4 _1 }0 c2 ]; c% I2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'ARCHIVE'
+ G  d1 t% i% M1 i% z) C, Q2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MRG_MYISAM'
( M; S! |; O) _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'
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'
+ j2 ]3 N3 O; t7 `. j& K" X2021-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

" z* m) D7 M4 O/ m3 e2021-11-09 15:13:07 2834 [Note] Plugin 'FEDERATED' is disabled.

sead

1. df -hl

复制代码

先看看硬盘是不是满了

Toogle

sead 发表于 2021-11-9 23:47
# P( [2 t) Q" A7 V2 P1 ?* E先看看硬盘是不是满了

. v: Z+ {4 a/ b" I. p1 Y这个宝塔控制面板里也看得到，没满……

ensky

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

Toogle

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

1核
4 z. X" W3 }; Z8 C0 W& V3 Z. YRAM 2GB

  h; C. S, q( f) Y在哪里改？

8 Y' ]; |. L; s; E/ Y谢谢！~

ensky

Toogle 发表于 2021-11-10 15:38
1核
RAM 2GB

看这个地方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

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

) S& X+ `# L% q这就搞一下。

+ }% L, G2 n' k6 p! |# r! J0 k谢谢！

Toogle

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

8 G+ _& M* y, k1 }看了一下，没办法resize，重新建一个吗？如果是，旧的应该如何处理？
谢谢！~

zzfree

内存不够用

ensky

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

& H# [3 w# ?0 h7 A8 X% q不能resize，这个我没有经验了，看看其余大佬有没有办法。