MySQL被关闭，是什么原因？

Toogle

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

# g* L! S0 `& y- W( u/ X  f1 p8 S2021-11-02 22:59:29 14448 [Note] Binlog end
: k3 n; g; W; j% n2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'partition'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
6 V4 j) W/ }5 l4 j5 g$ ~2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
3 K- r* `! L- @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'
4 n! i/ N2 X! A( U2 F4 k2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2 u6 ^2 K  s- a! K2021-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'
7 y  n1 ?/ w5 B9 t) \# ~& `6 ]6 Y3 Y2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
% W( U' H) i3 G  ^% H. ?* _8 ?2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
6 \! T' \0 U& A- a2021-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'
# I+ H% l' D5 ]- I, z' b2021-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'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
  b7 @( l0 i. M; F  E1 Q4 h8 e* v2021-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'
$ n" o" G6 ~$ A5 I. J: T) W, y2021-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'
1 g8 x& o  B/ J8 b6 s: K! B2021-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'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMPMEM'
# m! E' v- H* B, ]7 A) K- t$ D2021-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'
& U8 N8 ]; r  W# |  M5 x# Y+ l9 W2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
! c2 [' E8 j) ^; d0 L# o2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_LOCKS'
2 A8 Q/ m+ G7 A: e% s3 O) ~2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_TRX'
$ V; G8 l1 `$ R( M5 G! L; M2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'BLACKHOLE'
6 C# L3 A) c0 i% v$ H  \1 @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'
6 ^# r$ k! G- N$ ?9 [5 e7 S2021-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'
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

9 Z* I* H, W" x
谢谢！~
- e( Y) \0 V( [3 p2 }

Toogle

检测当前服务器的MySQL端口是否安全（ 检测时间：刚刚，耗时：23.50毫秒 ，等级：中危）折叠  |  忽略  |  检测
2 c/ O" {% s* |9 l+ h. ?& P检测类型：MySQL端口安全风险等级：中危
8 w8 N* A) Q7 H风险描述：当前MySQL端口: 3306，可被任意服务器访问，这可能导致MySQL被暴力破解，存在安全隐患
解决方案：1、若非必要，在【安全】页面将MySQL端口的放行删除
2、通过【系统防火墙】插件修改MySQL端口的放行为限定IP，以增强安全性
: }2 q+ a7 D+ L4 X6 {( V3、使用【Fail2ban防爆破】插件对MySQL服务进行保护
7 M! h: ?5 S' L) {2 _, _% Y; w
5 d; ]+ d( ^6 Y( ]" V& ^4 f  F这个？？
  M1 z6 o4 [# {$ p" I: r* g/ D: K
- Y* y) n, n. K+ S8 u+ g很少研究宝塔的使用，看来得多看看……

Toogle

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

2 Q; r. V% ]5 P7 u5 z: b

河小马

error log 日志不全啊。。目前还是无法判断的
先重启mysql吧，然后时时观察一下mysql
" e4 a+ ~5 b2 j6 c4 {

老刘

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

Toogle

河小马 发表于 2021-11-9 17:00
5 {% S% y, @3 h% b  @, Xerror log 日志不全啊。。目前还是无法判断的
先重启mysql吧，然后时时观察一下mysql
...

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

应该是2号出现的，下面这个是2号全部的日志。
: K5 {3 t2 I, o/ E# J" t
2021-06-27 22:54:22 4646 [Note] /www/server/mysql/bin/mysqld: ready for connections.
8 O5 o4 `; J# a: X2 g& T; n5 GVersion: '5.6.37-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
! ]. _  k' ~4 a9 g
2021-11-02 22:59:29 14448 [Note] Plugin 'FEDERATED' is disabled.
0 X8 x* j, t" f( W  s4 E2021-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
, m' ^$ P' C& u. M2021-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
1 I" n& W! s3 _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.
; B, W& b) ?- {% g2021-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

0 U) H& i7 }6 A7 O2021-11-02 22:59:29 14448 [Note] Binlog end
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'partition'
7 ^* M- c! n3 ~8 N! ^% R7 `2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
  V( T3 O% J3 m8 c. W2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
6 i3 \% K8 b! [% \: A+ Q2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
- J! U+ P0 L* J  B6 }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'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
0 M- x: w# N, u! k7 B& I* h2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
6 Q# f. @( W( p4 N) _5 d6 ]2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
# a5 _& a( S. G2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
" ^6 f: E- f5 [1 {, \2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
9 f! L/ _+ O6 G- e( H5 |5 h2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
) x" i8 j$ v2 U2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
" L5 [# L# z8 L; E0 L: q! V! N' |2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
5 t# H$ I$ E3 c3 _. C2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
/ v  `- M6 ?# d: T- ^5 J  y% R2021-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'
& e9 }$ y1 x2 w1 q: q0 m2 e2 [/ c# F: U& h1 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'
7 Q7 n% o( P) Y7 }6 }2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMPMEM'
& ^' A1 _" ]) t/ Y2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP_RESET'
6 b/ _! \! V8 P4 }7 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'
5 @' u% N- P1 ]4 |! G& z& h# y; y2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_LOCKS'
$ w1 [3 I# a. Z% a6 s) v- R2021-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'
6 J4 ~+ ]( G0 p- o- \5 }" m" w2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MRG_MYISAM'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MyISAM'
  u( H  Y, b! ~) \% R. a0 M' z2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MEMORY'
$ [# Z7 T4 P, ~" i; d! Y, G, z2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'CSV'
2021-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'
3 F" H$ r" |/ ?  I/ _4 w2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'binlog'
; {7 y6 d5 f' v2021-11-02 22:59:29 14448 [Note] /www/server/mysql/bin/mysqld: Shutdown complete
+ k8 \7 ]! l0 W- v
2 m( E  m$ S" H' {) E* B2021-11-09 15:13:07 2834 [Note] Plugin 'FEDERATED' is disabled.

sead

1. df -hl

复制代码

3 j# F+ Q$ I" O先看看硬盘是不是满了

Toogle

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

% d, [9 S+ m( ~这个宝塔控制面板里也看得到，没满……

ensky

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

Toogle

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

" d7 w; `- k8 \9 K) m6 z) G, J9 D1核
RAM 2GB

在哪里改？
2 e  G' E' ~& C  z* V
谢谢！~

ensky

Toogle 发表于 2021-11-10 15:38
9 w0 `, [! R7 Y% A0 I- z2 G1核
3 i. D3 S6 h, V/ KRAM 2GB

1 j6 M$ u7 J0 j) H+ \! E4 K: h看这个地方https://www.advertcn.com/forum.p ... mp;page=1#pid490481

Toogle

ensky 发表于 2021-11-10 16:31
" g4 V% x- \$ m% u看这个地方https://www.advertcn.com/forum.php?mod=viewthread&tid=97673&page=1#pid490481

看到了，之前我还回过帖子，只是忘记了……

这就搞一下。

谢谢！

Toogle

ensky 发表于 2021-11-10 16:31
! q9 u1 V' ^; q. y3 _. ?! r" j6 A看这个地方https://www.advertcn.com/forum.php?mod=viewthread&tid=97673&page=1#pid490481

看了一下，没办法resize，重新建一个吗？如果是，旧的应该如何处理？
谢谢！~
6 P2 i7 r3 Y6 [3 G

! a, `4 X6 e3 b* r* n

zzfree

内存不够用

ensky

Toogle 发表于 2021-11-10 22:09
看了一下，没办法resize，重新建一个吗？如果是，旧的应该如何处理？
0 s* o) m) M# }' k谢谢！~

' p6 e7 i' \) T) b# k( t7 I不能resize，这个我没有经验了，看看其余大佬有没有办法。