1、查看所有连接状态
show processlist;
输出结果:
+----+------+-----------------+-------+---------+------+----------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+------+-----------------+-------+---------+------+----------+------------------+ |9| root |localhost:49386| NULL | Sleep | 37 || NULL || 10 | root | localhost:49391 | test | Sleep |22| | NULL | |11| root |localhost:49396| test | Sleep | 31 || NULL || 12 | root | localhost:49401 | sonar | Sleep |28| | NULL | |13| root |localhost:49414| test | Sleep | 21 || NULL || 14 | root | localhost:49432 | test | Query |0| starting | show processlist | +----+------+-----------------+-------+---------+------+----------+------------------+
2、断开连接
kill 12; -- 12为连接的id
3、 连接线程的command
开启:修改my.ini中的以下配置
slow_query_log=ON
long_query_time=0.1
log_queries_not_using_index=ON