Hello,
I have a Windows Server 2003 here at ThePlanet, it's a P4 3.6Ghz with 1Gb RAM.
Since a couple of month something happened and now I'm experiencing problems with performance: the two main sites that are hosted on the server (with about 4.500 + 1.300 daily unique visitors) take a lot of CPU, both on MySQL process and w3wp.exe pools.
mysqld-nt.exe always takes 30%-70% of CPU, and w3wp.exe the remaing 0%-30%, so the server is often 100% busy.
The main site has gained popularity in the last months (and it's based on a phpBB board with PHP running as ISAPI filter), so I see that its occupation has increased (we passed from 1.000 to 4.000+ visitors), but before I remember very low CPU occupation (from 0% to 30% for MySQL, for example).
Even if I try to suspend this site, and to leave the other (that has the same traffic since more than a year (1.000 - 1.300 visitors per day), MySQL CPU is lower but it still go over 30%-40%.
What I can do to understand where's the problem?
Thank you in advance.
Full Version: IIS + MySQL performance problems
QUOTE (Riccardo.Raneri @ May 26 2007, 05:30 PM) 
Hello,
I have a Windows Server 2003 here at ThePlanet, it's a P4 3.6Ghz with 1Gb RAM.
Since a couple of month something happened and now I'm experiencing problems with performance: the two main sites that are hosted on the server (with about 4.500 + 1.300 daily unique visitors) take a lot of CPU, both on MySQL process and w3wp.exe pools.
mysqld-nt.exe always takes 30%-70% of CPU, and w3wp.exe the remaing 0%-30%, so the server is often 100% busy.
The main site has gained popularity in the last months (and it's based on a phpBB board with PHP running as ISAPI filter), so I see that its occupation has increased (we passed from 1.000 to 4.000+ visitors), but before I remember very low CPU occupation (from 0% to 30% for MySQL, for example).
Even if I try to suspend this site, and to leave the other (that has the same traffic since more than a year (1.000 - 1.300 visitors per day), MySQL CPU is lower but it still go over 30%-40%.
What I can do to understand where's the problem?
Thank you in advance.
I have a Windows Server 2003 here at ThePlanet, it's a P4 3.6Ghz with 1Gb RAM.
Since a couple of month something happened and now I'm experiencing problems with performance: the two main sites that are hosted on the server (with about 4.500 + 1.300 daily unique visitors) take a lot of CPU, both on MySQL process and w3wp.exe pools.
mysqld-nt.exe always takes 30%-70% of CPU, and w3wp.exe the remaing 0%-30%, so the server is often 100% busy.
The main site has gained popularity in the last months (and it's based on a phpBB board with PHP running as ISAPI filter), so I see that its occupation has increased (we passed from 1.000 to 4.000+ visitors), but before I remember very low CPU occupation (from 0% to 30% for MySQL, for example).
Even if I try to suspend this site, and to leave the other (that has the same traffic since more than a year (1.000 - 1.300 visitors per day), MySQL CPU is lower but it still go over 30%-40%.
What I can do to understand where's the problem?
Thank you in advance.
On MySQL site, there are some Windows Admin tools you can download to figure out what queries if any are being held up. I imagine however that problem exists that your hardware cannot simply keep up. What does RAM usage look like?
I also recommend you run an optimize tables on all phpBB tables. This will really send MySQL through the roof but you might get some better performance after the fact.
You might want to enable mysql query cache. The best scenario would be to move mysql to its own linux box.
sc
sc
QUOTE
You might want to enable mysql query cache. The best scenario would be to move mysql to its own linux box.
You might want to tweak your my.cnf file or if it doesn't exist you might want to create it. If the box is mainly for IIS and MySQL you can really crank up the caching and memory consumption MySQL uses to handle queries. This will definitely increase query performance.
In the off-chance that the problem is still really bad, you might want to run performance monitor on the server to see if something isn't quite right.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.