Re: 10 inserts a sec into redhat box

[mos]

At 05:57 AM 11/5/2009, you wrote:
>Hello, I am currently inserting about 10 rows (2 varchar 50 fields ) a sec 
>into modern 4 processor RH 5.x  box using perl Net::Mysql from another box 
>of similar spec. This is rather less than expected. I suspect I 
>could  push the inserts from the source box much faster than that. And 
>that it is the target box that is the problem. Top reveals it has a load 
>average of 2 to 3. How can I look into this performance problem? TIA Syd

You should be getting inserts much faster than that. Is the machine disk 
bound or CPU bound?

Are you using InnoDb or MyISAM tables? If you run the same test on the same 
machine as the MySQL server, how fast is it then? If it is much faster then 
the problem is likely your network and you'll need to monitor the network 
bandwidth. It could be a faulty NIC or cable.

If it is the same speed on the server box then the problem is with your 
database. You can of course insert multiple lines with one Insert statement 
(see manual) or use a Load Data Infile to load the data from a CSV file. 
How many indexes does the table have and how many rows are in the table? 
The more indexes then the slower the inserts. You could post your update 
SQL statement and the table structure.



Mike