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
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
