S
S
Skrolea2016-07-04 23:37:45
linux
Skrolea, 2016-07-04 23:37:45

MySql is not working. How to fix?

Good afternoon. In addition to my previous question How to start mysqld?
Starting mysql does not work (standardly swears at the lack of a socket). The mysqld service was successfully started after shamanism with innodb_force....

[[email protected] mysql]# service mysqld restart
Останавливается mysqld:                                    [  OK  ]
Запускается mysqld:                                        [  OK  ]

There is disk space.
log issues after restart mysqld
c8a6466f95164db1b3b07d1b3ff637a0.pngps -AlF | grep mysql
issues
4 S root      47011      1  0  80   0 - 27087 wait    1504   4 21:57 ?        00                            :00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/m                            ysql/mysqld.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mys                            ql
4 S mysql     47773  47011  0  80   0 - 2220083 poll_s 619652 3 21:57 ?       00                            :00:04 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=                            /usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/web.local.err --                            pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysqld.sock --port=3                            306
0 S root      62085  59764  0  80   0 - 25836 pipe_w   900   2 23:12 pts/0    00                            :00:00 grep mysql

Answer the question

In order to leave comments, you need to log in

[[+comments_count]] answer(s)
A
Azazel PW, 2016-07-05
@azazelpw

innodb_force is not an option to work with, just to get some data you need.
Are there backups? If not, try to restore indexes and tables.
netstat -tnlp is there a working port?
mysql -uroot -pPASSWORD enters the database?

S
Skrolea, 2016-07-05
@Skrolea

Something new came out in the logs. f82a1d7322ef4a988489dc2bf5df3cb9.png
[email protected]
There is Bitrix. Probably from him

I
Igor Maksimov, 2016-07-14
@Chunk

Read logs. And based on them draw conclusions.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question