MySQL Forums
Forum List  »  Memory Storage Engine

Inserting 300M rows from a Php script to Mysql. Help!
Posted by: Marlon Bell
Date: April 18, 2007 07:51PM

Hello there!
I'm new to Mysql and Php and for the last week or so I'm trying to add 300 Millions rows to a table with 10 columns, the system is very slow and it stops at 200k rows after 4 hours. What I did was to generate a Php script that will automatically insert the same data to the database 300M times........

Why is it so slow?
Why is it that I can not get pass 200K rows?
What can I do in order to improve performance?

Note: Already tried to change some parameters in my.ini like........

# Set buffer pool size to 50-80% of your computer's memory

P3 933Mhz, 640MB SDRAM, 30Gb hd


Options: ReplyQuote

Written By
Inserting 300M rows from a Php script to Mysql. Help!
April 18, 2007 07:51PM

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.