← Back to team overview

maria-discuss team mailing list archive

Re: Disk increase with MAD and MAI extension files in tmp dir

 


Am 07.08.19 um 10:30 schrieb Kevin DG:
> MariaDB version -> 10.3.14
> 
> Recently, we had a new problem with our MariaDB instance. Indeed,
> suddenly the size of the tmp directory has increased almost
> instantaneously, to finish saturating the disk.
> 
> We have encountered this problem twice and don't understand currently
> the problem origin.
> 
> The result of 'ls -l /tmp' during the problem:
> 
> mysql@16c212e7dbb5:/tmp# ls -l
> total 126786988
> -rw-rw---- 1 mysql mysql 14190428160 Jul  8 15:18 '#sql_1_1.MAD'
> -rw-rw---- 1 mysql mysql        8192 Jul  8 15:02 '#sql_1_1.MAI'
> -rw-rw---- 1 mysql mysql 13344178176 Jul  8 15:18 '#sql_1_11.MAD'
> -rw-rw---- 1 mysql mysql        8192 Jul  8 15:02 '#sql_1_11.MAI'
> -rw-rw---- 1 mysql mysql 13344546816 Jul  8 15:18 '#sql_1_14.MAD'
looks like temporary tables from bad queries
enable slow query log


References