Tag: Beware of large MySQL max_sort_length parameter

Miscellaneous, Troubleshooting

Beware of large MySQL max_sort_length parameter

Today we had a very interesting phenomena at a customer. He complained that MySQL always get some errors of the following type: [ERROR] mysqld: Sort aborted: Error writing file ‘/tmp/MYGbBrpA’ (Errcode: 28 – No space left on device) After a first investigation we found that df -h /tmp shows from time to time a full …