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
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