> Hallo Michael,
>
>
>> If you created these with REAL partitions, then you could alter table drop
>> partition (which is even faster)
>>
> What do you mean with REAL partitions? Partitions in MySQL?
>
Yes, see recent post by Thomas Gelf.
--
Michael Scheidell, CTO
>|SECNAP Network Security
Fi
Hallo Thomas,
> Yes, using MySQL 5.1 - it helped me to decrease time needed for garbage
> collection from 4 days to 4 seconds.
>
Can you point me to some good documentation how to implement that? I am running
5.1.36 over here.
> Regards,
> Thomas Gelf
>
// Steve
--
Neu: GMX Doppel-FLAT mit I
Steve wrote:
>> If you created these with REAL partitions, then you could alter table drop
>> partition (which is even faster)
>>
> What do you mean with REAL partitions? Partitions in MySQL?
Yes, using MySQL 5.1 - it helped me to decrease time needed for garbage
collection from 4 days to 4 second
Hallo Michael,
> You did added the modulus 100 to make sure that mysql replication didn't
> end
> up with an email address on server 1 with a id of 101 and the same email
> address on server 2 with a id of 201? (or whatever)
>
Yes but I removed the modulus 100 because I got duplicate entry error
> Hallo Michael,
>
>
>> We have systems with multi master (dual master and more). We had to
>> remove
>> the foreign key constraints long ago. (for that and other reasons).
>>
> So you advise me to just drop them?
> ALTER TABLE `quarantine` DROP FOREIGN KEY `quarantine_ibfk_1`;
> ALTER TABLE `m
Hallo Michael,
> We have systems with multi master (dual master and more). We had to
> remove
> the foreign key constraints long ago. (for that and other reasons).
>
So you advise me to just drop them?
ALTER TABLE `quarantine` DROP FOREIGN KEY `quarantine_ibfk_1`;
ALTER TABLE `msgs` DROP FOREIG
> Hello list
>
> I am running here Amavisd-new 2.6.4 with MySQL in dual master replication and
> I often get into problems that Amavisd-new data in MySQL can't be replicated
> because of foreign key constraint.
>
> Is there any documentation how to setup Amavisd-new in a MySQL environment
> with
Hello list
I am running here Amavisd-new 2.6.4 with MySQL in dual master replication and I
often get into problems that Amavisd-new data in MySQL can't be replicated
because of foreign key constraint.
Is there any documentation how to setup Amavisd-new in a MySQL environment with
dual master r