Category Archives: Shell

Optimize all your MySQL tables

Here is a small code snipped I’m using to optimize (or repair or defragment) mysql tables. When for eg. mysqltuner shows something like “Total fragmented tables: 20” and you are awake at a very unpopular time (table optimization will lock … Continue reading

Posted in Database, Debian, Howto, Linux, MySQL, Shell, Snippet | Tagged , , , , | Leave a comment