MySQL :: Re: 350+ million rows -- is this as fast as it can get? (too slow at the moment!)

Contact MySQL |
Login | Register

The world's most popular open source database

Documentation Downloads MySQL.com

Developer Zone

Section Menu:

New Topic

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.

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Views

Written By

Posted

350+ million rows -- is this as fast as it can get? (too slow at the moment!)

15669

Reid Wilson

February 09, 2009 04:12PM

Re: 350+ million rows -- is this as fast as it can get? (too slow at the moment!)

5457

Rick James

February 10, 2009 12:28AM

Re: 350+ million rows -- is this as fast as it can get? (too slow at the moment!)

4318

lau ch

February 10, 2009 02:13AM

Re: 350+ million rows -- is this as fast as it can get? (too slow at the moment!)

3980

Rick James

February 11, 2009 01:46AM

Re: 350+ million rows -- is this as fast as it can get? (too slow at the moment!)

3455

Reid Wilson

February 11, 2009 12:19PM

Re: 350+ million rows -- is this as fast as it can get? (too slow at the moment!)

3433

Rick James

February 11, 2009 10:21PM

Re: 350+ million rows -- is this as fast as it can get? (too slow at the moment!)

3521

aftab khan

February 21, 2009 11:59AM

Re: 350+ million rows -- is this as fast as it can get? (too slow at the moment!)

3203

Osman SARI

February 23, 2009 01:18AM

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.