Re: Need Perfomance / Tuning Help
Posted by:
Jay Pipes
Date: November 23, 2005 08:54AM
OK, the query cache is off to a good start. You've had 74421 queries, and of those, 24869 have come from the query cache, meaning no disk or even key buffer access. Almost instantaneous returns.
Since this status variable output was only done after 501 seconds ( < 10 minutes) of uptime, it's tough to say whether the changes made have had good effects or not. I'll take a look at your site, and you go ahead and post back your status and server variables after *at least* two days, so that the server has enough time to "even out" and provide decent stats.
Cheers,
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Got Cluster?
http://www.mysql.com/cluster
Personal:
http://jpipes.com
Subject
Views
Written By
Posted
2361
November 21, 2005 05:38AM
1719
November 21, 2005 06:31AM
1649
November 21, 2005 07:26AM
3058
November 22, 2005 08:21PM
1738
November 23, 2005 07:19AM
Re: Need Perfomance / Tuning Help
1668
November 23, 2005 08:54AM
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.