MySQL Forums
Forum List  »  Performance

Performances problems with MySQL and ASP
Posted by: Bernard BARON
Date: October 28, 2004 04:03PM

We have setup a large intranet relying on MySQL 4012 and IIS 5.0 on win2000 servers (multiprocessors G3).

When we run load tests (50 concurrent users) we experience a hudge performance degradation (Processors are stucked at 100% and response time are degrading from 1s to 190 s ).

The Database is very small (less than 20 MB) and most of the db access are for read operations.

We have analysed the performance with the MS tools and we have seen that MySQL is generating a hudge amount of I/O paging.

What are the relevant issues ?
. tuning of MySQL (how to eliminate swapping ? what values for the key parameters ?)
. version of MySQL (should we migrate to MySQL 4.1 ?)

Is the combination of MySQL and IIS viable (ODBC is not the best middleware).

Thank you for your help
Bernard

Options: ReplyQuote


Subject
Views
Written By
Posted
Performances problems with MySQL and ASP
3071
October 28, 2004 04:03PM


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.