website suddenly slow! please help

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

I am the webmaster of a website which uses php fusion mysql and apache
server.All was fine till yesterday and suddenly my site has slowed
down for no apparent reason.Could someone please give me ideas of what
should be by troubleshooting steps?

Thanks for your help

Re: website suddenly slow! please help

On Sun, 30 Dec 2007 10:27:11 -0800 (PST), pc put finger to keyboard
and typed:

Quoted text here. Click to load it

If a database-driven site suddenly slows down for no apparent reason,
what's often the cause is that some of your commonly used tables are
getting too large. If you're storing continuously generated data (such
as logs or transaction records) in the database, consider archiving
older data to a table that doesn't get accessed regularly, so that the
commonly used tables stay small. Also, check your SQL structure, and
make sure that everything you regularly select against is indexed.

If you have shell access to the server, run 'top' and see if that
shows anything. It's also worth installing 'mytop' to get an insight
into what MySQL is doing. If you can't do that, then you can still get
a reasonable idea of what's going on by repeatedly refreshing the
"show processes" option in phpMyAdmin.

-- - What does your surname say about you?
"We were meant to live for so much more"

Site Timeline