Hiya Folks, I have a very serious performance issue with my site, Kedoya.com . It's a RSS aggregator site where users can subscribe, rate and comment to news feed. Fresh news feed is being added on hourly basis and my site is hosted on a dedicated server. Due to it's nature, the database size (mysql) is increasing everyday , this make the site load very slowly. Here is my dedicated server specification : # Intel Celeron 440 2.0Ghz 512K Cache 800Mhz FSB # 1GB DDR2 RAM # 250GB SATA 3GBPS Hard Drive # 2000GB Bandwidth What should I do to make Kedoya.com run fast?. Please advise. Thx!,
More RAM and a faster processor will always help but what about your mysql query strings? Are they optimised?
Log into your shell then do the following [user@hostname ~]# ps aux It should display all the processes, kill the ones you dont want.
How often are you processing the feeds? It could be that scanning all the feeds is killing your CPU aswell. If you discover that MySQL is the bottleneck jump over to the danga.com site and check out memcached: http://www.danga.com/memcached/ It allows you to pull data from the database and store the results in memory, so next time all you need to do is get it from memcached instead of hitting the db. Its used by some of the biggest sites in the world and is completely open source. Hope this helps