Hundreds of "array" queries

[2005]

When I look at MySQL process list in PHP MyAdmin from time to time I see hundreds of "Array" SQL Queries and with status "locked". What is it?

[superwormy]

Array queries? You mean queries that look like this:

SELECT * FROM table WHERE some_field = 'Array'

??? That looks like a bad query to me... like someone accidentally trying concatenating an array to a string in PHP, then using it in a query...

You can look up query status's in the MySQL manual.

[2005]

superwormy, I don't know what is it - array queries or what... As I wrote it happends from time to time, When I look at process list in PhPMyAdmin it loks like this (hundreds of records like this):

 Kill    6687560   	 database3   	 mydomain.com:35493   	 database3   	 Query   	 1   	 Locked   	 Array 
 Kill  	 6687562  	 database3  	 mydomain.com:35495  	 database3  	 Sleep  	 1  	 ---  	 --- 
 Kill  	 6687563  	 database3  	 mydomain.com:35496  	 database3  	 Query  	 1  	 Locked  	 Array 
 Kill  	 6687565  	 database3  	 mydomain.com:35498  	 database3  	 Query  	 1  	 Locked  	 Array 
 Kill  	 6687566  	 database3  	 mydomain.com:35499  	 database3  	 Query  	 2  	 preparing  	 Array 
 Kill  	 6687567  	 database3  	 mydomain.com:35500  	 database3  	 Query  	 1  	 Locked  	 Array 
 Kill  	 6687568  	 database3  	 mydomain.com:35501  	 database3  	 Query  	 1  	 Locked  	 Array 
 Kill  	 6687569  	 database3  	 mydomain.com:35502  	 database3  	 Query  	 1  	 Locked  	 Array 
 Kill  	 6687570  	 database3  	 mydomain.com:35503  	 database3  	 Query  	 1  	 Locked  	 Array 
 Kill  	 6687571  	 database3  	 mydomain.com:35505  	 database3  	 Query  	 1  	 Locked  	 Array 
 Kill  	 6687572  	 database3  	 mydomain.com:35506  	 database3  	 Query  	 1  	 Locked  	 Array 
 Kill  	 6687573  	 database3  	 mydomain.com:35507  	 database3  	 Query  	 1  	 Locked  	 Array 
 Kill  	 6687574  	 database3  	 mydomain.com:35508  	 database3  	 Query  	 1  	 Updating  	 Array 
 Kill  	 6687575  	 database3  	 mydomain.com:35509  	 database3  	 Query  	 1  	 Locked  	 Array 
 Kill  	 6687576  	 database3  	 mydomain.com:35510  	 database3  	 Query  	 1  	 Locked  	 Array 
 Kill  	 6687577  	 database3  	 mydomain.com:35511  	 database3  	 Query  	 1  	 Locked  	 Array 
 Kill  	 6687578  	 database3  	 localhost  	 None  	 Query  	 0  	 ---  	 Array 

I just want to find out if it's normal or not.