MySQL Forums
Forum List  »  Performance

Re: Poor performance on 4GB system
Posted by: Jay Pipes
Date: November 24, 2005 11:49AM

So, you're currently running at ~180 queries/second. That's your baseline.

Could you post the schema using a DESCRIBE for forum_post, forum_post_text, forum_thread, and user? It would help to determine, amongst other things why the relationship between forum_post and forum_post_text is showing as a ref access type instead of an eq_ref access type when joined to each other. Thanks!

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com

Options: ReplyQuote


Subject
Views
Written By
Posted
2049
November 24, 2005 09:16AM
Re: Poor performance on 4GB system
1332
November 24, 2005 11:49AM
1209
November 28, 2005 03:33AM
1292
November 29, 2005 11:34AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.