Website shutdown because of 40% CPU load

[bluefrogx]

Have you tried indexing your database?

[toxicious]

Please explain a bit what that means

[bluefrogx]

http://net.tutsplus.com/tutorials/ot...est-practices/

Easiest way is to take the slow queries and type "EXPLAIN <SLOW QUERY>" in phpMyAdmin. It will execute your query step by step and benchmark each step so you can find out which one is the bottleneck

[toxicious]

Sounds awesome, will do that.

[Lock Down]

Yeah I need to ask them about it, since there is no other way of inserting data. The same with the insert of the mirrors, it takes several seconds.

You mean that I can see in phpsysadmin specific script info?
Couldn't see anything when I looked :/

No it is not for mysql. Use something like Mysql-front and the tunneling for shared hosts. Choose processes to see all waiting and executing mysql commands and their length.

But adding the explain could help.

[bluefrogx]

Or you could type show processlist; in phpmyadmin, does the same thing really.

[Lock Down]

Difference is one has to used through the browser and other is a windows desktop program.