Newbie PHP MySQL Performance Issue
Posted: Tue Oct 14, 2008 1:19 pm
I have written a PHP script which loads a text file into an empty MySQL database table. I have versions of the script which use INSERT INTO and LOAD DATA INFILE. This test is being run on a Dell PC with XP SP3, Intel Core 2 1.86GHz, and 2 GB RAM. The text file is a syslog containing 80,000 records of 31 fields each.
With either version of the script, the MySQL query process always takes about 40 minutes and the PCs processor utilization is never above 2%. Memory utilization is around 521 MB. Changing the process priority has no effect. Running the test on a different PC (same O/S, different model PC, comparable specs) also has no effect.
The query takes at least 10 times longer than it should. Can anyone suggest where to look to solve this performance issue?
Thank you VERY much for your assistance.
With either version of the script, the MySQL query process always takes about 40 minutes and the PCs processor utilization is never above 2%. Memory utilization is around 521 MB. Changing the process priority has no effect. Running the test on a different PC (same O/S, different model PC, comparable specs) also has no effect.
The query takes at least 10 times longer than it should. Can anyone suggest where to look to solve this performance issue?
Thank you VERY much for your assistance.