Hi, Kevin! When did it start?
Did you, for example, upgrade from 10.3.13 to 10.3.14 and then noticed it? (I'm not saying this is a known bug in 10.3.14, it was just an example) What filesystem is it? And, don't forget, if it looks like a bug to you, report it at jira.mariadb.org to get it fixed On Aug 07, Kevin DG wrote: > Hello all, > > 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' > -rw-rw---- 1 mysql mysql 8192 Jul 8 15:02 '#sql_1_14.MAI' > -rw-rw---- 1 mysql mysql 8192 Jul 8 15:18 '#sql_1_2.MAD' > -rw-rw---- 1 mysql mysql 8192 Jul 8 15:18 '#sql_1_2.MAI' > -rw-rw---- 1 mysql mysql 12613459968 Jul 8 15:20 '#sql_1_25.MAD' > -rw-rw---- 1 mysql mysql 8192 Jul 8 15:03 '#sql_1_25.MAI' > -rw-rw---- 1 mysql mysql 12221440000 Jul 8 15:20 '#sql_1_26.MAD' > -rw-rw---- 1 mysql mysql 8192 Jul 8 15:03 '#sql_1_26.MAI' > -rw-rw---- 1 mysql mysql 12220719104 Jul 8 15:20 '#sql_1_29.MAD' > -rw-rw---- 1 mysql mysql 8192 Jul 8 15:03 '#sql_1_29.MAI' > -rw-rw---- 1 mysql mysql 12220907520 Jul 8 15:20 '#sql_1_36.MAD' > -rw-rw---- 1 mysql mysql 8192 Jul 8 15:03 '#sql_1_36.MAI' > -rw-rw---- 1 mysql mysql 14190247936 Jul 8 15:18 '#sql_1_4.MAD' > -rw-rw---- 1 mysql mysql 8192 Jul 8 15:02 '#sql_1_4.MAI' > -rw-rw---- 1 mysql mysql 12220588032 Jul 8 15:18 '#sql_1_47.MAD' > -rw-rw---- 1 mysql mysql 8192 Jul 8 15:03 '#sql_1_47.MAI' > -rw-rw---- 1 mysql mysql 13350912000 Jul 8 15:18 '#sql_1_6.MAD' > -rw-rw---- 1 mysql mysql 8192 Jul 8 15:02 '#sql_1_6.MAI' > > > We failed to identify the origin of this behaviour. > > Does anyone know what can trigger this behavior ? We also failed to find a > configuration paramater to avoid and limit the size of these files, any > ideas about that ? > > Thanks for your help, Regards, Sergei VP of MariaDB Server Engineering and [email protected] _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
