Thomas Gelf wrote:
> 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));
>
>
I guess you don't need the 'bigint(20) on id if the id is unique only on
each partition, and you need to add partition_tag to primary key (since
a list partition has to use primary keys)
and you can't do the 'hey, lets just partition based on date and let
mysql do it' since maddr doesn't have a date field
(and we have to match maddr.id,tag with quarantine.id.tag, etc)
--
Michael Scheidell, CTO
Phone: 561-999-5000, x 1259
> *| *SECNAP Network Security Corporation
* Certified SNORT Integrator
* 2008-9 Hot Company Award Winner, World Executive Alliance
* Five-Star Partner Program 2009, VARBusiness
* Best Anti-Spam Product 2008, Network Products Guide
* King of Spam Filters, SC Magazine 2008
_________________________________________________________________________
This email has been scanned and certified safe by SpammerTrap(r).
For Information please see http://www.secnap.com/products/spammertrap/
_________________________________________________________________________
------------------------------------------------------------------------------
_______________________________________________
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/
