MySQL被关闭，是什么原因？

Toogle

突然发现打开网站，连接不上数据库，于是登录宝塔，发现MySQL被关闭了。看了一下，应该是2号被关闭的。日志如下：
$ U+ ^5 [# }& ?6 @  ~" k
2021-11-02 22:59:29 14448 [Note] Binlog end
" q' d" ~5 r2 i! n1 v2 Y# R' f2021-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'
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'
; Z) _% h- @) f3 Q1 Q" ^, R2 F2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
* S; a) b+ B% y: K6 w2021-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'
: C, O# q: t& Z  a8 ]2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
6 ^5 o( J5 x2 p6 `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'
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'
2 A) j! B( E" s, @/ M* n2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  Z* F3 U9 B5 C1 B3 g5 L1 n2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
# X) Z1 Z% ^. c, q4 P9 ^& E* I2021-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'
4 p( c$ ~% n; m- u5 R2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
- K) I/ i$ u7 I4 ~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'
! v) I& O6 l4 y, r2021-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'
/ i8 u' q# J! A. `4 [" C8 g6 K* }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'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP'
7 b3 A5 }9 ^8 L, S" I/ C2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
' b+ l- p; o+ E3 H: ?1 K) X% A/ T2021-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'
2 [0 q- a4 ^" d" [4 E0 L: r2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MRG_MYISAM'
" ~& U& B9 Q( \& W) z& @# R2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MyISAM'
8 u2 \: [/ o8 {. \5 [( U9 l2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MEMORY'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'CSV'
9 z5 _; O' a# D, H2 Y2 L# 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'
' n: M6 l1 p9 \/ y; L) L2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'mysql_native_password'
3 \( O# J/ b- K$ T' l8 r6 B) E2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'binlog'
9 l, S, P2 ]6 Y2021-11-02 22:59:29 14448 [Note] /www/server/mysql/bin/mysqld: Shutdown complete


3 w+ t1 l; `6 e& {* \谢谢！~

Toogle

检测当前服务器的MySQL端口是否安全（ 检测时间：刚刚，耗时：23.50毫秒 ，等级：中危）折叠  |  忽略  |  检测
检测类型：MySQL端口安全风险等级：中危
风险描述：当前MySQL端口: 3306，可被任意服务器访问，这可能导致MySQL被暴力破解，存在安全隐患
解决方案：1、若非必要，在【安全】页面将MySQL端口的放行删除
+ r% o5 y% w4 \* O5 e  q2、通过【系统防火墙】插件修改MySQL端口的放行为限定IP，以增强安全性
6 H; y& K# i4 T: p3、使用【Fail2ban防爆破】插件对MySQL服务进行保护
2 n3 `" G+ k. p0 D
这个？？
: F" w# A; V. C3 v  n
! u1 U6 ^$ t1 j. s1 |. E很少研究宝塔的使用，看来得多看看……

Toogle

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

河小马

error log 日志不全啊。。目前还是无法判断的
  ]/ @  n' t. A" b& Z, ^先重启mysql吧，然后时时观察一下mysql

老刘

日志不全.  盲猜是崩溃了
- \* l/ k! D# a升级到MYSQL5.7试试

Toogle

河小马 发表于 2021-11-9 17:00
7 z( p0 Z9 L. herror log 日志不全啊。。目前还是无法判断的
9 `$ D/ v" i* u先重启mysql吧，然后时时观察一下mysql
...

7 y2 l; I* b, i- ]6 Q0 X* y$ a好的，已经重启正常了……

应该是2号出现的，下面这个是2号全部的日志。
6 i* s. r+ |4 [6 g" S' P3 y' X
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.
2021-11-02 22:59:29 14448 [Note] InnoDB: Using atomics to ref count buffer pool pages
. b0 r: ?; t% H7 P: G9 x9 Y9 G' J2021-11-02 22:59:29 14448 [Note] InnoDB: The InnoDB memory heap is disabled
3 I& c: w0 e, c" N; u: B2021-11-02 22:59:29 14448 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
5 G$ m. s- W2 c2021-11-02 22:59:29 14448 [Note] InnoDB: Memory barrier is not used
: {1 U- e% h& ~, {2021-11-02 22:59:29 14448 [Note] InnoDB: Compressed tables use zlib 1.2.3
* d3 s: x& e+ C, ^1 Z- U2021-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.
+ G$ k, G. Y4 Q! ]6 C2021-11-02 22:59:29 14448 [ERROR] Unknown/unsupported storage engine: InnoDB
2021-11-02 22:59:29 14448 [ERROR] Aborting
7 g3 r4 E+ P/ u. j( Y
% `7 ~. a( Y/ Q* C9 A2021-11-02 22:59:29 14448 [Note] Binlog end
# @' B7 L' c; P2 M1 F2 S* A2021-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'
" _) E2 u% u: y) M2 v8 _2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
, t- i& J7 G0 k* y* ?& D2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
- Y5 ]) o; @7 q3 U; l/ c6 H5 V2021-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'
, n6 O. w% H. S9 a6 W' Q/ d2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
* I! T9 |5 F3 G7 `: b7 j0 S2021-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'
6 a6 n: Y3 y% v6 C- ]  ^1 @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'
5 o3 @9 G0 a2 g4 W; x2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
3 Z& ~. T$ O4 z* b( Q2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DELETED'
1 K: c9 e' s. |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'
& k8 m1 f! ~1 c: ?- W. @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'
  q& A& W6 Y' Z( }( d! g$ e" u2021-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+ `9 |3 l8 H$ @2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMPMEM'
& u( w( s9 B! ~1 l; p8 A( m/ q2021-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'
& i+ l4 F2 B+ a1 b9 J( \' N0 `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'
. i% g2 R6 |* J2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'ARCHIVE'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MRG_MYISAM'
$ a6 t0 w/ }& N, w2021-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'
7 ?# b/ r5 s0 I8 S& e7 G2021-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'
+ I- ?) l  t  J5 K. G0 ?. x2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'mysql_native_password'
* ]* |' J) d# ]! G: A2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'binlog'
! L- N" u9 z7 h' J2021-11-02 22:59:29 14448 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

/ \- V, f, T$ `* k8 q  @0 l2021-11-09 15:13:07 2834 [Note] Plugin 'FEDERATED' is disabled.

sead

1. df -hl

复制代码

* E$ q+ q4 N  K+ v, P, A" L1 F, X先看看硬盘是不是满了

Toogle

sead 发表于 2021-11-9 23:47
, S8 v! y! g+ [$ ~先看看硬盘是不是满了

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

ensky

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

Toogle

ensky 发表于 2021-11-10 14:57
  R3 _# P! G" n0 m& m4 m$ U你这个机器什么配置？几核几GB的RAM。我以前遇到过1H1GB装宝塔有问题，需要改配置的，不改配置几天MySQL就 ...

1核
# v/ N4 e" l# C. g& B( s! z! ^; l# K$ DRAM 2GB

: ~! C5 C! r  [6 y1 K7 W在哪里改？

谢谢！~

ensky

Toogle 发表于 2021-11-10 15:38
! _9 k+ |$ j9 F* o5 g1核
RAM 2GB

* p3 p! v5 h8 H% ]* V看这个地方https://www.advertcn.com/forum.p ... mp;page=1#pid490481

Toogle

ensky 发表于 2021-11-10 16:31
1 a/ b. t' @* g6 V7 Z; R3 ]看这个地方https://www.advertcn.com/forum.php?mod=viewthread&tid=97673&page=1#pid490481

6 q# H- S/ c$ Q( I) \看到了，之前我还回过帖子，只是忘记了……

# A: S3 i+ h# i5 m3 `& w这就搞一下。

谢谢！

Toogle

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

看了一下，没办法resize，重新建一个吗？如果是，旧的应该如何处理？
( t. k8 b* @7 u- v: @+ i, i* A% G! r& L谢谢！~
1 W- G; q) u" \% y! V
7 f1 `7 P! K, h
, t1 K9 o1 m3 j7 ?4 D0 n& L" G

zzfree

内存不够用

ensky

Toogle 发表于 2021-11-10 22:09
3 A) _7 y! u6 d# z' x% i看了一下，没办法resize，重新建一个吗？如果是，旧的应该如何处理？
& }0 l) D& o/ _  p% K5 x7 U谢谢！~

% e- M7 o3 O& u0 `: F7 t* k- b不能resize，这个我没有经验了，看看其余大佬有没有办法。