Michael Scheidell wrote:
> I looked at the readme's and some of the stuff Thomas Gelf wrote about
> mysql partitioning and amavisd partitioning, and tried a couple of them
> without much success.
>
> Did anyone write a 'setup/ quarantine cleanup' cheat sheet for mysql
> partitioning and amavisd?
Hi Michael,
there is no cheat sheet / howto I'm aware of. Setup is not that hard,
I'd suggest something like the following:
amavisd.conf:
$sql_partition_tag = sub {
my($msginfo) = @_;
iso8601_week($msginfo->rx_time);
};
Table creation:
CREATE TABLE maddr (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
partition_tag int(11) NOT NULL DEFAULT '0',
email varbinary(255) NOT NULL,
domain varchar(255) NOT NULL,
PRIMARY KEY (id, partition_tag),
UNIQUE KEY email_key (partition_tag, email)
) ENGINE=InnoDB PARTITION BY LIST (partition_tag) (
PARTITION p0 VALUES IN (0,1,2,3,4,5),
...
PARTITION p8 VALUES IN (48,49,50,51,52,53));
...and so on. There are other partition types, but there are several
reasons I opted for list partitioning. Example above is taken from my
speech at todays "Mailserver Konferenz 2009" in Berlin. I know that a
full-blown howto would definitively be better ;-)
Best regards,
Thomas Gelf
------------------------------------------------------------------------------
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
