[development] mysql merge tables and partitioning

[Sammy Spets]

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.