splitting key cache

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

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.


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-splitting-key-cache-ftopict241861.html
Visit Topic URL to contact author (reg. req'd).  Report abuse:

Site Timeline