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!)

15756

Reid Wilson

February 09, 2009 04:12PM

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

5486

Rick James

February 10, 2009 12:28AM

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

4344

lau ch

February 10, 2009 02:13AM

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

4004

Rick James

February 11, 2009 01:46AM

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

3482

Reid Wilson

February 11, 2009 12:19PM

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

3463

Rick James

February 11, 2009 10:21PM

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

3551

aftab khan

February 21, 2009 11:59AM

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

3237

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.