[drupal-devel] MySQL, large keys

[Gerhard Killesreiter]

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 
>>> benchmarks?
>>
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 
benchmarks shortly.

Cheers,
    Gerhard
-------------- next part --------------
A non-text attachment was scrubbed...
Name: cache.patch
Type: text/x-patch
Size: 12872 bytes
Desc: not available
Url : http://drupal3.drupal.org/pipermail/development/attachments/20051021/595fb396/cache.bin