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.... 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.