【待反馈】数据库又自动停止了，启动不了

第三次出现这样的问题了自动停止，启动不了，删除了重装报错

360截图20240612192045604.jpg

运维技术阿闯 · 发表于 2024-6-13 10:22:10

您好，您在您ssh终端执行free -m查看剩余内存是多少，根据您提示信息来看，剩余空间不足128m导致无法安装

fkenuiabcd · 发表于 2024-6-13 12:31:00

运维技术阿闯发表于 2024-6-13 10:22
您好，您在您ssh终端执行free -m查看剩余内存是多少，根据您提示信息来看，剩余空间不足128m导致无法安装 ...

            total       used       free    shared    buff/cache available
Mem:          3789       695       306       255       2787       2547
Swap:       4095          0       4095

fkenuiabcd · 发表于 2024-6-13 14:32:53

本帖最后由 fkenuiabcd 于 2024-6-13 14:45 编辑

运维技术阿闯发表于 2024-6-13 10:22
您好，您在您ssh终端执行free -m查看剩余内存是多少，根据您提示信息来看，剩余空间不足128m导致无法安装 ...

是因为可用内存太少了，内存信息，可用才102了，清理了就可以安装了，过一会可用内存又变的很少。又要清理，这是为什么。

慢日志有太多出现下面这样的

/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306  Unix socket: /tmp/mysql.sock
Time                Id Command Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306  Unix socket: /tmp/mysql.sock
Time                Id Command Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306  Unix socket: /tmp/mysql.sock
Time                Id Command Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306  Unix socket: /tmp/mysql.sock
Time                Id Command Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306  Unix socket: /tmp/mysql.sock
Time                Id Command Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306  Unix socket: /tmp/mysql.sock
Time                Id Command Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306  Unix socket: /tmp/mysql.sock
Time                Id Command Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306  Unix socket: /tmp/mysql.sock
Time                Id Command Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306  Unix socket: /tmp/mysql.sock
Time                Id Command Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306  Unix socket: /tmp/mysql.sock
Time                Id Command Argument
/www/server/mysql/bin/mysqld, Version: 5.7.44-log (Source distribution). started with:
Tcp port: 3306  Unix socket: /tmp/mysql.sock
Time                Id Command Argument

运维技术阿闯 · 发表于 2024-6-13 16:07:24

fkenuiabcd 发表于 2024-6-13 14:32
是因为可用内存太少了，内存信息，可用才102了，清理了就可以安装了，过一会可用内存又变的很少。又要清理 ...

您好，确保没有尝试启动多个MySQL实例。可以使用ps命令或systemctl（如果你使用的是systemd）来检查正在运行的MySQL进程。

如果没有的话需要检查日志信息了

fkenuiabcd · 发表于 2024-6-13 17:07:30

运维技术阿闯发表于 2024-6-13 16:07
您好，确保没有尝试启动多个MySQL实例。可以使用ps命令或systemctl（如果你使用的是systemd）来检查正在 ...

[root@localhost ~]# systemctl
UNIT                                                          LOAD ACTIVE SUB    DESCRIPTION
proc-sys-fs-binfmt_misc.automount                            loaded active waiting Arbitrary Executable File Formats File System Automount Point
sys-devices-pci0000:00-0000:00:01.1-ata1-host0-target0:0:0-0:0:0:0-block-sr0.device loaded active plugged QEMU_DVD-ROM
sys-devices-pci0000:00-0000:00:03.0-virtio0-net-eth0.device loaded active plugged Virtio network device
sys-devices-pci0000:00-0000:00:04.0-virtio1-net-eth1.device loaded active plugged Virtio network device
sys-devices-pci0000:00-0000:00:05.0-virtio2-block-vda-vda1.device loaded active plugged /sys/devices/pci0000:00/0000:00:05.0/virtio2/block/vda/vda1
sys-devices-pci0000:00-0000:00:05.0-virtio2-block-vda.device loaded active plugged /sys/devices/pci0000:00/0000:00:05.0/virtio2/block/vda
sys-devices-pci0000:00-0000:00:08.0-virtio4-block-vdb-vdb1.device loaded active plugged /sys/devices/pci0000:00/0000:00:08.0/virtio4/block/vdb/vdb1
sys-devices-pci0000:00-0000:00:08.0-virtio4-block-vdb.device loaded active plugged /sys/devices/pci0000:00/0000:00:08.0/virtio4/block/vdb
sys-devices-platform-serial8250-tty-ttyS1.device             loaded active plugged /sys/devices/platform/serial8250/tty/ttyS1
sys-devices-platform-serial8250-tty-ttyS2.device             loaded active plugged /sys/devices/platform/serial8250/tty/ttyS2
sys-devices-platform-serial8250-tty-ttyS3.device             loaded active plugged /sys/devices/platform/serial8250/tty/ttyS3
sys-devices-pnp0-00:04-tty-ttyS0.device                      loaded active plugged /sys/devices/pnp0/00:04/tty/ttyS0
sys-module-configfs.device                                  loaded active plugged /sys/module/configfs
sys-subsystem-net-devices-eth0.device                         loaded active plugged Virtio network device
sys-subsystem-net-devices-eth1.device                         loaded active plugged Virtio network device
-.mount                                                       loaded active mounted /
dev-hugepages.mount                                           loaded active mounted Huge Pages File System
dev-mqueue.mount                                              loaded active mounted POSIX Message Queue File System
run-user-0.mount                                              loaded active mounted /run/user/0
run-user-1003.mount                                           loaded active mounted /run/user/1003
sys-kernel-config.mount                                     loaded active mounted Configuration File System
sys-kernel-debug.mount                                        loaded active mounted Debug File System
www.mount                                                    loaded active mounted /www
systemd-ask-password-plymouth.path                            loaded active waiting Forward Password Requests to Plymouth Directory Watch
systemd-ask-password-wall.path                               loaded active waiting Forward Password Requests to Wall Directory Watch
session-267.scope                                           loaded active abandoned Session 267 of user root
session-293.scope                                           loaded active running Session 293 of user root
session-c1.scope                                              loaded active abandoned Session c1 of user redis
auditd.service                                              loaded active running Security Auditing Service
bt.service                                                    loaded active running LSB: starts bt
chronyd.service                                              loaded active running NTP client/server
crond.service                                                 loaded active running Command Scheduler
dbus.service                                                 loaded active running D-Bus System Message Bus
lines 1-34...skipping...
UNIT                                                          LOAD ACTIVE SUB    DESCRIPTION
proc-sys-fs-binfmt_misc.automount                            loaded active waiting Arbitrary Executable File Formats File System Automount Point
sys-devices-pci0000:00-0000:00:01.1-ata1-host0-target0:0:0-0:0:0:0-block-sr0.device loaded active plugged QEMU_DVD-ROM
sys-devices-pci0000:00-0000:00:03.0-virtio0-net-eth0.device loaded active plugged Virtio network device
sys-devices-pci0000:00-0000:00:04.0-virtio1-net-eth1.device loaded active plugged Virtio network device
sys-devices-pci0000:00-0000:00:05.0-virtio2-block-vda-vda1.device loaded active plugged /sys/devices/pci0000:00/0000:00:05.0/virtio2/block/vda/vda1
sys-devices-pci0000:00-0000:00:05.0-virtio2-block-vda.device loaded active plugged /sys/devices/pci0000:00/0000:00:05.0/virtio2/block/vda
sys-devices-pci0000:00-0000:00:08.0-virtio4-block-vdb-vdb1.device loaded active plugged /sys/devices/pci0000:00/0000:00:08.0/virtio4/block/vdb/vdb1
sys-devices-pci0000:00-0000:00:08.0-virtio4-block-vdb.device loaded active plugged /sys/devices/pci0000:00/0000:00:08.0/virtio4/block/vdb
sys-devices-platform-serial8250-tty-ttyS1.device             loaded active plugged /sys/devices/platform/serial8250/tty/ttyS1
sys-devices-platform-serial8250-tty-ttyS2.device             loaded active plugged /sys/devices/platform/serial8250/tty/ttyS2
sys-devices-platform-serial8250-tty-ttyS3.device             loaded active plugged /sys/devices/platform/serial8250/tty/ttyS3
sys-devices-pnp0-00:04-tty-ttyS0.device                      loaded active plugged /sys/devices/pnp0/00:04/tty/ttyS0
sys-module-configfs.device                                  loaded active plugged /sys/module/configfs
sys-subsystem-net-devices-eth0.device                         loaded active plugged Virtio network device
sys-subsystem-net-devices-eth1.device                         loaded active plugged Virtio network device
-.mount                                                       loaded active mounted /
dev-hugepages.mount                                           loaded active mounted Huge Pages File System
dev-mqueue.mount                                              loaded active mounted POSIX Message Queue File System
run-user-0.mount                                              loaded active mounted /run/user/0
run-user-1003.mount                                           loaded active mounted /run/user/1003
sys-kernel-config.mount                                     loaded active mounted Configuration File System
sys-kernel-debug.mount                                        loaded active mounted Debug File System
www.mount                                                    loaded active mounted /www
systemd-ask-password-plymouth.path                            loaded active waiting Forward Password Requests to Plymouth Directory Watch
systemd-ask-password-wall.path                               loaded active waiting Forward Password Requests to Wall Directory Watch
session-267.scope                                           loaded active abandoned Session 267 of user root
session-293.scope                                           loaded active running Session 293 of user root
session-c1.scope                                              loaded active abandoned Session c1 of user redis
auditd.service                                              loaded active running Security Auditing Service
bt.service                                                    loaded active running LSB: starts bt
chronyd.service                                              loaded active running NTP client/server
crond.service                                                 loaded active running Command Scheduler
dbus.service                                                 loaded active running D-Bus System Message Bus
firewalld.service                                           loaded active running firewalld - dynamic firewall daemon
getty@tty1.service                                           loaded active running Getty on tty1
irqbalance.service                                           loaded active running irqbalance daemon
kdump.service                                                 loaded active exited Crash recovery kernel arming
kmod-static-nodes.service                                     loaded active exited Create list of required static device nodes for the current ker
kuaiyun.service                                              loaded active running KuaiYunTools
network.service                                              loaded active exited LSB: Bring up/down networking
nginx.service                                                 loaded active running LSB: starts the nginx web server
oneavd.service                                              loaded active running ONEAV DAEMON
php-fpm-70.service                                           loaded active running LSB: starts php-fpm
polkit.service                                              loaded active running Authorization Manager
postfix.service                                              loaded active running Postfix Mail Transport Agent
pure-ftpd.service                                           loaded active exited LSB: starts pureftpd server
redis.service                                                 loaded active exited LSB: starts Redis
rhel-dmesg.service                                           loaded active exited Dump dmesg to /var/log/dmesg
rhel-domainname.service                                     loaded active exited Read and set NIS domainname from /etc/sysconfig/network
rhel-import-state.service                                     loaded active exited Import network configuration from initramfs

运维技术阿闯 · 发表于 2024-6-13 17:19:01

fkenuiabcd 发表于 2024-6-13 17:07
[root@localhost ~]# systemctl
UNIT LOAD ...

不好意思，刚才回答有误，您检查一下磁盘是否充足，df -Th，信息是磁盘空间不足

fkenuiabcd · 发表于 2024-6-14 09:07:34

运维技术阿闯发表于 2024-6-13 17:19
不好意思，刚才回答有误，您检查一下磁盘是否充足，df -Th，信息是磁盘空间不足 ...

Welcome to  KUAIYUN Vps!
[root@localhost ~]# df -Th
Filesystem    Type    Size  Used Avail Use% Mounted on
/dev/vda1    xfs       40G  5.6G 35G  14% /
devtmpfs    devtmpfs  1.9G    0  1.9G 0% /dev
tmpfs       tmpfs    1.9G 16K  1.9G 1% /dev/shm
tmpfs       tmpfs    1.9G  185M  1.7G  10% /run
tmpfs       tmpfs    1.9G    0  1.9G 0% /sys/fs/cgroup
/dev/vdb1    ext4    99G 90G  4.1G  96% /www
tmpfs       tmpfs    379M    0  379M 0% /run/user/1003
tmpfs       tmpfs    379M    0  379M 0% /run/user/0
[root@localhost ~]# ^C

运维技术阿闯 · 发表于 2024-6-14 12:12:18

fkenuiabcd 发表于 2024-6-14 09:07
Welcome to KUAIYUN Vps!
[root@localhost ~]# df -Th
Filesystem Type Size Used Avail Use% ...

您好，/www目录空间不足导致的

fkenuiabcd · 发表于 2024-6-14 14:19:10

运维技术阿闯发表于 2024-6-14 12:12
您好，/www目录空间不足导致的

好的，我删除了一部份了，现在WWW目录空间有7G空间了

运维技术阿闯 · 发表于 2024-6-14 16:07:31

fkenuiabcd 发表于 2024-6-14 14:19
好的，我删除了一部份了，现在WWW目录空间有7G空间了

好的，后续在看一下是否停止的时候使用df -Th看一下磁盘空间以及free -m内存空间

fkenuiabcd · 发表于 2024-6-14 17:05:04

运维技术阿闯发表于 2024-6-14 16:07
好的，后续在看一下是否停止的时候使用df -Th看一下磁盘空间以及free -m内存空间 ...

好的，我在看看

运维技术阿闯 · 发表于 2024-6-14 17:20:09

fkenuiabcd 发表于 2024-6-14 17:05
好的，我在看看

好的，后续有情况可以在发一下呢

█ 菠萝云-主机特惠16G内存100元 █	【阿里云】低至5折	APP分发-无行业限制免审核	16核16G高防189元	【多途云】高防CDN
高防服务器，无视一切流量攻击	【恒爱云】香港2核1G 3M 15元/起	香港站群金牌Gold 6138大促销	【阿里云】宝塔一键部署，低至5折	OV/EV SSL证书，可当日签发
█ 易探云·香港/美国vps仅9元 █	CDN无视各类攻击\|无效退款	OV/EV SSL证书，可当日签发	【云防护】专注域名和网站安全防护	AWS CDN 4分，多家公有云代理