Панель управления сервером
https://www.community.brainycp.ru/
Код: Выделить всё
free -h
df
cat /etc/os-release
systemctl status mysqld -lКод: Выделить всё
systemctl status mysqld -lКод: Выделить всё
[root@akttservice ~]# free -h
total used free shared buff/cache available
Mem: 31G 1.9G 28G 169M 1.2G 28G
Swap: 15G 0B 15G
Код: Выделить всё
[root@akttservice ~]# df
Filesystem 1K-blocks Used Available Use% Mounted on
devtmpfs 16335868 0 16335868 0% /dev
tmpfs 16350468 0 16350468 0% /dev/shm
tmpfs 16350468 17500 16332968 1% /run
tmpfs 16350468 0 16350468 0% /sys/fs/cgroup
/dev/mapper/centos-root 52403200 12942228 39460972 25% /
/dev/sda1 1038336 247272 791064 24% /boot
/dev/mapper/centos-home 978097540 66381288 911716252 7% /home
tmpfs 3270096 0 3270096 0% /run/user/0
Код: Выделить всё
[root@akttservice ~]# cat /etc/os-release
NAME="CentOS Linux"
VERSION="7 (Core)"
ID="centos"
ID_LIKE="rhel fedora"
VERSION_ID="7"
PRETTY_NAME="CentOS Linux 7 (Core)"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:centos:centos:7"
HOME_URL="https://www.centos.org/"
BUG_REPORT_URL="https://bugs.centos.org/"
CENTOS_MANTISBT_PROJECT="CentOS-7"
CENTOS_MANTISBT_PROJECT_VERSION="7"
REDHAT_SUPPORT_PRODUCT="centos"
REDHAT_SUPPORT_PRODUCT_VERSION="7"
Код: Выделить всё
systemctl status mysqld -l
● mysqld.service - MySQL 5.7 database server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled; vendor preset: disabled)
Active: active (running) since Thu 2023-09-14 14:47:13 MSK; 4h 51min ago
Process: 11215 ExecStopPost=/usr/libexec/mysql-wait-stop (code=exited, status=0/SUCCESS)
Process: 13625 ExecStartPost=/usr/libexec/mysql-check-upgrade (code=exited, status=0/SUCCESS)
Process: 13599 ExecStart=/usr/libexec/mysqld --daemonize --basedir=/usr --pid-file=/var/run/mysqld/m ysqld.pid (code=exited, status=0/SUCCESS)
Process: 13565 ExecStartPre=/usr/libexec/mysql-prepare-db-dir %n (code=exited, status=0/SUCCESS)
Process: 13542 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS)
Main PID: 13602 (mysqld)
Tasks: 32
Memory: 458.5M
CGroup: /system.slice/mysqld.service
└─13602 /usr/libexec/mysqld --daemonize --basedir=/usr --pid-file=/var/run/mysqld/mysqld.pi d
Sep 14 14:47:13 akttservice.ru mysqld[13599]: 2023-09-14T11:47:13.300080Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`server_cost` in the cache. Attempting to load the tablespace with s pace id 33
Sep 14 14:47:13 akttservice.ru mysqld[13599]: 2023-09-14T11:47:13.318087Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`engine_cost` in the cache. Attempting to load the tablespace with s pace id 24
Sep 14 14:47:13 akttservice.ru mysqld[13599]: 2023-09-14T11:47:13.395700Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`time_zone_leap_second` in the cache. Attempting to load the tablesp ace with space id 52
Sep 14 14:47:13 akttservice.ru mysqld[13599]: 2023-09-14T11:47:13.396999Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`time_zone_name` in the cache. Attempting to load the tablespace wit h space id 53
Sep 14 14:47:13 akttservice.ru mysqld[13599]: 2023-09-14T11:47:13.403008Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`time_zone` in the cache. Attempting to load the tablespace with spa ce id 51
Sep 14 14:47:13 akttservice.ru mysqld[13599]: 2023-09-14T11:47:13.416552Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`time_zone_transition_type` in the cache. Attempting to load the tab lespace with space id 55
Sep 14 14:47:13 akttservice.ru mysqld[13599]: 2023-09-14T11:47:13.429043Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`time_zone_transition` in the cache. Attempting to load the tablespa ce with space id 54
Sep 14 14:47:13 akttservice.ru mysqld[13599]: 2023-09-14T11:47:13.489427Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`servers` in the cache. Attempting to load the tablespace with space id 50
Sep 14 14:47:13 akttservice.ru mysqld[13599]: 2023-09-14T11:47:13.551125Z 0 [ERROR] Incorrect definiti on of table mysql.db: expected column 'User' at position 2 to have type char(32), found type char(16).
Sep 14 14:47:13 akttservice.ru systemd[1]: Started MySQL 5.7 database server.
Код: Выделить всё
mysqlcheck --no-defaults -u root -p --all-databases --socket=/var/run/mysqld/mysql.sock
Код: Выделить всё
[root@akttservice ~]# systemctl status mysqld -l
● mysqld.service - MySQL 5.7 database server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled; vendor preset: disabled)
Active: failed (Result: start-limit) since Fri 2023-09-15 15:07:39 MSK; 51s ago
Process: 49310 ExecStopPost=/usr/libexec/mysql-wait-stop (code=exited, status=0/SUCCESS)
Process: 49291 ExecStart=/usr/libexec/mysqld --daemonize --basedir=/usr --pid-file=/var/run/mysqld/mysqld.pid (code=exited, status=1/FAILURE)
Process: 49257 ExecStartPre=/usr/libexec/mysql-prepare-db-dir %n (code=exited, status=0/SUCCESS)
Process: 49234 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS)
Sep 15 15:07:39 akttservice.ru systemd[1]: Failed to start MySQL 5.7 database server.
Sep 15 15:07:39 akttservice.ru systemd[1]: Unit mysqld.service entered failed state.
Sep 15 15:07:39 akttservice.ru systemd[1]: mysqld.service failed.
Sep 15 15:07:39 akttservice.ru systemd[1]: mysqld.service holdoff time over, scheduling restart.
Sep 15 15:07:39 akttservice.ru systemd[1]: Stopped MySQL 5.7 database server.
Sep 15 15:07:39 akttservice.ru systemd[1]: start request repeated too quickly for mysqld.service
Sep 15 15:07:39 akttservice.ru systemd[1]: Failed to start MySQL 5.7 database server.
Sep 15 15:07:39 akttservice.ru systemd[1]: Unit mysqld.service entered failed state.
Sep 15 15:07:39 akttservice.ru systemd[1]: mysqld.service failed.