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.
Subject
Views
Written By
Posted
11039
November 02, 2004 09:26PM
5363
November 05, 2004 12:49AM
Re: create index on a very large table problem
5565
November 07, 2004 01:28PM
4806
November 30, 2004 11:57AM
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.