Performances problems with MySQL and ASP
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
Subject
Views
Written By
Posted
Performances problems with MySQL and ASP
3337
October 28, 2004 04:03PM
2464
October 30, 2004 04:53AM
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.