Previous Thread
Next Thread
Print Thread
Hop To
#39874 02/24/2004 2:20 PM
Joined: Jan 2004
Posts: 20
V
stranger
stranger
V Offline
Joined: Jan 2004
Posts: 20
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
#39875 02/25/2004 1:10 AM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
More than likely that is what would be causing slowdowns. And more then likely those locks are coming from the search. Due to the ability to form more complex searches in the 6.4 series it can take longer for them to execute and during the time mysql is looking for the results it ends up locking the tables until it's done. We've addressed alot of these issues in the upcoming 6.5 release.

#39876 02/25/2004 2:13 AM
Joined: Jan 2004
Posts: 20
V
stranger
stranger
V Offline
Joined: Jan 2004
Posts: 20
I'm going to limit the searches to something simple for now.... My users keep thinking I need a hardware upgrade, but I disagree.. Perhaps I'm right. <img src="https://www.ubbcentral.com/boards/images/graemlins/confused.gif" alt="" /> Hope 6.5 won't be too long.


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

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
Is UBB.threads still going?
by Aaron101 - 04/01/2022 8:18 AM
Who's Online Now
0 members (), 898 guests, and 155 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)