Re: write/insert performance problem (not solved for me)

[James Day]

It appears that this is going to take more work from you to help identify the cause. To start, I'd be interested in knowing what happens if you make a complete copy of the installation and all data from the slow machine to a fast machine. Does the fast one become slow or stay fast? Then a copy from the fast to the slow and see if it becomes fast.

This to try to sort out whether it is MySQL settings, disk controller or operating system settings or maybe a RAID card with a bad drive or similar problem.

If you can get a fast machine to become slow with 4.1 or a slow machine with 4.1 to become fast with 4.0 you'll have found something I expect the developers to be very interested in.:)

If those tests aren't practical, posting the complete my.ini/my.cnf files from each machine might give some clue (remove any passwords if you have them in there, of course:)). But still too many other differences to be sure of finding a cause.

If Sergey suggests something else, believe Sergey - he's the expert.:)