Michael Scheidell wrote:
> 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)
Yes and no: primary key is defined as PRIMARY KEY (id, partition_tag),
however
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
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
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?
--
Michael Scheidell, CTO
Phone:
