MySQL Forums
Forum List  »  Performance

Re: create index on a very large table problem
Posted by: ford
Date: November 07, 2004 01:28PM

PROCESSLIST looks good, actually server dedicated to this process and no other job or request on database or server.
I have tried multiple load. I have turned off index (except PK) and after loading data add index to a table with 10M, 20M, .... 50M rows.
In another attempt I created table with index and load 10M row at a time. All attempts show exponential behavior on index creation.
I have tried other process monitor (gkrellm and top) . They all show memory is not the bottle neck and disk IO is heavy but not major cause, put CPU is heavily used. CPU is used by OS (kjournald) and mysql.

Options: ReplyQuote


Subject
Views
Written By
Posted
10819
November 02, 2004 09:26PM
Re: create index on a very large table problem
5473
November 07, 2004 01:28PM


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.