MySQL被关闭，是什么原因？

Toogle

突然发现打开网站，连接不上数据库，于是登录宝塔，发现MySQL被关闭了。看了一下，应该是2号被关闭的。日志如下：

# g. J1 m; C" ?) j' f2021-11-02 22:59:29 14448 [Note] Binlog end
6 T% N, t  y0 y: t- C/ {6 V6 g2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'partition'
" P, Y$ h$ p! R4 e, N2021-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'
: J* ]+ }) a; L: M2021-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'
( W% G8 Q4 o) {* s+ r, 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'
$ p% ]/ i, `( ^6 b. R% M2021-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'
* ^% b; R1 _% j( r8 v% m, e) x1 C2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
# ]% T% S- Z$ @% }/ f6 U+ g3 m( z2021-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'
) X0 d7 E) v  x; [$ W2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DELETED'
/ l, \8 k4 @- K' y- x2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
! l* `, J! G- w! N" J  z2021-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'
9 j6 a( M) ]1 `/ q7 I# Z/ p0 ^2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
" I  X% f/ S* ?& F# y  a2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
8 H9 |/ z! z2 ], ]: M2021-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'
7 [8 Z/ w8 o) n9 ?( l9 [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'
2 ~4 m& x# B  C% u' l7 q' v% L2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP'
9 D0 M% z! P" c  u! T) l! D2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
- I( W2 Z2 E- k, g' E* `9 ?2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_LOCKS'
1 G1 d$ E' B' S* r" t4 p2021-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'
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'
. f% h. W+ q. e% 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'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'mysql_native_password'
" v  F3 B1 i! z1 L8 J' k5 f2021-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

7 l, B- `- T6 ~& ]
0 x- i. |7 {! X# T谢谢！~

Toogle

检测当前服务器的MySQL端口是否安全（ 检测时间：刚刚，耗时：23.50毫秒 ，等级：中危）折叠  |  忽略  |  检测
( n& U- X' h0 ?0 A检测类型：MySQL端口安全风险等级：中危
风险描述：当前MySQL端口: 3306，可被任意服务器访问，这可能导致MySQL被暴力破解，存在安全隐患
解决方案：1、若非必要，在【安全】页面将MySQL端口的放行删除
4 t, C( A- ]* M; z5 \3 V2、通过【系统防火墙】插件修改MySQL端口的放行为限定IP，以增强安全性
3、使用【Fail2ban防爆破】插件对MySQL服务进行保护
+ f& g" x# Z7 J- _/ j8 o: }3 ^- P8 ^
- m! w: y" P6 j4 D" c8 w  ?# J0 g" O. o这个？？
  {$ N, U/ e* }# R( `* i; e- J( L% V
很少研究宝塔的使用，看来得多看看……

- E0 _  _( G' e/ {2 p

Toogle

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

河小马

error log 日志不全啊。。目前还是无法判断的
先重启mysql吧，然后时时观察一下mysql
$ V+ S( |0 O6 \% u" r' K( A

老刘

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

Toogle

河小马 发表于 2021-11-9 17:00
! c/ r+ }, l0 i8 ?7 b/ D7 r3 oerror log 日志不全啊。。目前还是无法判断的
8 ?* Y  w5 x& I0 z) F1 W- o* n) _先重启mysql吧，然后时时观察一下mysql
...

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

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

( Z1 w4 a) t' W/ l. g2021-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.
6 c! n$ M0 [( A2021-11-02 22:59:29 14448 [Note] InnoDB: Using atomics to ref count buffer pool pages
9 t7 J  ^' l5 K: ?2 [6 I1 ]2 D2021-11-02 22:59:29 14448 [Note] InnoDB: The InnoDB memory heap is disabled
, u6 D5 C) }3 k$ C' V2021-11-02 22:59:29 14448 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  ?" C/ n7 Y2 d  x4 V2021-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
: l: }1 Z/ y! R& \, T- l+ V9 B* CInnoDB: mmap(137363456 bytes) failed; errno 12
2021-11-02 22:59:29 14448 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
4 }6 U% s5 Q* a7 l. v2021-11-02 22:59:29 14448 [ERROR] Plugin 'InnoDB' init function returned error.
7 z( M2 a! A" H0 d! c8 C2021-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
2 V6 v; m2 V$ A- X2021-11-02 22:59:29 14448 [ERROR] Aborting

2021-11-02 22:59:29 14448 [Note] Binlog end
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'partition'
, K: f$ ~7 [) d- U  v4 o2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
4 Y$ E3 p3 A' u, \, T2 ], m6 k. E2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
0 R0 S' y9 }) |9 i2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  a6 q& b' Z4 T* C2021-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'
" W; t+ }% P! I2021-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'
+ s* X: W$ B$ r5 o! R  O4 M5 T% P2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
$ |4 i  Q  g3 @+ d2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
' H; d% \0 w6 {4 W. e/ Q+ N2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
! F  X# ^+ o6 u8 U3 X8 O  H4 ~2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
+ c% O( D6 Z$ R/ c% w- _2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
* q4 F  ^: f8 U+ m2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
! C5 \; F7 }& e+ l1 z2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DELETED'
1 _4 s6 m  {2 E1 [7 s, a7 s2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
( a+ ^# z5 ~- V( y6 _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'
: O# a( q; q# f8 ^) g2021-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'
% \, o, m& I5 L2021-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'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP_RESET'
( {/ H  G& x/ g! L2021-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'
& q4 Y5 a) f' ~7 @& T+ z2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_LOCKS'
3 u. X& j) d# u: E+ n6 [2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_TRX'
. v- T# p2 Z8 T: T7 @1 D2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'BLACKHOLE'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'ARCHIVE'
4 W; B, r5 b6 @* \$ q* }% I' h2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MRG_MYISAM'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MyISAM'
* t4 s3 z! y7 e/ p5 o0 u: p2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MEMORY'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'CSV'
7 G1 _" t& C0 j) q( R4 e2021-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'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'mysql_native_password'
# U% E8 k$ {9 P2 P! R5 j) ]2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'binlog'
& y) w: }1 |, H7 [& S# `2021-11-02 22:59:29 14448 [Note] /www/server/mysql/bin/mysqld: Shutdown complete
; q9 J0 w' s  D- n
6 a8 {+ d5 X/ n$ Z! [8 p2021-11-09 15:13:07 2834 [Note] Plugin 'FEDERATED' is disabled.

sead

1. df -hl

复制代码

先看看硬盘是不是满了

Toogle

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

7 \6 h- l- y7 N8 v+ q这个宝塔控制面板里也看得到，没满……

ensky

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

Toogle

ensky 发表于 2021-11-10 14:57
) C+ [, ~3 |9 T5 ?7 i. I你这个机器什么配置？几核几GB的RAM。我以前遇到过1H1GB装宝塔有问题，需要改配置的，不改配置几天MySQL就 ...

1核
RAM 2GB
/ S2 s* L; g# r/ Z6 b7 H8 j7 d
2 [2 u5 {9 X5 |6 |. X" ~  d# @4 @& A7 R  A在哪里改？

4 x9 L1 f) G, x- r% {谢谢！~

ensky

Toogle 发表于 2021-11-10 15:38
1核
! q' ^- q$ ^4 w: YRAM 2GB

看这个地方https://www.advertcn.com/forum.p ... mp;page=1#pid490481

Toogle

ensky 发表于 2021-11-10 16:31
) q9 C8 g' U: n6 S4 N# }. w; N, j% r5 l看这个地方https://www.advertcn.com/forum.php?mod=viewthread&tid=97673&page=1#pid490481

1 b/ x; Q, Q! j. w看到了，之前我还回过帖子，只是忘记了……
  v. N6 n$ J8 M* @
这就搞一下。

谢谢！

Toogle

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

看了一下，没办法resize，重新建一个吗？如果是，旧的应该如何处理？
谢谢！~

zzfree

内存不够用

ensky

Toogle 发表于 2021-11-10 22:09
3 k" O; S- y0 e9 k  P- w看了一下，没办法resize，重新建一个吗？如果是，旧的应该如何处理？
谢谢！~

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