News for hackers. Stuff that matters.
Re:Cause of today's Github outage by matwood on Monday November 15, 2010 @11:30AM (#1906813)
I don't have much MySQL experience, but have lots of experience with other RDBMSs. Large restores take a long time no matter what. They shouldn't take days, but since we don't know how large the events table was we have no way of knowing if a faster restore was possible. A hot restore which it sounds like what they are doing may take longer by simple fact that it's restoring while the table is in use.

And DROPs (or truncates) are almost always used if the goal is to remove all the data in a table like you would want if rebuilding the entire system. Something like 100M record transaction is not generally considered a good thing.

Re:Cause of today's Github outage by chesser on Tuesday November 16, 2010 @08:18PM (#1912518)
They take a long time if you have to rebuild the indexes, which is what you have to do if you only have a text dump.

For MySQL, using the standard format (MyISAM), you can just do a file copy if you bothered to do a proper backup of the binary files.