MySQL被关闭，是什么原因？

Toogle

突然发现打开网站，连接不上数据库，于是登录宝塔，发现MySQL被关闭了。看了一下，应该是2号被关闭的。日志如下：
7 Z1 k9 Z  O7 T, W5 U3 @0 G* E1 v3 c9 a
2021-11-02 22:59:29 14448 [Note] Binlog end
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'partition'
8 G7 }- i" V! U- L2021-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'
6 Q. ]/ N( u- W4 |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'
) H( m* y# a9 C, T1 N/ y4 R; `0 i2021-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'
" K; P8 W6 [" s8 u: l2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
' o4 G$ L2 L% Y* `: l: v2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
# q3 [2 `; Y5 z& V7 X0 q5 l  B2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
4 t% F8 V8 ?* n9 z1 L$ g2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
' S5 v$ L3 ~3 z6 a- i2021-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'
1 y: R% I# l4 @; |$ J9 p2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DELETED'
) s* H1 S* X& ~2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
) l+ _7 [. J7 `7 }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'
) g, j3 ~) Z+ @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'
, x1 x$ V! k9 P- V2021-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'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_TRX'
# e& l6 ?' K0 g" r% |2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'BLACKHOLE'
, S. |% ~) m/ Y6 Y8 S2 p2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'ARCHIVE'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MRG_MYISAM'
7 D( s* ?$ \3 J# S5 t' k2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MyISAM'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MEMORY'
5 T9 R6 p/ w; `( H, z2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'CSV'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'sha256_password'
( f1 N$ H0 T8 w. Y: i( Z( z0 U5 [! H2021-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'
2021-11-02 22:59:29 14448 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

: f6 m/ x# L9 i# v+ ~0 z
谢谢！~

Toogle

检测当前服务器的MySQL端口是否安全（ 检测时间：刚刚，耗时：23.50毫秒 ，等级：中危）折叠  |  忽略  |  检测
检测类型：MySQL端口安全风险等级：中危
风险描述：当前MySQL端口: 3306，可被任意服务器访问，这可能导致MySQL被暴力破解，存在安全隐患
  P6 e; K8 R0 ?4 _" W/ o  b, H0 ?解决方案：1、若非必要，在【安全】页面将MySQL端口的放行删除
( y. l6 n4 I! Q( D, c: S5 v2、通过【系统防火墙】插件修改MySQL端口的放行为限定IP，以增强安全性
1 Z* r6 p9 }4 Q! F" L# l! _0 G/ |0 W3、使用【Fail2ban防爆破】插件对MySQL服务进行保护
$ U4 q2 e6 o6 C
这个？？
; }6 F: O9 v  ?4 n+ C- _
9 j/ e) l+ ?( A( ]3 N9 E0 Z很少研究宝塔的使用，看来得多看看……

: m* c; k9 ?) \1 o. `! ^. g: p

Toogle

Fail2ban防爆破是免费的，刚刚安装了，还有什么其它建议吗？
  Y  K+ _$ r" q5 t# V% ~0 T! i
6 Q4 I* _$ t( V

河小马

error log 日志不全啊。。目前还是无法判断的
8 U7 g0 [0 q+ q* U  O先重启mysql吧，然后时时观察一下mysql
$ f" X" z5 }/ y( w3 Q

老刘

日志不全.  盲猜是崩溃了
& L7 G0 n8 P9 I0 Y4 I升级到MYSQL5.7试试

Toogle

河小马 发表于 2021-11-9 17:00
3 J5 f. |! j, f! N* ^$ D( |" Yerror log 日志不全啊。。目前还是无法判断的
先重启mysql吧，然后时时观察一下mysql
...

1 y5 T9 u5 r2 I6 P好的，已经重启正常了……
" c$ r# X/ T& \* L) z4 r
应该是2号出现的，下面这个是2号全部的日志。

# V2 C0 B2 Q/ o2021-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

! B  B5 ^5 n% j2 K) p2021-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
2021-11-02 22:59:29 14448 [Note] InnoDB: The InnoDB memory heap is disabled
: ?$ H& J3 P4 `5 I$ H2021-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 q8 d4 b% C  |! 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
( n4 k" s! P2 L, X; R% }# E8 u2021-11-02 22:59:29 14448 [Note] InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
. N! w" z3 r6 ^' J0 [# \( l- l2021-11-02 22:59:29 14448 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
( V7 Z3 [; x* P' ^2021-11-02 22:59:29 14448 [ERROR] Plugin 'InnoDB' init function returned error.
  B, H" _2 J, C* U2021-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

2 @, W! q9 J, Y* l0 w2021-11-02 22:59:29 14448 [Note] Binlog end
3 ?; D2 g* h! J2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'partition'
- u* |5 j6 g2 h2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
9 {* g0 w3 l% j$ p, M+ H$ p, 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'
1 j4 Y/ v% x2 Z- P" L; ^# ~2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
, Q9 L# T7 }( c+ [& D; Y2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
! A$ p5 C$ D1 l- K2021-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'
. [( u6 {7 {- I5 v& V, g, G/ B2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
& I& Q$ P) Y# }. D. I( D* ]) i  @2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2 \9 G3 o, l$ H; @5 N2 K, A; ]2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
9 I8 R* y& k; R" c  ]9 l* z2021-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'
. s% w/ T$ S0 f2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DELETED'
$ x! X! g/ k, y( L% x2 d2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
! T, {/ _$ U7 ]1 c* c/ F2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_METRICS'
5 G" K* ~  G4 A$ [- q2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
- }+ b: @( f  G9 ^- V8 S( W2021-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'
, d5 ^1 t0 x, W2021-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% u, k' c8 `( B) z" f/ k2021-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'
9 u) m. p. [9 f8 P( U7 ]2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP'
& O5 x3 a6 h/ H% r$ k/ m2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
6 X, u0 U9 L7 _2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_LOCKS'
0 U. s1 [4 W8 w# P3 E3 W2021-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'
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'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'CSV'
, j- k% N. P( ?# b: F2021-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'
# z$ ]' U4 p. a" K2021-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

0 v0 J) [& |+ t9 L! C% x/ |' W2021-11-09 15:13:07 2834 [Note] Plugin 'FEDERATED' is disabled.

sead

1. df -hl

复制代码

先看看硬盘是不是满了

Toogle

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

4 [+ h  c$ g5 f这个宝塔控制面板里也看得到，没满……

ensky

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

Toogle

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

1核
+ C7 L# B* K( g6 j6 RRAM 2GB
4 b' e. I! @5 H# c% y- ~' W
# [* R+ z: e+ _; F在哪里改？
5 r+ R7 B* Y/ `% z9 }0 |3 w
# t  o1 \8 W3 Z+ o7 \* `谢谢！~

ensky

Toogle 发表于 2021-11-10 15:38
& I# s: S- ?4 T: p* `: \7 M1核
RAM 2GB

, b" z( l, y" Z# l/ ^4 v- H看这个地方https://www.advertcn.com/forum.p ... mp;page=1#pid490481

Toogle

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

6 r5 w  ^% Y$ L9 `看到了，之前我还回过帖子，只是忘记了……

这就搞一下。

谢谢！

Toogle

ensky 发表于 2021-11-10 16:31
6 |3 t9 {1 T  J1 }8 r看这个地方https://www.advertcn.com/forum.php?mod=viewthread&tid=97673&page=1#pid490481

* ?+ \8 h* ]5 S6 ~1 ]; \- K看了一下，没办法resize，重新建一个吗？如果是，旧的应该如何处理？
9 w# |. T. i7 P2 i* D: `谢谢！~
& i8 F" ?  h) L. n6 y6 m
0 q2 Z  G# X- g/ w" y

zzfree

内存不够用

ensky

Toogle 发表于 2021-11-10 22:09
看了一下，没办法resize，重新建一个吗？如果是，旧的应该如何处理？
) `4 |5 |6 X6 x- d; j5 ?5 a+ w谢谢！~

0 U. I" }: T2 s- }不能resize，这个我没有经验了，看看其余大佬有没有办法。