On 10/04/18 04:30, Alex wrote:
> Hi,
>
> I need to delete some of the old entries from my txrep database as
> it's grown to 3GB, oops. When attempting to do this, it fails with
> "error 14":
>
do you have enough space for tmp tables ? What if you try to delete less data ?
Does mysqlcheck(1) spots
(Please ignore my last message. My phone hit “send” randomly.)
On Sep 28, 2018, at 9:48 AM EDT, bOnK wrote:
> A better idea might be testing if SPF for a external domain would pass on
> your own server.
> This is what milter greylist does.
> http://hcpnet.free.fr/milter-greylist/
That’s interest
Alex,
I use this command nightly: 'DELETE FROM txrep WHERE last_hit <= (now()
- INTERVAL 90 day);'
I would recommend you try that and then just drop and recreate the table
if you need. This sounds like a bad issue with the database.
Regards,
KAM
On 10/3/2018 10:30 PM, Alex wrote:
> Hi,
>
> I ne
On Sep 28, 2018, at 9:48 AM, bOnK wrote:
A better idea might be testing if SPF for a external domain would pass on your
own server.
>
> This is what milter greylist does.
> http://hcpnet.free.fr/milter-greylist/
>
> Though probably exceptional, according to the RFC +all *can be* restrictive...
>
Hi,
I need to delete some of the old entries from my txrep database as
it's grown to 3GB, oops. When attempting to do this, it fails with
"error 14":
# rpm -q mariadb
mariadb-10.2.17-2.fc28.x86_64
# ls -l
total 3141664
-rw-rw 1 mysql mysql 65 Oct 19 2017 db.opt
-rw-rw 1 mysql my
The thread has gone somewhat off-topic, which is partly my own fault.
The issues with URIBL misusage is a "side note", NOT the main purpose of
this thread. (again, that is party my fault since I mentioned that to
begin with). Also, I want to make sure that everyone knows that it was
my client (
