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........
Example:

# Set buffer pool size to 50-80% of your computer's memory
innodb_buffer_pool_size=70M
innodb_additional_mem_pool_size=10M
etc...


P3 933Mhz, 640MB SDRAM, 30Gb hd

Thanks!
Marlon.

Options: ReplyQuote


Subject
Views
Written By
Posted
Inserting 300M rows from a Php script to Mysql. Help!
5739
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.