how to set up 1 server for apache, 1 for mySQL
My Apache server is:
Dual Opteron 246
2 GB Ram
250 Gb 16mb cache hdd
Centos 64bit OS
and my MySQL server is:
AMD64 3500
2 Gb Ram
250 Gb SATA HDD
Centos 64bit OS
Currently, i'm using WebHostManager/Cpanel configuration to have the Apache server using the mySQL remotely. However, I don't know why the memory of Apache is used up quickly (memory usage peaks 90% after 1 minute). Is it due to my wrong set up? please help me
Apache server status:
Server Load 0.25 (2 cpus)
Memory Used 87.7 %
mySQL process:
tons of these processes (not seen them when i was still using 1 server for all)
| 40790 | abc_abc | mysql.abc.com:60128 | abc_retry | Query | 29 | Writing to net | SELECT title, data
FROM datastore
WHERE title IN ('options', 'cron', 'forumcache', 'usergrou |
| 40791 | abc_abc | mysql.abc.com:60130 | abc_retry | Query | 27 | Writing to net | SELECT title, data
FROM datastore
the load on mySQL is very good, only the apache is overloaded (memory only, not cpu)
help me please
