MySQL Forums
Forum List  »  Performance

Re: 350+ million rows -- is this as fast as it can get? (too slow at the moment!)
Posted by: Rick James
Date: February 11, 2009 10:21PM

14 hours seems too long. MyISAM, right? Perhaps the setting for myisam_max_sort_file_size is not high enough.

What does SHOW PROCESSLIST; say the ALTER is currently doing?

Both of those are clues; I don't know the full interpretation; sorry.

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.