покажите
sudo dpkg -l mysql-server
root@
не надо под рутом сидеть
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name Version Architecture Description
+++-==============-============-============-=================================
un mysql-server <none> <none> (no description available)
Пользователь добавил сообщение 18 Июня 2020, 14:27:45:
noob_zabbix,
grep mysql /var/log/syslog
введя эту команду появилась ну очень много текста!!
вот малая его часть, последние события
Jun 18 14:21:21 OPENFIRE mysql[432]: Starting MariaDB database server: mysqld . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . failed!
Jun 18 14:21:21 OPENFIRE systemd[1]: mysql.service: control process exited, code=exited status=1
Jun 18 14:21:21 OPENFIRE systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.
Jun 18 14:21:21 OPENFIRE systemd[1]: Unit mysql.service entered failed state.
Jun 18 14:23:56 OPENFIRE systemd[1]: Starting LSB: Start and stop the mysql database server daemon...
Jun 18 14:23:56 OPENFIRE mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Jun 18 14:23:56 OPENFIRE mysqld: 200618 14:23:56 [Note] /usr/sbin/mysqld (mysqld 10.0.38-MariaDB-0+deb8u1) starting as process 1576 ...
Jun 18 14:23:56 OPENFIRE mysqld: 200618 14:23:56 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
Jun 18 14:23:56 OPENFIRE mysqld:
Jun 18 14:23:56 OPENFIRE mysqld: 200618 14:23:56 [Note] InnoDB: Using mutexes to ref count buffer pool pages
Jun 18 14:23:56 OPENFIRE mysqld: 200618 14:23:56 [Note] InnoDB: The InnoDB memory heap is disabled
Jun 18 14:23:56 OPENFIRE mysqld: 200618 14:23:56 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Jun 18 14:23:56 OPENFIRE mysqld: 200618 14:23:56 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
Jun 18 14:23:56 OPENFIRE mysqld: 200618 14:23:56 [Note] InnoDB: Compressed tables use zlib 1.2.8
Jun 18 14:23:56 OPENFIRE mysqld: 200618 14:23:56 [Note] InnoDB: Using Linux native AIO
Jun 18 14:23:56 OPENFIRE mysqld: 200618 14:23:56 [Note] InnoDB: Using CPU crc32 instructions
Jun 18 14:23:56 OPENFIRE mysqld: 200618 14:23:56 [Note] InnoDB: Initializing buffer pool, size = 128.0M
Jun 18 14:23:56 OPENFIRE mysqld: 200618 14:23:56 [Note] InnoDB: Completed initialization of buffer pool
Jun 18 14:23:56 OPENFIRE mysqld: 200618 14:23:56 [Note] InnoDB: Highest supported file format is Barracuda.
Jun 18 14:23:56 OPENFIRE mysqld: 200618 14:23:56 [Note] InnoDB: Starting crash recovery from checkpoint LSN=4317141368692
Jun 18 14:23:56 OPENFIRE mysqld: 200618 14:23:56 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
Jun 18 14:24:02 OPENFIRE mysqld: 200618 14:24:02 [ERROR] InnoDB: Tried to read 16384 bytes at offset 74710122496. Was only able to read 4096.
Jun 18 14:24:02 OPENFIRE mysqld: 2020-06-18 14:24:02 7f140971c780 InnoDB: Operating system error number 5 in a file operation.
Jun 18 14:24:02 OPENFIRE mysqld: InnoDB: Error number 5 means 'Input/output error'.
Jun 18 14:24:02 OPENFIRE mysqld: InnoDB: Some operating system error numbers are described at
Jun 18 14:24:02 OPENFIRE mysqld: InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
Jun 18 14:24:02 OPENFIRE mysqld: 200618 14:24:02 [ERROR] InnoDB: File (unknown): 'read' returned OS error 105. Cannot continue operation
Jun 18 14:24:03 OPENFIRE mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Jun 18 14:24:26 OPENFIRE /etc/init.d/mysql[1872]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jun 18 14:24:26 OPENFIRE /etc/init.d/mysql[1872]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Jun 18 14:24:26 OPENFIRE /etc/init.d/mysql[1872]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111 "Connection refused")'
Jun 18 14:24:26 OPENFIRE /etc/init.d/mysql[1872]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jun 18 14:24:26 OPENFIRE /etc/init.d/mysql[1872]:
Jun 18 14:24:26 OPENFIRE mysql[1399]: Starting MariaDB database server: mysqld . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . failed!
Jun 18 14:24:26 OPENFIRE systemd[1]: mysql.service: control process exited, code=exited status=1
Jun 18 14:24:26 OPENFIRE systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.
Jun 18 14:24:26 OPENFIRE systemd[1]: Unit mysql.service entered failed state.