On Fri, November 3, 2006 04:26, Gary V wrote:
> AFAIK awl will grow forever. To trim it, you could use a simple minded:
> DELETE FROM awl WHERE count = 1;
$sql = 'SELECT * FROM `awl` WHERE `count` = 1 AND `totscore` > 12';
i just gava 12 as an example, but users that sent the first mail that is
Benny wrote:
> On Thu, November 2, 2006 15:01, Alberto D'Ambrosio wrote:
>> In general, which kind of housekeeping should be done
>> on awl & bayes MySQL DB's?
> default will work with sql, eg it will expire on its own when the sql limith
> is reached
>> For example, for awl, I previously (pre-M
On Thu, November 2, 2006 15:01, Alberto D'Ambrosio wrote:
> In general, which kind of housekeeping should be done
> on awl & bayes MySQL DB's?
default will work with sql, eg it will expire on its own when the sql limith
is reached
> For example, for awl, I previously (pre-MySQL) used:
> /path/to
On Thu, 2 Nov 2006, Mark Martinec wrote:
> Kenneth,
>
> > We've suddenly had a weird issue with out amavis installation, where
> > DBD::mysql reports our tables in the amavisd db as being 'full'. I
> > . . .
>
> Hm, googling for: mysql table full
> gives:
> MySQL AB :: MySQL 5.0 Reference Manua
Kenneth,
> We've suddenly had a weird issue with out amavis installation, where
> DBD::mysql reports our tables in the amavisd db as being 'full'. I
> cannot understand we on earth it would do this, granted that users on
> this list have reported database size in excess of 60GB.
>
> Nov 1 20:09:3
Hi list
This is my first post to the list, please bear with me if I'm missing
some critical information here.
We've suddenly had a weird issue with out amavis installation, where
DBD::mysql reports our tables in the amavisd db as being 'full'. I
cannot understand we on earth it would do this, gra