maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #05529
Re: Disk increase with MAD and MAI extension files in tmp dir
-
To:
maria-discuss@xxxxxxxxxxxxxxxxxxx
-
From:
Reindl Harald <h.reindl@xxxxxxxxxxxxx>
-
Date:
Wed, 7 Aug 2019 10:50:41 +0200
-
In-reply-to:
<CAAiHYm0qa7H0JeLui47vC6Z75DDERHQqzFr=JjyJY5PjDMQLdQ@mail.gmail.com>
-
Openpgp:
id=9D2B46CDBC140A36753AE4D733174D5A5892B7B8; url=https://arrakis-tls.thelounge.net/gpg/h.reindl_thelounge.net.pub.txt
-
Organization:
the lounge interactive design
-
User-agent:
Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.8.0
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
