mysql 显示队列_MySql-是否有查询队列

最新推荐文章于 2023-01-12 10:45:42 发布

weixin_39681486

最新推荐文章于 2023-01-12 10:45:42 发布

阅读量290

点赞数

文章标签： mysql 显示队列

本文链接：https://blog.csdn.net/weixin_39681486/article/details/113212073

版权

I used a loop in my php script to run insert queries into my db. The loop was looping thousand times. I stop my php script while it was till running. Nevertheless, my db table keeps on getting populated continously. I guess that there must be a queue. but this is only a guess. So I am wondering if I can stop all the pending queries from being executed? Also I am wondering if it is possible to see that queue somewhere? Thank you in advance for your replies. Cheers. Marc.

解决方案

There is no queue, unless you were using INSERT DELAYED.

You can kill the process that is inserting the data like this:

Run SHOW PROCESSLIST to find the id of the connecton you want to kill

Then run KILL CONNECTION to kill that connection.