Shulou(Shulou.com)06/01 Report--

I don't know if you have any knowledge about how to solve the problem of alter sentence jam in mysql before. Today, I'm here to talk about it briefly. If you are interested, let's take a look at the body. I believe you will gain something after reading how to solve the problem of alter sentence stuck in mysql.

Solution: kill all processes that are using this table library (the table you want to modify in this article is the table in the xy library). It may be a process that gets stuck.

Wrote a script to solve:

#! / bin/sh

MYSQLADMIN= "/ usr/local/mysql3306/bin/mysqladmin"

For i in `$ MYSQLADMIN processlist-uroot-p1234 | grep-I sleep | grep 'xy' | awk' {print $2}'`

Do

$MYSQLADMIN-uroot-p1234 kill $I

Done

After executing the above script, it will be fine.

After reading this article, what do you think of how to solve the problem of getting stuck in alter sentences in mysql? If you want to know more about it, you can continue to follow our industry information section.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.