My server config is as below :
Processor - 2 x Pentium Xeon, 3.0GHz
Memory - 2GB (512MB x 2) Max. 12GB
OS max hardware support - 2CPU, 16GB RAM

We uses, mysql and cms to develop our portal
We received complaint about slowness in accessing out current web portal. Please advice on how to calculate no of concurrent users before the server hang.
What is the alternative solution to able 1000 concurrent users, do I really need to add another server?

Is it opensource CMS and if yes, which one? What does TOP command output (go to shell, type top to see list of processes and how much resources they consume).
Also, you could provide a link to your portal so we can see what type of site is it (is it heavy databse dependant or not).
There are several mechanisms that you can implement in your CMS to lower the overall load like caching of pages (which reduces mysql querying, meaning mysql works less).
It's really hard to advise anything without more info.
For comparision, I have the following server config:

P4 3.06ghz with HT
2GB RAM
FreeBSD (unix)

It supports arround 400 concurrent users without any performance problems, and there's plenty of resources left (roughly, I'd say I could squeeze additional 300 concurrent users without any suffering in performance).

Look at http://www.webhostingtalk.com/showthread.php?t=497625 maybe it cause by too many mysql connection. It could be your cms cause this problem. Please report to your cms support.

What does TOP command output (go to shell, type top to see list of processes and how much resources they consume).


what do you mean by that? i don't knoe how to do TOP command.


well, the CMS i'm using is develop by a vendor. and i can't give the link here ( cause of company policy)

If you have shell access to your server and if you run any type of linux/unix - just type TOP to see which processes are consuming most of your resources.
That way you will narrow down possibilities of why your site works slowly.
My bet would be that MySQL is causing this performance drop, and without any exact details - we are just guessing and not helping you.
Ask your CMS vendor to run a few tests to help you determine what's wrong.

My bet would be that MySQL is causing this performance drop, and without any exact details - we are just guessing and not helping you.
Ask your CMS vendor to run a few tests to help you determine what's wrong.

Thanks and sorry cannot give more information. (company's policies)

well, we also believe that CMS or mysql queries are causing this bad performance.
actually, the portal doing well in normal day, but in that big day/event it's cannot even support more than 100 concurrent user. and even after reboot the server then it hang again.. (when it's meet > 100 concurrent user...)

we already ask the vendor to look at their CMS.. but they refuse to do so.. they are blaming the hardware ( which for us the server is FAT enough to handle company portal)

--> Processor - 2 x Pentium Xeon, 3.0GHz
Memory - 2GB (512MB x 2) Max. 12GB
OS max hardware support - 2CPU, 16GB RAM
LINUX redHAt 9


The vendor ask us to buy another server, which for us not very practical to do so. because just to handle on that big day ( which only once a year). and that might still not solve the problem if their CMS with all the mysql queries not optimize...


so how we can prove to the vendor that their cms cause the problem...

Who maintains your server? You can turn on slow query logging mechanism in MySQL to see which queries are causing the server to hang.
That way, you can even hire someone to examine if database design is optimal or not (if tables have proper indexes etc.) without even touching CMS source code.

If you can get your system administrator to do this for you (turn on slow query logging, administrators know what that is) and if you can find some other developer to look into this problem I mentioned, then you have enough proof to prove your CMS vendor that they are wrong.
Which steps you can take from there - I don't know. Good luck with the whole problem.