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 x64CPU 2 coresRAM 4GBHDD 2GBApache 2.2PHP 5.1MySQL 5.0Do I need to upgrade my system. How many max connection can this configuration support.I user php with codignator, with db configuration$db['default']['dbdriver'] = 'mysql';$db['default']['dbprefix'] = '';$db['default']['pconnect'] = FALSE;$db['default']['db_debug'] = TRUE;$db['default']['cache_on'] = FALSE;$db['default']['cachedir'] = '';$db['default']['char_set'] = 'utf8';$db['default']['dbcollat'] = 'utf8_general_ci';$db['default']['swap_pre'] = '';$db['default']['autoinit'] = TRUE;$db['default']['stricton'] = FALSE;
How many connection can my website have?
php;apache;mysql;apache2;linux