MySQL被关闭，是什么原因？

Toogle

突然发现打开网站，连接不上数据库，于是登录宝塔，发现MySQL被关闭了。看了一下，应该是2号被关闭的。日志如下：
* e9 p/ D) u& z4 F( C" k1 }' d4 l
( ~0 k8 y/ m& i; W+ U2021-11-02 22:59:29 14448 [Note] Binlog end
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'partition'
/ @! l' m* b" ]2021-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'
! u4 C' E0 P  _5 v0 f4 Q2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
( _4 R1 L( T, H. R3 J2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
/ n- W7 d' S1 `. E2021-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'
  o- c/ T' l3 x6 ?0 G* I8 M) t2021-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'
3 o& s# e. Z9 ~+ L% q2 A4 y2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
0 e: V/ ]# Y( n! a& v2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
% L3 t" ]9 V) w& c2 f0 K2021-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'
/ f8 x3 o; m( c5 Q; f" o' S2021-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'
# K5 E/ ~4 ^9 P' I, g0 A0 o2021-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'
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'
+ ]! _- T* H- T1 i) v0 j) _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'
& Q* U! V3 b( @( N$ d1 ]2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP'
1 P9 R- C  F- w1 _- E$ }2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
' Y( b9 F4 I2 B1 M5 t' L0 [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'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MRG_MYISAM'
$ n" X- H0 Y# c  ]2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MyISAM'
, b2 o3 T. w# E. @) Q% p2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MEMORY'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'CSV'
5 n  m4 T1 c  k) ^+ O: D2021-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'
' e2 l" `. L/ O2 _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'
( n6 ]! N: s& c2021-11-02 22:59:29 14448 [Note] /www/server/mysql/bin/mysqld: Shutdown complete


- u7 P8 M& s( [; i! j% I+ x" a谢谢！~
- G/ y6 Y/ G' h5 d4 b' ?5 K
- d% t! ?9 D% t& u1 G4 I* \, k

Toogle

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

很少研究宝塔的使用，看来得多看看……

0 I- W) N( C% ?, x. @9 ^( S5 W2 \

Toogle

Fail2ban防爆破是免费的，刚刚安装了，还有什么其它建议吗？
! H8 S6 U$ G2 L0 \, b
$ ?  U! k) B0 a* t

河小马

error log 日志不全啊。。目前还是无法判断的
" f  n0 D" }& q" L; O先重启mysql吧，然后时时观察一下mysql
, U& |" q) [- Z& K3 D: s/ ]/ K( q

老刘

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

Toogle

河小马 发表于 2021-11-9 17:00
error log 日志不全啊。。目前还是无法判断的
先重启mysql吧，然后时时观察一下mysql
6 R4 L: [1 C4 R& c1 z ...

/ u' Y/ t" a$ X2 `* n/ G! Q& S好的，已经重启正常了……

1 |* w) o5 m* m/ `7 \3 N' I应该是2号出现的，下面这个是2号全部的日志。
+ `& Z1 ?4 T. V! i
- ^* ]- e1 X) ?) Z/ q8 Q. }2021-06-27 22:54:22 4646 [Note] /www/server/mysql/bin/mysqld: ready for connections.
5 H( J7 E2 q# E4 q$ L7 Q5 `Version: '5.6.37-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
" W. V  b8 T7 m6 Z( J% i
3 W3 S+ e' }8 _, h# N5 z2021-11-02 22:59:29 14448 [Note] Plugin 'FEDERATED' is disabled.
3 d0 y+ K: K( B- o' X6 X2021-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
( g9 e) H- L4 z" e, G1 B2 a2021-11-02 22:59:29 14448 [Note] InnoDB: Memory barrier is not used
; m) t- I# K% h4 k' z0 m  b2021-11-02 22:59:29 14448 [Note] InnoDB: Compressed tables use zlib 1.2.3
% j: _/ P* u7 T; H, q3 T2 i7 F2021-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
/ S! m6 k0 i2 v! i* F( U7 E- D2021-11-02 22:59:29 14448 [Note] InnoDB: Initializing buffer pool, size = 128.0M
1 J  H& @( b6 M1 Y- DInnoDB: mmap(137363456 bytes) failed; errno 12
# ]2 w, W$ G% M- i4 F8 ^) [' q2021-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.
, v. f' n# M: I2021-11-02 22:59:29 14448 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
4 j# V0 ^, J5 ], [8 x' t) l$ r7 ]2021-11-02 22:59:29 14448 [ERROR] Unknown/unsupported storage engine: InnoDB
4 w* F$ d  L2 k0 R/ L2021-11-02 22:59:29 14448 [ERROR] Aborting
# k! ]1 X& D$ c4 M
5 r; l$ K# X$ O: R- |6 t2021-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'
( P3 u% b( T0 g$ \7 t2021-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'
4 h$ X" q' V2 [2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
, g! l1 X$ Q3 D2 H: d2021-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 u7 S; y2 e' q9 d" j2021-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'
+ Y! K' T6 j3 i5 M5 Y7 L' [2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
& T$ N2 {) v9 S  }$ _2 j2021-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'
* S+ M. @: D  B% k' z$ W0 a9 Y2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
- t- X9 s3 _5 {. E- K2021-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'
8 F; g( |) d" a" B2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
8 N6 B4 B/ o8 w( b. }2 [2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_METRICS'
6 R0 o/ l# N! s/ \% \1 r' f2021-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'
" ~. q" |4 \  ^! f' R" @, f9 R2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
' b4 \7 @3 S9 \( U4 G7 o2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
+ X$ F% ^, X& g$ k; ?6 b3 r6 H6 ?! i4 c2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMPMEM'
: g& F4 v, d) _' @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'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
* }1 C% i; @, V, i4 h, u3 `  V2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_LOCKS'
3 I$ n. t9 I& S; U; X2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_TRX'
& V0 m9 C/ c* t* ~: m( ?9 }/ Q2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'BLACKHOLE'
* D. }& s) v9 ^5 d& T9 i2021-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'
, s1 N  a! |& G' x% w2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'CSV'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'sha256_password'
) s4 K: S% A# A# E: v- `& n2021-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
, S8 e; Z7 g/ O
2021-11-09 15:13:07 2834 [Note] Plugin 'FEDERATED' is disabled.

sead

1. df -hl

复制代码

4 j4 g; Q/ T7 K, T  r0 e7 N先看看硬盘是不是满了

Toogle

sead 发表于 2021-11-9 23:47
; {2 [: b1 j  r& s: P先看看硬盘是不是满了

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

ensky

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

Toogle

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

1核
RAM 2GB
+ v5 S  a5 }* U4 Q. w
在哪里改？

谢谢！~

ensky

Toogle 发表于 2021-11-10 15:38
1核
: z9 D/ [8 p# G7 ^& Q1 wRAM 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

7 B# z) K. Q+ K3 P7 D看到了，之前我还回过帖子，只是忘记了……

. M8 c; }/ o; X+ _9 @这就搞一下。
. @0 h, a$ ?) ?+ a
' @% m! Z# E! u) p4 |6 r( ~) d& l谢谢！

Toogle

ensky 发表于 2021-11-10 16:31
2 F4 Y  k: D' `, D, a, {5 j8 ?( n看这个地方https://www.advertcn.com/forum.php?mod=viewthread&tid=97673&page=1#pid490481

看了一下，没办法resize，重新建一个吗？如果是，旧的应该如何处理？
谢谢！~
( C& p9 m5 \3 e9 B* r
$ R5 R. u7 F2 r% p# f: Q+ c
6 x" b( C' _# C" ^7 U

zzfree

内存不够用

ensky

Toogle 发表于 2021-11-10 22:09
- v; I7 o+ ~4 P8 }看了一下，没办法resize，重新建一个吗？如果是，旧的应该如何处理？
; _3 v/ J; m2 x( r# X谢谢！~

% }, Y5 e7 u6 q( f" n  e9 C不能resize，这个我没有经验了，看看其余大佬有没有办法。