> Michael, > >> I think I read that the 'partition_tag' can be anything, char(), int, >> anything really, as long as you can define it in the $sql_partition tag >> in amavisd.conf. > > Yes, as far as amavisd is concerned. > >> however, on the mysql 5.1 site taking about partitions, it says they >> must be integer, or resolve to integer. >>
Also found out the partition_tag has to be part or the primary, and or ALL unique keys. But, good to know that the delete by partition is faster. Our combination of penpals/ and all the invalid (dha) addresses in maddr have made that original penpals query very slow (which is why we decided to byte the bullet and convert to 2.6) If I can, and its generic enough, I'll try to update the mysql documentation for 2.7? (maybe) http://dev.mysql.com/doc/refman/5.1/en/partitioning-limitations-partitioning -keys-unique-keys.html I got the following error otherwise: ERROR 1503 (HY000): A PRIMARY KEY must include all columns in the table's partitioning function -- Michael Scheidell, CTO >|SECNAP Network Security Winner 2008 Network Products Guide Hot Companies FreeBSD SpamAssassin Ports maintainer _________________________________________________________________________ This email has been scanned and certified safe by SpammerTrap(r). For Information please see http://www.secnap.com/products/spammertrap/ _________________________________________________________________________ ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ 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/
