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