[development] mysql merge tables and partitioning

[Sammy Spets]

Clarification. The functionality is targetting 6.x but there is still 
the hurdle of acceptance. Place comments into the issue post below if 
you support the inclusion (we'll need to get better benchmarks most 
likely).

Cheers,

-- 
Sammy Spets
Synerger Pty Ltd
http://synerger.com

On 01-Feb-07 23:09, Sammy Spets wrote:
> 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
> 6.x.
> 
> 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:
> 	http://drupal.org/node/78503
> 
> Cheers,
> 
> -- 
> Sammy Spets
> Synerger Pty Ltd
> http://synerger.com
> 
> 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.