homepage Welcome to WebmasterWorld Guest from 54.197.147.90
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
Forum Library, Charter, Moderators: coopster & jatar k

PHP Server Side Scripting Forum

    
Server over load because of Mysql
which cache to use
showtime




msg:3406865
 1:02 am on Jul 28, 2007 (gmt 0)

Hi

i have a website use php and mysql with lots of dynamic pages.

My server over loads in busy hours.

I want to use cache for dynamic pages. But dont know to much about it.

I made some search i see some scripts as

phpcache lite

php APC

eAccelerator

which is better any suggestions?

Thanks

 

StudioKraft




msg:3406902
 3:21 am on Jul 28, 2007 (gmt 0)

Hello,

I've used eAccelerator with success for busy sites - the one downside to this cache system is that its directory apparently needs to be deleted of all cached files before restarting Apache. This is one step that is easily forgotten without a special script to do it automatically and can be cumbersome.

The first thing that you would want to do before adding any cache system is to see if/how you can optimize your database queries. Use MySQL's EXPLAIN function to see how well a query is performing:

[dev.mysql.com...]

Usually, adding indexes on fields that are queried often helps in the overall performance of the MySQL-based web site, but the queries themselves may be able to be rewritten for better performance.

Hope this helps,

SK

[edited by: coopster at 9:32 pm (utc) on July 28, 2007]
[edit reason] changed link to authoritative domain [/edit]

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved