[development] mysql merge tables and partitioning

Sammy Spets sammys-drupal at synerger.com
Thu Feb 1 12:09:36 UTC 2007

Hi Moshe,

Killes and m3avrck did loads of work in the area of speedups for
heavy-write tables like watchdog and accesslog. Their work nearly made
it into 5.1, but it was too late. The functionality will be going into

What killes found was merge tables. This will work on all Drupal 
supported MySQL versions.

For those from PostgreSQL ilk, we also will get a speed improvement. 
Killes requested I look into it and sure enough there is table 
partitioning in our wonderful DBMS for all Drupal supported versions. 
Yay for us! :)

For more information about the patches and how it was done see:


Sammy Spets
Synerger Pty Ltd

On 31-Jan-07 22:50, Moshe Weitzman wrote:
> nice article at 
> http://sebastian-bergmann.de/archives/655-Partitioning-with-Dates-in-MySQL-5.1.html. 
> it describes mysql's new partitioning feature which seems like a good idea 
> for our accesslog table. seems like drupal doesn't even have to know about 
> the partitions, apart from system.install.
> if you haven't looked into it, access logging is a bad performance 
> bottleneck in drupal. if you want a fast site, i recommend disabling 
> statistics.module entirely.
> if your DBMS isn't mysql 5.1+ this would not apply to your site. thats 
> obvious, but i'm quite certain someone will complain that this is mysql 
> only and 5.1_ only and all that. yeah, we know. move on.

More information about the development mailing list