With my current instalation of 6.4 I seem to have a lot of locked tables. Processor usage is never too bad, but here is an example:
Code
  
+---------+------+----------------+------------------------------------------------------------------------------------------------------+    
| Command | Time | State          | Info                                                                                                 |    
+---------+------+----------------+------------------------------------------------------------------------------------------------------+    
| Sleep   | 384  |                |                                                                                                      |    
| Sleep   | 327  |                |                                                                                                      |    
| Query   | 10   | Sorting result | SELECT t1.B_Number,t1.B_Main,t3.U_Username,t1.B_Subject,t1.B_Posted,t1.B_Board,t3.U_Color,t1.B_Reged |    
| Query   | 7    | Locked         | UPDATE w3t_Posts                                                                                          
				         SET    B_Counter = B_Counter + 1                                                                     
				         WHERE  B_Number = 672808         |                                                                   
| Query   | 6    | Locked         | SELECT t1.B_Number,t1.B_Parent,t2.U_Username,t1.B_Posted,t1.B_Last_Post,t1.B_Subject,t1.B_Main,t1.B_ |    
| Query   | 6    | Locked         | SELECT B_Main,B_Board                                                                                     
				      FROM   w3t_Posts                                                                                        
				      WHERE  B_Number = 674709                          |                                                     
| Query   | 6    | Locked         | SELECT B_Main,B_Board                                                                                     
				      FROM   w3t_Posts                                                                                        
				      WHERE  B_Number = 358032                          |                                                     
| Query   | 5    | Locked         | SELECT t1.Bo_Title,t1.Bo_Description,t1.Bo_Keyword,t1.Bo_Total,t1.Bo_Last,t1.Bo_Number,t1.Bo_Moderat |    
| Query   | 5    | Locked         | SELECT B_Main,B_Board                                                                                     
				      FROM   w3t_Posts                                                                                        
				      WHERE  B_Number = 663570                          |                                                     
| Query   | 5    | Locked         | SELECT B_Main,B_Board                                                                                     
				      FROM   w3t_Posts                                                                                        
				      WHERE  B_Number = 120186                          |                                                     
| Query   | 5    | Locked         | SELECT B_Main, B_Last_Post,B_Subject,B_Rating,B_Rates,B_RealRating,B_Board                                
				      FROM   w3t_Posts                                                                                        
				   |                                                                                                          
| Query   | 3    | Locked         | SELECT w3t_Favorites.F_Thread,w3t_Posts.B_Subject,w3t_Favorites.F_Number,w3t_Posts.B_Board,w3t_Favor |    
| Query   | 3    | Locked         | SELECT B_Main,B_Board                                                                                     
				      FROM   w3t_Posts                                                                                        
				      WHERE  B_Number = 676228                          |                                                     
| Query   | 2    | Locked         | SELECT B_Main,B_Board                                                                                     
				      FROM   w3t_Posts                                                                                        
				      WHERE  B_Number = 673286                          |                                                     
| Query   | 1    | Locked         | SELECT t1.B_Number,t1.B_Parent,t2.U_Username,t1.B_Posted,t1.B_Last_Post,t1.B_Subject,t1.B_Main,t1.B_ |    
| Query   | 0    | Locked         | SELECT t1.B_Number,t1.B_Parent,t2.U_Username,t1.B_Posted,t1.B_Last_Post,t1.B_Subject,t1.B_Main,t1.B_ |    
| Query   | 0    | Locked         | SELECT B_Main,B_Board                                                                                     
				      FROM   w3t_Posts                                                                                        
				      WHERE  B_Number = 676106                          |                                                     
| Query   | 0    |                | show processlist                                                                                          

Is it normal for so many locked processes? Could this be what is causing me all these slowdowns during peak times even though processor usage isn't that high?

Fred


----
Visit the #1 Source of TDI Information on the Web! http://www.tdiclub.com