How many connection can my website have? [closed]

view story

http://stackoverflow.com – As the traffic increased my website hangs quite regularly. The page visit is now averaging 50k per day. The static page loads fine, but when the page has mysql request it takes too much time to respond. If I restarts the mysql, it will work normal for some time, say 1 hr and the response time starts to get worst. What could be the issue? I am not good at server side. Any help is appreciated. My server configuration are given below. RHEL 5.8 x64 CPU 2 cores RAM 4GB HDD 2GB Apache 2.2 PHP 5.1 MySQL 5.0 Do I need to upgrade my system. How many max connection can this configuration suppo (HowTos)