Re: large tables, large keycaches
Posted by:
Jay Pipes
Date: July 26, 2005 08:43AM
One other suggestion besides Ingo's good reference is to ensure that you're using the query cache as effectively as possible. Utilizing the query cache will completely bypass the need for the key cache blocks for queries with exact matches in the query cache, and along with separate key caches for hot and warm blocks, would alleviate a lot of the pressure on the default key cache...
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
9178
July 25, 2005 09:12PM
3552
July 26, 2005 04:04AM
Re: large tables, large keycaches
3187
July 26, 2005 08:43AM
3132
July 26, 2005 10:37AM
2996
July 26, 2005 11:49AM
2722
July 26, 2005 02:27PM
2798
July 26, 2005 04:36PM
2610
July 27, 2005 03:03AM
2566
July 27, 2005 02:53AM
2475
July 27, 2005 10:49AM
2499
July 27, 2005 03:52PM
2459
July 28, 2005 02:36AM
2465
July 28, 2005 06:38PM
2517
August 02, 2005 08:04PM
2615
July 26, 2005 10:51AM
2570
July 27, 2005 03:15AM
2466
July 27, 2005 07:48AM
2448
July 28, 2005 03:12AM
2550
July 28, 2005 01:08PM
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.