Website shutdown because of 40% CPU load

[toxicious]

Thank you for that tip, will begin work on optimization this week

 

[bluefrogx]

Could also implement some disk caching for frequently used queries as well. Load doesn't necessarily have to be CPU/RAM related, many times my load on own servers are more of an IO thing

 

[Lock Down]

He is on shared and can't really do much. I would suggest instead of the host telling you too many resources, make them give you output from htop and mytop showing what resources your site is using and by which scripts and mysql commands...

Too many shared hosters do this when you really aren't using any resources....

You can also load phpsysinfo utility to write a file or monitor the system online for memory, processes and cpu usage.

 

[toxicious]

Yeah and my current host (the one I had before I tried to move to paid hosting) doesn't have load monitoring built into cPanel.

Though I was wondering about one thing, since I have access to phpMyAdmin I can check the Status tab of the server, but since I am on shared, I guess the stats there are for the whole MySQL server and not just my db?

 

[UpReseller]

It can be happended with your hosting, because a few processors will eat resource by php script. Did you myself write application?

 

[toxicious]

Yeah I wrote the script myself.

 

[Lock Down]

You should really upload phpsysinfo

And change the plugin from false to PS since you have no ssh access in the config file. Works on my shared service.

 

[toxicious]

I did, here:
http://www.gaddons****/phpsysinfo/

Though I am not sure what to do with that info.

My current host actually sent me this info:
http://pastebin.com/5LArTQj7

:D

So now I at least know which queries are "slow"

 

[Lock Down]

I would have to say that your database must be in the millions or they have Mysql misconfigured if this command took 9+ seconds to run.

Count: 1 Time=9.03s (9s) Lock=1.00s (1s) Rows=0.0 (0), gaddons_website[gaddons_website]@localhost

INSERT INTO users (email) VALUES ('S')

The info should refresh showing you what and if any php scripts are using too many resources...

 

[toxicious]

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 :/

 

[bluefrogx]

Have you tried indexing your database?

 

[toxicious]

Please explain a bit what that means

 

[bluefrogx]

http://net.tutsplus.com/tutorials/other/top-20-mysql-best-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.