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
26267
July 18, 2005 03:00AM
9579
July 18, 2005 05:16AM
9205
July 18, 2005 04:46PM
9704
July 19, 2005 12:49AM
Re: High cpu load problem
9440
July 19, 2005 04:04AM
7982
July 19, 2005 06:35AM
8361
July 19, 2005 06:22PM
10657
July 19, 2005 10:01AM
6750
July 25, 2005 03:15AM
7391
July 18, 2005 05:50PM
6302
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.