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

Check connection issue of mysql

# show connection configuration

Show variables like'% max_connection%'

# Change the limitation of max_connection temporarily

Set global max_connections=600

# check current status

Status

# check how many processes running

Show processlist

# Kill the locked connections

For id in `mysqladmin processlist | grep-I locked | awk'{print $1}'`

Do

Mysqladmin kill ${id}

Done

# Run killing sql

Source kill_thread_id.sql

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.