Don’t forget this is mysql 5.1...
On 8 March 2016 at 10:21:45 PM, Andrea Brancatelli (abrancate...@schema31.it)
wrote:
As a side node that will require longer time and more space than the ALTER
TABLE Engine=InnoDB ROW_FORMAT_COMPRESSED, as you will have to read the table
to write the dump, and then read the dump to write the table, opposed to
reading the table to write the new one.
Furthermore unless you do online gzipping or such the dump will require more
space than the new, compressed, table.
But, hey, it's your server :-)
---
Andrea Brancatelli
Schema31 S.p.a.
Responsabile IT
ROMA - BO - FI - PA
ITALY
Tel: +39. 06.98.358.472
Cell: +39 331.2488468
Fax: +39. 055.71.880.466
Società del Gruppo SC31 ITALIA
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
