MySQL被关闭，是什么原因？

Toogle

突然发现打开网站，连接不上数据库，于是登录宝塔，发现MySQL被关闭了。看了一下，应该是2号被关闭的。日志如下：
/ y, q# z6 @1 O0 f  i1 a& c
2021-11-02 22:59:29 14448 [Note] Binlog end
" c! c! P, J5 N8 h, c+ k2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'partition'
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'
: r1 |) z# G& Q7 M% H' b) c7 L2021-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'
* O& X, D9 u! m$ [1 u- x; K2021-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 {% `+ P& V2 r2021-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'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
! m" R( c, C1 `# M) t3 o2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
; k0 W; R: T' |# b* P/ w2 c8 e, F, l$ q2021-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'
0 f8 Y$ `* A2 X4 ?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'
% Y2 @8 c1 V; }0 K) |; U& S2021-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'
2 q2 ], V2 P& {, I" |$ e2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
* ~3 g" i+ G" j' ~+ D2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
  Y( B2 e8 L& ?- p! \) ^7 I2021-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'
: |1 I9 K5 Z  h7 `; b8 M" r2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMPMEM'
) R8 X5 ]; v. A7 S0 l- X# |2 k  t2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP_RESET'
- |7 K6 C: ^  _+ Z- ^2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP'
" x6 g+ A  j/ X2021-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'
. l7 H" N; R% O5 x2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_TRX'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'BLACKHOLE'
$ |: c% [; b% Y1 S# ^+ B2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'ARCHIVE'
" W9 I: r2 w. U) A7 O( f2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MRG_MYISAM'
5 p- Q! `: @- e5 t  ]% V2021-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'
4 Q4 \/ E/ S) U6 o8 ~' P7 Q# n( }4 Q2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'sha256_password'
& g& j6 R0 K$ t0 h3 r1 p2021-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'
7 _! n$ e$ a9 s1 i* \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


3 h: M; C2 W1 ^" W* w谢谢！~
8 E9 j7 A! @' v0 \
6 k- ?# j; _4 n- C8 V( `8 q# m$ F

Toogle

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

这个？？

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

Toogle

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

$ w6 Z- E; w# e! B! I0 ?

河小马

error log 日志不全啊。。目前还是无法判断的
# ?# c, v2 Z& }先重启mysql吧，然后时时观察一下mysql

老刘

日志不全.  盲猜是崩溃了
2 e! ^( G$ E! c! F3 V5 v8 L升级到MYSQL5.7试试

Toogle

河小马 发表于 2021-11-9 17:00
; Q, b) F; Q7 ]9 \! t1 \! `error log 日志不全啊。。目前还是无法判断的
先重启mysql吧，然后时时观察一下mysql
...

好的，已经重启正常了……

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

2021-06-27 22:54:22 4646 [Note] /www/server/mysql/bin/mysqld: ready for connections.
7 n/ m( H: X! JVersion: '5.6.37-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
/ x" ]% S1 h- ]: ~$ g0 T7 }$ y* r
2021-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
5 ~; V* f4 t& d/ A2 _% j2021-11-02 22:59:29 14448 [Note] InnoDB: The InnoDB memory heap is disabled
! _+ [% f* w' y+ Q! M/ @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
: @* r6 ^) b% C0 v4 y: T% v2021-11-02 22:59:29 14448 [Note] InnoDB: Using Linux native AIO
" I. h0 E% ?2 ?2021-11-02 22:59:29 14448 [Note] InnoDB: Using CPU crc32 instructions
  @' ~- P) P/ f. N# u$ b2021-11-02 22:59:29 14448 [Note] InnoDB: Initializing buffer pool, size = 128.0M
7 o% P% Y( j9 G; G; [$ p+ }* D6 B1 ^3 dInnoDB: mmap(137363456 bytes) failed; errno 12
  [8 N1 {; S- ?% A' N  Q5 l2021-11-02 22:59:29 14448 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
+ ~0 X/ m: ?) c: e. {2 U9 s2021-11-02 22:59:29 14448 [ERROR] Plugin 'InnoDB' init function returned error.
2021-11-02 22:59:29 14448 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
& ?( @6 j' _# ]2 E) t  K2021-11-02 22:59:29 14448 [ERROR] Unknown/unsupported storage engine: InnoDB
/ t, S4 ?1 I0 Z1 N2021-11-02 22:59:29 14448 [ERROR] Aborting
" i6 p: h+ k. z  k6 o, p/ J9 l* I2 `. d
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'
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'
' C  R3 J3 U( Q2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
, J6 ]( V: i7 `! i0 N8 v0 ~2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
# \6 Z) N6 W  g% ~5 o2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
1 U4 t; ~( ~( n, Q1 g6 {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'
4 ]! d, P  l9 L( N8 x4 D2021-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'
; k+ [5 A- l/ b0 h5 C/ t* y2021-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'
" G: }! m9 a5 U$ E  n' }2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
# M0 S4 h$ J. @) o! G% \7 R4 S2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_METRICS'
9 @- t; @+ A: w7 K; P: \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'
% ^$ s% E, u5 h) \( s- R! Z5 Z2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
- l: O8 r7 r2 n5 ?2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
' u% j- H3 q( A/ `7 n1 _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'
' |# I) @5 h8 O  `8 G2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP_RESET'
5 n4 p6 d) k2 }/ G4 b& P2021-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'
& Q6 D  j7 Y4 u- g* ^! i5 j1 Q6 l2021-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'
2 X( d: }* [7 \2 P: M2021-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'
; c  p/ I/ l; x8 r2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'mysql_native_password'
+ F7 S+ @& p2 }( ^2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'binlog'
; o& }( f! _7 g  k2 |1 R  F2021-11-02 22:59:29 14448 [Note] /www/server/mysql/bin/mysqld: Shutdown complete
. x. M5 `* l  w4 V7 |' v6 E6 H
. x$ h, o" B5 ]5 y2 X0 N2021-11-09 15:13:07 2834 [Note] Plugin 'FEDERATED' is disabled.

sead

1. df -hl

复制代码

先看看硬盘是不是满了

Toogle

sead 发表于 2021-11-9 23:47
1 S8 p% |2 c1 }! |先看看硬盘是不是满了

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

ensky

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

Toogle

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

- p. T/ D  h* i: }4 b. i3 x1核
2 n/ R; b% j, P0 F7 gRAM 2GB
$ v  r* d% K3 D' ^
在哪里改？
) B' I' M  d. w) i# n( C
% g4 N7 w/ Q1 f6 W( ^2 f/ z0 l谢谢！~

ensky

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

& N3 r0 E9 \0 V看这个地方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

看到了，之前我还回过帖子，只是忘记了……
2 T- Q8 e* W- `+ @1 J( }
3 c3 T1 x+ E, q" _' D- I9 g: `* }7 E这就搞一下。
, D5 V, U( m, [* @
谢谢！

Toogle

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

看了一下，没办法resize，重新建一个吗？如果是，旧的应该如何处理？
( Z" Z5 N% ]0 d# K) k' _5 ^谢谢！~
' ~; Y" z3 i7 t, M$ Y! g

* r* V2 F( d' {/ ]: E2 h

zzfree

内存不够用

ensky

Toogle 发表于 2021-11-10 22:09
$ G. x7 o2 z  C* X% _6 S看了一下，没办法resize，重新建一个吗？如果是，旧的应该如何处理？
* A( B: |& ]9 Y8 t) S  F谢谢！~

6 J% E" J2 e* V# @" C不能resize，这个我没有经验了，看看其余大佬有没有办法。