Hi,
On Thu, Oct 4, 2018 at 2:54 AM Giovanni Bechis wrote:
>
> 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
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)
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
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