Performance Issue
We have data in CVS form and that is bulk loaded inot MyIsam tables using "Load Data". Requirement is to be able to load anywhere from 15,000 to 20,000 rows per second in order to keep up with the data flow, however we are able to get 5000 - 8000 rows/sec. This is tested on RAID 5 local storage. we set "delay_key_writes = ALL" in our my.cnf and also very large key buffer size.
Any suggestions.
Kulbir
Subject
Views
Written By
Posted
Performance Issue
3329
March 09, 2010 05:48PM
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.