MySQL被关闭，是什么原因？

Toogle

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

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'
5 Z/ @, p+ |( L* y) j0 x2021-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'
+ f! {7 T$ M) E- K3 H2021-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. d9 ~3 D( 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'
" t' @- |8 `) H7 R$ S2021-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'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DELETED'
0 C* a' I+ u$ b2 n2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
' U+ n2 c# w" {6 L: W2021-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'
; W6 y2 ^% N5 ?  H2 b% T" ?  F2021-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'
: h; q; H# d: ]0 W2021-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'
9 q5 b: I) \+ j4 r# N$ K) h2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_CMP_RESET'
: B: b, c6 h+ A3 n1 g6 ~) X: h2021-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'
# c0 f/ c9 }2 w5 D- k2021-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'
  P2 v/ a2 r7 E6 e* i( v! X) \2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MRG_MYISAM'
* L$ o( w' w2 h  k" T3 J& N; W2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MyISAM'
. C* h! e/ [, _9 D2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MEMORY'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'CSV'
1 \1 R, X/ e4 G' [! T. G2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'sha256_password'
# y6 @2 @1 D' s! P& }% B$ ~( f) @+ d6 K" M2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'mysql_old_password'
; i& d* r, U  p: e# L2 z7 c1 E2021-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'
. k8 S) c# H; _8 _' B  z2 W/ g9 F2021-11-02 22:59:29 14448 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

3 r" e5 \' N# z; G' Y+ R, p2 w( F
谢谢！~

Toogle

检测当前服务器的MySQL端口是否安全（ 检测时间：刚刚，耗时：23.50毫秒 ，等级：中危）折叠  |  忽略  |  检测
检测类型：MySQL端口安全风险等级：中危
' b; t& g* k# t9 l! d* Q风险描述：当前MySQL端口: 3306，可被任意服务器访问，这可能导致MySQL被暴力破解，存在安全隐患
解决方案：1、若非必要，在【安全】页面将MySQL端口的放行删除
2、通过【系统防火墙】插件修改MySQL端口的放行为限定IP，以增强安全性
3、使用【Fail2ban防爆破】插件对MySQL服务进行保护
" v9 D8 ^7 X! D  }: ^3 \
# I5 x; @! w( g8 V, f这个？？

5 ~4 |& D! j6 e很少研究宝塔的使用，看来得多看看……
9 S8 B7 T. P; L
) B6 u& X; j0 j8 {) I

Toogle

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

河小马

error log 日志不全啊。。目前还是无法判断的
- r* r' z& Z) t" M$ w先重启mysql吧，然后时时观察一下mysql

老刘

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

Toogle

河小马 发表于 2021-11-9 17:00
: A) U. D$ P% A3 _! m- I; xerror log 日志不全啊。。目前还是无法判断的
先重启mysql吧，然后时时观察一下mysql
...

; l6 U6 I4 t3 r! N% M* X0 ?6 z( j- G好的，已经重启正常了……

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

2021-06-27 22:54:22 4646 [Note] /www/server/mysql/bin/mysqld: ready for connections.
: Q% q8 Y4 K5 J) {+ }- z: IVersion: '5.6.37-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
# b& ~  n% D1 m5 I: z7 x
: `! ~( q. z. h) v$ Z, N# ~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
, T5 ~: ^* q7 R6 u( X7 Y, z  F4 B2021-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
2 n$ v' l* Z& Z2021-11-02 22:59:29 14448 [Note] InnoDB: Memory barrier is not used
$ r# p) q3 V6 V' R$ C; ^; J6 ]: Y2021-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
- R' k4 E$ v2 \3 r! @0 l2021-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
0 g9 U" Z, l/ y8 p$ h2021-11-02 22:59:29 14448 [ERROR] Plugin 'InnoDB' init function returned error.
/ t8 a+ x5 O1 H2021-11-02 22:59:29 14448 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
, J& u( E& j5 m% Z& C1 h2021-11-02 22:59:29 14448 [ERROR] Unknown/unsupported storage engine: InnoDB
2021-11-02 22:59:29 14448 [ERROR] Aborting
+ t8 L0 N- w, s1 a9 v8 ~# o5 B
2021-11-02 22:59:29 14448 [Note] Binlog end
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'partition'
/ y$ g# s8 k% ]; _: k+ h- o2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
- b% a/ D4 Y5 v2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
. ^3 z5 ]7 e* ^  w2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
3 S  D+ c. u. ]6 d* e  {/ B2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
( I- d! E/ ?) a0 |8 u2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
1 `' L; N( M1 I; S3 e2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
+ E9 m  h3 a# }3 `2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
$ Z/ _8 p# q1 ^- w9 |( m( x( X2021-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'
5 `% I; `0 _. h/ E2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
! j4 x: c  \% z" u$ b, j2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
! w0 v, e" I8 a/ Z+ b2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
" b" C" I" ~( c% |" e2021-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'
8 Y9 Q/ p' @1 P- V! s1 D2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
9 x- M$ L5 V$ a$ }% B2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'INNODB_METRICS'
( {, L4 n# @( s' G. E& ^' W2021-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'
% y% e" \, j9 q( y2021-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'
$ S" p/ L, ~$ O- F# \1 o- N; L! i$ Z2021-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'
2 C& T* w* f9 v3 N9 i2021-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'
  K) h, J' B  Q1 |9 ^, [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'
& v  E7 K$ M( ^% r2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MyISAM'
/ P+ u2 f4 J: L) Q4 t* b# P1 J, S! o2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'MEMORY'
# d# V# ^, W$ u2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'CSV'
2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'sha256_password'
( Z; W2 K- N8 l4 P1 n2021-11-02 22:59:29 14448 [Note] Shutting down plugin 'mysql_old_password'
5 i- J% m( R( k2021-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
( p9 M, m8 U/ ]  P4 T8 v, g
% c, }( n# P% T. c2021-11-09 15:13:07 2834 [Note] Plugin 'FEDERATED' is disabled.

sead

1. df -hl

复制代码

/ j9 P  \! [9 g& s; p: ?先看看硬盘是不是满了

Toogle

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

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

ensky

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

Toogle

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

- i2 S" c' t1 s& g) j$ i% B) L1核
RAM 2GB
3 l0 X4 L4 e- `" B+ H3 T( b
在哪里改？
: n0 [$ b: L6 G; Z' A
: U3 i  |& _8 z% ~9 b$ t- R谢谢！~

ensky

Toogle 发表于 2021-11-10 15:38
# Y3 k4 S! V* l1核
RAM 2GB

看这个地方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

+ c7 {3 C$ w+ c! b% I: x; [看到了，之前我还回过帖子，只是忘记了……
& }- }" u' [' Z3 Q! M+ T) F8 n
& \0 \7 G: v3 |) k5 U# `0 s3 S5 `这就搞一下。
+ W1 ^. a; y6 t, }) s. V/ R2 R7 T/ T# ]( e
谢谢！

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
看了一下，没办法resize，重新建一个吗？如果是，旧的应该如何处理？
. g; B5 g# b3 I+ q  d谢谢！~

9 s* D: C+ t" W) O" I不能resize，这个我没有经验了，看看其余大佬有没有办法。