PDA

View Full Version : Should I be worried?



incka
10-17-2004, 02:46 AM
Last night: 28.20% CPU usage by mysql. Usually it's about 10%. My server emailed me last night about it. Any idea if I need a new server?

incka
10-17-2004, 02:47 AM
My server load says:

Server Load 2.02 (1 cpu) (flashing red dot)

tomek
10-17-2004, 02:54 AM
Hi Incka

Do you use MySql's query cache? It helps a lot... (MySql 4.x needed)
How much ram does your server have?
Do you have a constant server load of 2 or is this a peak value?

here's some info on server load:
http://www.crucialparadigm.com/resources/tutorials/server-administration/server-loads-explained-linux-unix.php

AndyH
10-17-2004, 03:42 AM
I wouldn't worry about it too much. Does it sit around 2 or is that a spike?

incka
10-17-2004, 04:23 AM
Just today. My ram usage is aways about 25%. Just today mysql and CPU have spiked.

AndyH
10-17-2004, 04:34 AM
Don't worry about the RAM usage until the server starts using swap memory.

How is the actual loading time of your websites? If it is fine then don't worry. :)

chromate
10-17-2004, 06:27 AM
Exactly. Use your websites at a peak usage time, if they go slow then think about a new server. Otherwise, don't worry about it. I doubt you would need a new server for your sites.

Westech
10-17-2004, 01:16 PM
Does the traffic on your sites correspond with the peaks in server load?

incka
10-17-2004, 10:06 PM
I'll check tonight.

UnitHosting
10-18-2004, 06:56 AM
You should be very worried.

What kind of CPU are you using at the moment?
Do you have daily backup enabled on your server?

When CPU/MEM is high? Log into SSH, and type top and paste the result here.

EDIT: paste the result from ps -aux from SSH as well.

incka
10-18-2004, 07:59 AM
I'll paste what the server says when I get back to my outlook.

It did say something about changing settings to stop the error if you are not worried by it...

intelliot
10-19-2004, 10:46 PM
My load average sometimes spikes to 30+ (and things slow to a crawl). Optimization tips...?

tomek
10-20-2004, 02:47 AM
My load average sometimes spikes to 30+ (and things slow to a crawl). Optimization tips...?

http://phplens.com/phpeverywhere/tuning-apache-php

Do some research on:
PHP APC Cache
mod_deflate
mod_cache
MySQL Query Cache
MySQL Server Optimization

Todd W
10-23-2004, 02:25 AM
Hey Incka,

Sounds like 1 of 2 things.

1. You are getting a TON of users to your MySQL driven sites and you have not optmized my.cnf yet.

2. You have optimized my.cnf - and you are getting a ton of users still.

If #1 you need to optimize my.cnf I don't know your server specs so I can't reccomend anything specifically but checkout the mysql samples such as my-huge.cnf and my-medium.cnf

If you are not familiar tweaking this there are places that do this for under $100 - and they will tweak it a couple times to find the "right" setting for you. I run a script that shows queries/second and each time I tweak a setting I let it go a few days then compare to previous setting, something you may want to check out if you do it yourself.

If #2 congratulations you may need a larger server soon.

-Todd

Mike
10-23-2004, 05:29 AM
What's happening with this Sean?

incka
10-23-2004, 06:09 AM
It's gone down to usual levels.