Re: High cpu load problem
Posted by:
Jay Pipes
Date: July 19, 2005 04:04AM
Turn on the query cache. You have it on, but set to zero size (query_cache_size = 0).
SET GLOBAL QUERY_CACHE_SIZE = 32000000
will set it ~32MB. or you can adjust query_cache_size in my.cnf
You'll see an immediate increase in performance.
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
26393
July 18, 2005 03:00AM
9634
July 18, 2005 05:16AM
9247
July 18, 2005 04:46PM
9745
July 19, 2005 12:49AM
Re: High cpu load problem
9478
July 19, 2005 04:04AM
8031
July 19, 2005 06:35AM
8392
July 19, 2005 06:22PM
10725
July 19, 2005 10:01AM
6784
July 25, 2005 03:15AM
7425
July 18, 2005 05:50PM
6343
July 19, 2005 12:59AM
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.