Processing of inserts in Mysql

Asked

Viewed 89 times

1

It is possible to know if Mysql inserts are being made after closing the connection?

The PHP code has 800 lines, I know it goes all the way, because the last instruction is successfully performed.

To follow open phpMyAdmin and acada F5 see the table cliente is being populated.

The total of insert that is sent is 500 thousand records.

  • 2

    Welcome to Stack overflow. The way your question is it provides few details and does not demonstrate research efforts. Start by doing a [tour] and read the guide [Ask]

  • until I searched more I found nothing.

  • The inserts that are sent to mysql via php are running.... when I open phpmyadmin I see that the database keep entering data sometimes gets 5 minutes inserting...

  • But it is procedure .... Voce sent a load and it keeps running, but I think to have a better answer it would be necessary to improve the question

1 answer

5

To list the process of a bank just access it and do the query below.

SHOW PROCESSLIST

The list of active processes will be displayed.

  • Using this command in two different hosting realized that there is a problem.... in the first does not inform these columns(Rows_sent , Rows_examined , Rows_read).... I imagine that it is this column that indicates the processing of SELECT or INSERT or DELET or UPDATE.

Browser other questions tagged

You are not signed in. Login or sign up in order to post.