[drupal-devel] MySQL, large keys
gerhard at killesreiter.de
Fri Oct 21 09:02:28 UTC 2005
Dries Buytaert wrote:
>>> David Axmark, co-founder of MySQL had a quick look at Drupal's
>>> database scheme and hinted that we should take a look at the length
>>> of our table keys. He suggested that reducing their size, might
>>> improve performance. Someone to investigate this, and to run some
I might find time to do some. David also told us that the mysql query
cache for a table is emtied when a table changes. That means thet the
mysql query cache for the cache table is invalidated very often.
Splitting up the cache table into dedicated tables for menu, filter,
page, locale, default will therefore make the mysql query cache more
efficient. Also, generally selects will be faster.
I have been creating a patch that I know is buggy and incomplete, but I
let you all have a look nevertheless. I hope to be able to create some
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 12872 bytes
Desc: not available
Url : http://drupal3.drupal.org/pipermail/development/attachments/20051021/595fb396/cache.bin
More information about the drupal-devel