MySQL被关闭，是什么原因？

Toogle

突然发现打开网站，连接不上数据库，于是登录宝塔，发现MySQL被关闭了。看了一下，应该是2号被关闭的。日志如下：
7 z  }, i5 r! I. l% s9 B" H) R. y: h
* g! V2 `) h4 h, j- B2021-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'
9 a6 p2 u- B6 r1 A2021-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'
& O3 H8 g( G/ p" [  ]( K; Y$ K; O6 m2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
3 |: }9 N. g( ]+ s7 g: c* X- f2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
+ ]8 p" X4 x7 d4 L$ E2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
% R) p5 D6 y" w" L: ]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'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
, L* i- y1 `2 v. R0 @6 X+ s6 C2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
: y8 i0 u; l. f2 U- i+ ^) G& u2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
7 p7 `' C+ w0 Z* y7 ?2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
! s3 P+ ?$ n3 Q' ], B; s: v: ?2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
5 J4 g. |$ d, @1 _. V2 W* a  |' u! |! I2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DELETED'
! K- T7 k$ ~, F  P0 H$ C7 B2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
& b/ B' c9 q9 Q7 R% q! a2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_METRICS'
  }( S* g% P8 X& r' U$ x2 B2021-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'
% e* _: N5 ]% E+ p+ H2021-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'
- c) y$ `' o8 O8 ^6 H% ]2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
% u) N0 I6 h9 t8 B5 M2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMPMEM'
" O: W; F  ^% q/ Z2 N2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP_RESET'
* Z2 k% T  o6 [. I2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP'
* {: O' o7 l( l* C, I) T2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
; e4 ?2 E! j; N) I8 f2021-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'
- a+ D! u: k( B7 N* K  p( g- ?) w: I2021-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'
5 m" i" S8 e: `/ Q2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'mysql_old_password'
5 c: ~+ {+ T: k0 L1 Q0 ^2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'mysql_native_password'
5 c& @4 o6 f6 U3 z2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'binlog'
; [( C% t% x4 P6 }2021-11-02 22:59:29 14448 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

/ X8 L5 Z1 B0 s+ i& a
! ~8 ~  S% t& q谢谢！~
; W/ a, I6 I9 f1 k! G) _
* t/ b5 A  w( a/ W! R

Toogle

检测当前服务器的MySQL端口是否安全（ 检测时间：刚刚，耗时：23.50毫秒 ，等级：中危）折叠  |  忽略  |  检测
# T- _) z5 A6 c检测类型：MySQL端口安全风险等级：中危
2 I$ r9 b: _8 y+ z# o) ^风险描述：当前MySQL端口: 3306，可被任意服务器访问，这可能导致MySQL被暴力破解，存在安全隐患
解决方案：1、若非必要，在【安全】页面将MySQL端口的放行删除
2、通过【系统防火墙】插件修改MySQL端口的放行为限定IP，以增强安全性
8 S' R" d. g& a$ t7 s  Q3、使用【Fail2ban防爆破】插件对MySQL服务进行保护

7 p4 j0 Q- S& v6 ]' A/ e这个？？

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

Toogle

Fail2ban防爆破是免费的，刚刚安装了，还有什么其它建议吗？
9 V. z; q1 R! W% B7 Z% A
! s/ O1 Y& G' Y, }  D

河小马

error log 日志不全啊。。目前还是无法判断的
先重启mysql吧，然后时时观察一下mysql

老刘

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

Toogle

河小马 发表于 2021-11-9 17:00
% P' `$ `( T; ^1 l5 u3 Derror log 日志不全啊。。目前还是无法判断的
3 E: J0 G  {* B/ w$ o3 \9 \先重启mysql吧，然后时时观察一下mysql
...

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

! m( d( \. s2 W' Q+ e4 b应该是2号出现的，下面这个是2号全部的日志。
" Y$ U& ^8 o% E9 v! L5 ?3 n* u$ J
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
1 P: d! S! C: V% h/ _$ L
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
2021-11-02 22:59:29 14448 [Note] InnoDB: The InnoDB memory heap is disabled
" X/ W% {+ e, ]% t: u! N' a# o2021-11-02 22:59:29 14448 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
4 q! R1 z1 z1 \! w2021-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
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
2021-11-02 22:59:29 14448 [Note] InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
2021-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.
2021-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
+ K3 o" c% L0 S2 C
2021-11-02 22:59:29 14448 [Note] Binlog end
6 M# P2 o" O( J. o" Z- _2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'partition'
; @* |" \- a$ u7 u2 S. r) z9 ?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'
) v4 v( r! Y# l8 y2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
0 w& i4 A2 k+ s3 C8 n2021-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'
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'
- f& `/ Z1 Z4 B0 T1 I2021-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'
9 p$ O$ j$ ?) y; t2021-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'
0 w: e3 E( ?, a# J% j2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  j" N$ s* r: K# {( @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'
+ m/ v1 s. @3 o7 x) x8 p9 p% P2021-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'
* h2 a; e" a4 X3 C4 v# {2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
3 b( ?& _5 a- |0 l) e' y% f2021-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'
4 Q- m, T" f) x2021-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'
+ [% I0 D$ Y: 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'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'ARCHIVE'
  {& v0 H; q8 l6 p3 g2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MRG_MYISAM'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MyISAM'
# D2 G8 r* q9 H2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MEMORY'
1 [* k/ |7 P# S1 V2 Z9 y2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'CSV'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'sha256_password'
0 }. M; _$ @2 O, m( e1 s2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'mysql_old_password'
  W; j% A$ ^6 `, d2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'mysql_native_password'
8 K9 a* x7 L. r; j2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'binlog'
' h% P3 x7 n  l3 |& \, x2021-11-02 22:59:29 14448 [Note] /www/server/mysql/bin/mysqld: Shutdown complete
) P' a  C% i- ?$ {9 b8 Q% H
6 f2 ^; w  o' G: d# R3 Y2021-11-09 15:13:07 2834 [Note] Plugin 'FEDERATED' is disabled.

sead

1. df -hl

复制代码

先看看硬盘是不是满了

Toogle

sead 发表于 2021-11-9 23:47
/ v/ a4 t) j. w+ c先看看硬盘是不是满了

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

ensky

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

Toogle

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

1核
5 ?$ p3 I5 U2 P% V/ Y  V+ A( zRAM 2GB

* Q. e/ G$ i: z0 i# h! K3 R: P在哪里改？

谢谢！~

ensky

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

2 H! @7 t+ [$ T! }: X. }看这个地方https://www.advertcn.com/forum.p ... mp;page=1#pid490481

Toogle

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

; S+ M, E+ y+ P$ L' I# h1 ?看到了，之前我还回过帖子，只是忘记了……
  H7 P8 k. _2 X! H( t# q
- o5 J( M0 v0 X这就搞一下。
" r+ [7 U: E: V1 T' l7 p
4 E. q5 N# ~, c  |7 [谢谢！

Toogle

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

看了一下，没办法resize，重新建一个吗？如果是，旧的应该如何处理？
9 n' N1 x% _. R8 `8 I谢谢！~
$ x( r+ \) O. w& K

zzfree

内存不够用

ensky

Toogle 发表于 2021-11-10 22:09
) P0 g+ \4 |7 i, i6 g# G) |看了一下，没办法resize，重新建一个吗？如果是，旧的应该如何处理？
. S* m! M, M5 l3 X谢谢！~

不能resize，这个我没有经验了，看看其余大佬有没有办法。