Hi, On Thu, Oct 4, 2018 at 2:54 AM Giovanni Bechis <giova...@paclan.it> 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 for tmp tables ? What if you try to delete less data > ? Does mysqlcheck(1) spots anything wrong ?
There's nearly 500GB left on the partition and probably 50GB RAM free. I was successful deleting about 15 days of data at a time. mysqlcheck(1) reported no problems on the txrep table. There's now less than 60 days of data in the database, but the file still shows 3GB. # ls -l total 3141664 -rw-rw---- 1 mysql mysql 65 Oct 19 2017 db.opt -rw-rw---- 1 mysql mysql 2222 Oct 4 11:39 txrep.frm -rw-rw---- 1 mysql mysql 3217031168 Oct 4 15:51 txrep.ibd I ran "optimize table txrep;" and it shrunk it down to 350MB. I'll add an entry to cron to delete more regularly.
