MySQL Performance Improvement Needed Urgently

[Tom Barrand]

Hi,

I am using MySQL 4.1 on Linux (IBM Open Power Server).

I have a Java based application that runs in Tomcat in a Windows environment using SQL Server. As part of a customer project I have got the application to work on Tomcat on Linux with MySQL.

Both databases have a large amount of data in some of the tables, e.g. 500,000+ records in some of the tables. Some of the tables have indexes on them.

There is a specifc part of the application that is slow when running against MySQL (10 seconds to write a record to a table with 500,000+ records in it.) The same bit of functionality running against SQL Server is instance, e.g. 2 secomds max.

I am presuming that some tweaks need to be made to MySQL so that it is optimised to handle this large amount of data.

Any ideas on what chances I could make to improve this?

Thanks for your help