php - Mysql Show Process - Sleep Commands and what to do -
I am thinking that there is something that I can do better so that my process list should start with the command with MySQL Be clear Currently I am looking for a lot:
17325 user_a localhost db_1 sleep 1132 NULL
17464 user_a localhost db_1 sleep 1124 NULL
17983 user_a localhost db_1 sleep 1078 null
18113 user_a localhost db_1 sleep 1068 NULL
18207 user_a localhost db_1 sleep 1060 NULL
18231 user_a localhost db_1 sleep 1058 NULL
18353 user_a localhost db_1 sleep 1047 NULL
18447 user_a localhost db_1 sleep 1040 null
18489 user_a localhost db_1 sleep 1036 NULL
23408 user_a localhost db_1 sleep 637 NULL
Something in my phpscript is that I want to clean it Can i
The script looks like: Select the ID from $ q = 'db_1 where fkId = 2'; $ Ar = mysql_query ($ q); ($ Line = mysql_fetch_array ($ qr)) {echo ($ row ['id'];}
Thanks in advance!
I'm guessing that when you have 10 threads, you're constantly using the connection.
Do not want to disable.
Comments
Post a Comment