Le lundi 3 août 2009 12:13:06, Nathan M a écrit :
On Mon, Aug 3, 2009 at 9:22 AM, Luis Daniel Lucio
Quirozluis.daniel.lu...@gmail.com wrote:
OK, and I've already a database with some emails, if I change
$sql_partition_tag = 1, will I mess the DB?
$sql_partition_tag = 1; would do little
Le samedi 1 août 2009 11:15:43, vous avez écrit :
On Fri, Jul 31, 2009 at 7:59 PM, Luis Daniel Lucio
Quirozluis.daniel.lu...@gmail.com wrote:
A stupid question, what advantages do I get if I use partition_tag with
amavisd+mysql?
Faster database cleanups. On a high traffic mail server,
On Aug 2, 2009, at 4:08 AM, Luis Daniel Lucio Quiroz
luis.daniel.lu...@gmail.com
wrote:
Le samedi 1 août 2009 11:15:43, vous avez écrit :
On Fri, Jul 31, 2009 at 7:59 PM, Luis Daniel Lucio
Quirozluis.daniel.lu...@gmail.com wrote:
A stupid question, what advantages do I get if I use
Le samedi 1 août 2009 11:15:43, Nathan M a écrit :
On Fri, Jul 31, 2009 at 7:59 PM, Luis Daniel Lucio
Quirozluis.daniel.lu...@gmail.com wrote:
A stupid question, what advantages do I get if I use partition_tag with
amavisd+mysql?
Faster database cleanups. On a high traffic mail server,
On Mon, Aug 3, 2009 at 9:22 AM, Luis Daniel Lucio
Quirozluis.daniel.lu...@gmail.com wrote:
OK, and I've already a database with some emails, if I change
$sql_partition_tag = 1, will I mess the DB?
$sql_partition_tag = 1; would do little good. If you have the db
setup with partition_tag, it's
Luis,
OK, and I've already a database with some emails, if I change
$sql_partition_tag = 1, will I mess the DB?
Should be alright.
Note that each partition will collect its own subset of e-mail
addresses in a table maddr, which means some addresses will be
duplicates, typically all local user
Le lundi 3 août 2009 12:13:06, Nathan M a écrit :
On Mon, Aug 3, 2009 at 9:22 AM, Luis Daniel Lucio
Quirozluis.daniel.lu...@gmail.com wrote:
OK, and I've already a database with some emails, if I change
$sql_partition_tag = 1, will I mess the DB?
$sql_partition_tag = 1; would do little
On Fri, Jul 31, 2009 at 7:59 PM, Luis Daniel Lucio
Quirozluis.daniel.lu...@gmail.com wrote:
A stupid question, what advantages do I get if I use partition_tag with
amavisd+mysql?
Faster database cleanups. On a high traffic mail server, cleanups can
begin to take days instead of minutes.
Le vendredi 12 décembre 2008 10:52:07, Mark Martinec a écrit :
Michael,
Also found out the partition_tag has to be part or the primary,
and or ALL unique keys. I got the following error otherwise:
ERROR 1503 (HY000): A PRIMARY KEY must include all columns
in the table's
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
Michael,
Btw, even without partitioned tables, deleting by partition_tag value is
often faster than a traditional approach with joins, e.g.:
DELETE FROM msgs WHERE partition_tag = 30 AND partition_tag = 46;
DELETE FROM msgrcptWHERE partition_tag = 30 AND partition_tag = 46;
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.
however, on the mysql 5.1 site taking about partitions, it says they
must be integer, or resolve to integer.
Data type of partitioning
12 matches
Mail list logo