MySql - Is there somehare request queue

Question

I used a loop in my php script to run insert requests in my db. The loop repeated a thousand times. I stop my PHP script until it works. However, my db table continues to populate all the time. I guess there should be a queue. but this is only an assumption. So I wonder if I can stop all pending requests? I also wonder if it is possible to see this line somewhere? Thank you in advance for your answers. Greetings. Mark.

Answer 1

There is no queue if you are not using INSERT DELAYED .

You can kill a process that inserts data as follows:

Run SHOW PROCESSLIST to find the identifier of the connection you want to kill

Then run KILL CONNECTION <thread_id> to kill this connection.

Answer 2

SHOW PROCESSLIST will provide you with a list of all current requests.