How to clean or resize the ibtmp1 file in MySQL

Based on “How to clean or resize the ibtmp1 file in MySQL?” This is another lesson learned in rather “hard way” – temporary tablespace on one of our instances grew so big we had problems with full disk. Fortunately both Debian and MySQL...

Check MySQL slow log from command line

MySQL slow log is extremely useful feature of MySQL server. But its investigation can be very painful. Mainly due to the usually huge size of it. Investigation using command line tools is usually the quickest possibility. So here are few useful commands: find longest...

How to handle errcode 28 – no space left

You can see “Errcode: 28 – No space left” in MySQL error.log for several reasons. In the past when DBAs usually lived without monitoring it could “really surprised” them that disk was full one day… 🙂 In these days I think everyone...