Re: Assistance with DB (mysql) size optimisation
Simon Buchanan <[email protected]> Wed, 9 Mar 2016 13:11:59 +1300
| Newsgroups | gmane.mail.imap.dbmail |
|---|---|
| Message-ID | <[email protected]> |
Don’t forget this is mysql 5.1... On 8 March 2016 at 10:21:45 PM, Andrea Brancatelli ([email protected]) 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 [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail