Re: [Dbmail] Assistance with DB (mysql) size optimisation

2016-03-06 Thread Simon Buchanan
Thanks for the replies on this. After consideration, and the fact that this is a “best effort” service for us, I’m going to take it offline mysqldump and re-import.  Mysql is currently on 5.1, is it worth upgrading to 5.5, 5.6 or 5.7? On 5 March 2016 at 1:53:08 AM, Curtis Maurand (cmaur...@gma

Re: [Dbmail] Assistance with DB (mysql) size optimisation

2016-03-06 Thread Reindl Harald (mobile)
5.1 is terrible slow compared to 5.5 with optimized configs (see list archive) and with 5.6 you would type just "optimize table" online regularly to prevent get database sizes where no enough space is left in other words: you should have upgraded years ago, can't remember when it was here, in