mysql 进程被kill掉,无法启动了,应该怎么办?

发布网友发布时间：2022-04-07 16:29

共3个回答

懂视网时间：2022-04-07 20:51

RECORD LOCKS space id 122 page no 3 n bits 80 index `PRIMARY` of table `test`.`t` trx id 307463 lock_mode X

RECORD LOCKS space id 122 page no 4 n bits 80 index `idx_name` of table `test`.`t` trx id 307463 lock_mode X

RECORD LOCKS space id 122 page no 4 n bits 80 index `idx_name` of table `test`.`t` trx id 307463 lock_mode X locks gap before rec

mysql> show processlist;

+------+------+---------------------+------+-------------+-------+-----------------------------------------------------------------------+------------------+-----------+---------------+

+------+------+---------------------+------+-------------+-------+-----------------------------------------------------------------------+------------------+-----------+---------------+

| 4256 | root | localhost | test | Sleep | 72573 | | NULL | 7 | 7 |

| 4375 | repl | 172.16.52.131:49285 | NULL | Binlog Dump | 75947 | Master has sent all binlog to slave; waiting for binlog to be updated | NULL | 0 | 0 |

| 5294 | root | localhost | test | Sleep | 72553 | | NULL | 0 | 0 |

| 9289 | root | localhost | NULL | Sleep | 40 | | NULL | 0 | 0 |

+------+------+---------------------+------+-------------+-------+-----------------------------------------------------------------------+------------------+-----------+---------------+

5 rows in set (0.00 sec)

mysql> select * from t;

+----+----------+------+

| i | name | age |

+----+----------+------+

| 1 | zhangsna | 20 |

| 2 | zhangsna | 20 |

| 3 | c | 23 |

| 4 | c | 23 |

| 5 | e | NULL |

| 6 | f | NULL |

| 19 | xiaoming | 23 |

+----+----------+------+

7 rows in set (0.00 sec)

判断：

通过innodb status发现对t表上了表锁：TABLE LOCK table `test`.`t` trx id 307463 lock mode IX
通过select * from t发现该表有7行：7 rows in set (0.00 sec)
通过show processlist发现有一个会话的Rows_sent | Rows_examined为7 7 ，ID为4526

通过判断kill掉id为4526会话：

mysql> kill 4256;

Query OK, 0 rows affected (0.00 sec)

在执行delete操作，顺利执行：

mysql> delete from t;

Query OK, 7 rows affected (0.01 sec)

本文出自 “浮生凤年” 博客，请务必保留此出处http://liuzhanbin.blog.51cto.com/10060150/1647320

MySQL锁检测-kill

标签：锁

热心网友时间：2022-04-07 17:59

1、可能是kill导致socket=/var/lib/mysql/mysql.sock 这个文件还存在，启动时无权写，删除再启
2、看log-error=/var/log/mysqld.log启动日志,分析原因.

热心网友时间：2022-04-07 19:17

怎么会无法启动呢？表示不理解