MySQL被关闭，是什么原因？

Toogle

突然发现打开网站，连接不上数据库，于是登录宝塔，发现MySQL被关闭了。看了一下，应该是2号被关闭的。日志如下：
; p  M% e( ]) ?' S7 n
2021-11-02 22:59:29 14448 [Note] Binlog end
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'partition'
4 C" `  _  x) f' e2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
. k7 j$ G5 r( ^2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
$ C6 w+ f8 x7 y* r2021-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'
" S& G' J5 r7 }9 A( \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'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
9 V! n; U7 J5 @) U7 t9 \$ z/ K2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
, ?6 G" E( i' I! F+ @! j$ F1 G2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
5 ]8 D) d* S; G2021-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'
! A! o2 I0 f7 p0 r2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DELETED'
# J( }8 B, k( y! P' Q7 ]2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
& t% ^5 G6 L: }) J8 f2021-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'
, w+ M5 v* @% z2 H& Z2021-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'
! I+ {$ ?# @- X2021-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'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP'
8 d, I0 }- `+ h8 a/ L$ H2021-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'
( F& B; J4 o+ _0 f1 B2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_TRX'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'BLACKHOLE'
( ~" a1 E* F& e5 N& O( z: v2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'ARCHIVE'
  u4 F! _6 D# M1 E0 z' I( u2021-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'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'sha256_password'
( K$ c, W5 B0 M0 Q2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'mysql_old_password'
" z' u: ^% {2 _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'
# _- C& K- x1 m  R. M: M/ X8 _2021-11-02 22:59:29 14448 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

6 D; B7 |/ y; w3 p7 N7 y
谢谢！~

' Q7 s& C  Q6 O, R3 j

Toogle

检测当前服务器的MySQL端口是否安全（ 检测时间：刚刚，耗时：23.50毫秒 ，等级：中危）折叠  |  忽略  |  检测
4 s+ P% {) ~" c% V0 t* l; z! R检测类型：MySQL端口安全风险等级：中危
& ~! ~9 i- [) C7 h# N* l风险描述：当前MySQL端口: 3306，可被任意服务器访问，这可能导致MySQL被暴力破解，存在安全隐患
解决方案：1、若非必要，在【安全】页面将MySQL端口的放行删除
3 j3 P9 q* K  j% r) `& s5 f2、通过【系统防火墙】插件修改MySQL端口的放行为限定IP，以增强安全性
5 _0 b: V4 c; o. t* \5 R+ j0 Y3、使用【Fail2ban防爆破】插件对MySQL服务进行保护
4 }" m% m; y7 V0 S) g+ P
这个？？
6 f+ k8 @- f) f
7 R8 V) K+ s" T5 d$ R4 Y& R, G很少研究宝塔的使用，看来得多看看……
3 h$ T$ F' v) t3 B5 h; g

Toogle

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

' s- m5 I7 p6 x8 @  ?8 P  T3 z

河小马

error log 日志不全啊。。目前还是无法判断的
; ^$ e+ B8 x/ l' O5 M0 Z先重启mysql吧，然后时时观察一下mysql

老刘

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

Toogle

河小马 发表于 2021-11-9 17:00
error log 日志不全啊。。目前还是无法判断的
1 `# L8 z. k* t$ I先重启mysql吧，然后时时观察一下mysql
...

  @7 M' h; ]& f+ Y! X- v; O好的，已经重启正常了……
% B3 N4 `: {! ?3 D* ]: X" E
9 V) y6 u: R5 i9 m$ b应该是2号出现的，下面这个是2号全部的日志。

2021-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

2021-11-02 22:59:29 14448 [Note] Plugin 'FEDERATED' is disabled.
$ s4 F# @: f; R2 r2021-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
2021-11-02 22:59:29 14448 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2 }7 J  A, j' ^8 g' F$ g+ p2021-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
# @+ ]: q7 m; D, O7 s2021-11-02 22:59:29 14448 [Note] InnoDB: Using Linux native AIO
4 j6 O# {0 k3 K7 r, y2021-11-02 22:59:29 14448 [Note] InnoDB: Using CPU crc32 instructions
* k5 I( H4 o( w. Q' G9 H2021-11-02 22:59:29 14448 [Note] InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
- W; t7 r& p+ e9 l; b1 Z. d& |6 n3 {2021-11-02 22:59:29 14448 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
! ?" U  j+ M) z  S2021-11-02 22:59:29 14448 [ERROR] Plugin 'InnoDB' init function returned error.
) f! @8 m: y& R" J$ K0 P" \- n2021-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
: _  P1 n$ f  Z: o- `2021-11-02 22:59:29 14448 [ERROR] Aborting

* x" M9 J& |$ R, f9 _1 U2021-11-02 22:59:29 14448 [Note] Binlog end
3 h) ~2 ]' C3 ~9 z4 b' H8 H" p2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'partition'
! b- u" V* l8 p, h; e2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
0 l, A. M& L9 ]8 Y2021-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'
+ P8 z6 E: T8 t1 W2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
! C8 P$ Y, I# y4 G  y2021-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'
1 {7 p% t  ~, A$ U! e2021-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'
$ i3 z  S# e: L" w3 K& T+ r8 }2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
( Z' Q) S! }2 F! K" S, I2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
7 o* a6 D# v$ @' J7 y2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
$ n' t) W6 Y7 Y6 s, R* @2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
4 J) b: D" c& _2 [- X8 {+ D1 K/ r/ B2021-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'
# Z6 k/ W9 b" I6 S  k2021-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'
- G- ?1 P4 j( T0 n2021-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'
5 d; j) U6 f7 S0 a9 c- }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 \9 m- V. Q0 S: k% \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'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_TRX'
3 {8 N9 a% m9 F2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'BLACKHOLE'
- k* f6 N; Q5 _9 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'
1 s0 ^* c) h- ?4 K) [% N2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MEMORY'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'CSV'
- F$ [- o8 c- V4 F! p" |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'
/ J" \5 w& l+ B( V" O) F, h8 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'
: i1 s7 C2 ?3 m7 t: z2021-11-02 22:59:29 14448 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

2021-11-09 15:13:07 2834 [Note] Plugin 'FEDERATED' is disabled.

sead

1. df -hl

复制代码

3 H5 W" c6 e- T  C% [2 T先看看硬盘是不是满了

Toogle

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

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

ensky

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

Toogle

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

1核
RAM 2GB

在哪里改？
3 E( |, }% P! l0 C" k
( |' J( t: {2 x5 e谢谢！~

ensky

Toogle 发表于 2021-11-10 15:38
2 G2 i. _7 i- t% V6 |1核
RAM 2GB

. A2 y3 I# c: l" J) C! Y$ }看这个地方https://www.advertcn.com/forum.p ... mp;page=1#pid490481

Toogle

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

* k) T( V% k& h% N4 F5 m看到了，之前我还回过帖子，只是忘记了……
! J. X+ t- t) z2 U1 r- }
0 C- }# d9 ^* o, E9 V5 j这就搞一下。

谢谢！

Toogle

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

3 _$ A( E- z* D; l5 V- t& k8 l看了一下，没办法resize，重新建一个吗？如果是，旧的应该如何处理？
谢谢！~

1 Q  i) I  ~# ?# `& [

zzfree

内存不够用

ensky

Toogle 发表于 2021-11-10 22:09
看了一下，没办法resize，重新建一个吗？如果是，旧的应该如何处理？
( X  ]* x6 |/ I' b& ]2 d8 \5 h谢谢！~

, O& {5 ]+ {( Z  A/ Q, H% K不能resize，这个我没有经验了，看看其余大佬有没有办法。