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
25920
July 18, 2005 03:00AM
9471
July 18, 2005 05:16AM
9063
July 18, 2005 04:46PM
9558
July 19, 2005 12:49AM
Re: High cpu load problem
9223
July 19, 2005 04:04AM
7846
July 19, 2005 06:35AM
8213
July 19, 2005 06:22PM
10484
July 19, 2005 10:01AM
6621
July 25, 2005 03:15AM
7251
July 18, 2005 05:50PM
6166
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.