… engine which may be hard to guaranty in many environments when development has too much autonomy. I must note…databases on two servers on two DRBD devices laid out in a “criss-cross†fashion, converging… month will be hot on the slave which is doing reads but only last few hours will be hot on…
Post: Thinking about running OPTIMIZE on your Innodb Table ? Stop!
December 9, 2010 By 13 Comments
…tables do benefit from being reorganized often. You can get data physically laid out in primary key order …ALTER and when adding them back can be a lot faster than straight ALTER TABLE. P.S I do not …like mysqldump) do not get advantage of it and will use old slow method of building indexes by …
