non-linearity in the insert rate means you have indexes on some columns. depending on your situation, mysql can be more efficient if drop those indexes, do bulk inserts, and then add the indexes again.
On 1/23/10 5:02 AM, "Krishna Chandra Prajapati" <prajapat...@gmail.com> wrote: > Hi shawn, > > As the data grows to 20 millions the insert rate will become very slow. In > such case i am getting 2000 insert/seconds only. > > Therefore my objective is not achieved. > > I cannot slow up the insert rate of 10,000/second. I am getting data > (inserted by users at this rate) > > Is there any other way to do so. (distributed servers) > > Thanks, > Krishna > > On Thu, Jan 21, 2010 at 7:39 PM, Shawn Green <shawn.gr...@sun.com> wrote: > >> Krishna Chandra Prajapati wrote: >> >>> Hi list, >>> >>> I want to insert 10000 records/sec into table. There can be n number of >>> tables with unique data in each. What are the possible ways to do ? >>> >>> Thanks, >>> Krishna >>> >>> The manual is your friend. It doesn't hurt to consult it. >> >> INSERT ... >> http://dev.mysql.com/doc/refman/5.1/en/insert.html >> >> LOAD DATA INFILE ... >> http://dev.mysql.com/doc/refman/5.1/en/load-data.html >> >> And we even have both general and specific suggestions on improving INSERT >> performance in our Optimization chapter: >> http://dev.mysql.com/doc/refman/5.1/en/optimization.html >> >> Warmest regards, >> -- >> Shawn Green, MySQL Senior Support Engineer >> Sun Microsystems, Inc. >> Office: Blountville, TN >> >> >> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
