471,073 Members | 1,386 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,073 software developers and data experts.

splitting key cache

In mysql 4.1, there are new ways to save different index files into
different key_cache segments. The idea is to remove problems with
key_cache locking if another process is accessing it.

As this involves maintenance, etc....

Question: Has anyone seen any measurable improvement in doing this,
vs. just creating a huge key_cache and being done with it.

Thanks.

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/mySQL-splitt...ict241861.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=840574
Jul 23 '05 #1
0 959

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by James Conrad St.John Foreman | last post: by
3 posts views Thread by martin | last post: by
5 posts views Thread by Darrel | last post: by
14 posts views Thread by Tom.PesterDELETETHISSS | last post: by
5 posts views Thread by Stan SR | last post: by
reply views Thread by =?Utf-8?B?YmlqYXk=?= | last post: by
2 posts views Thread by shadow_ | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.