DEV Community

Discussion on: Archiving large MySQL tables (part I - intro)

Collapse
 
chuckvincent profile image
chuckvincent

after spending several days with the gh-ost docs all my questions were answered. thus RTFM in full. If anyone else is trying this beware of extra bin logs created, I ran out of disk space and crashed a master mysql server because I did not account for extra bin log space, i had enough space to gh-ost my large table (27M rows @ 500GB), but the extra logs that were required to maintain the slave servers put be over the top.

Thread Thread
 
borama profile image
Matouš Borák

Ah, yeah, I wrote about that too but it's very easy to miss a critical detail like this, among all the info. Hope your server recovered well!