Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

My server get very slow as soon at my gstat output shows high amount of busy%.

Look at the gstat results:

gstat enter image description here

Here is the top -m io -o total and the gstat commands running at the same time:

enter image description here

How can I fix that? Or at least look, which process is flooding my disk?

Server informations:

OVH dedicated server

# uname -a
FreeBSD 8.2-RELEASE FreeBSD 8.2-RELEASE #0: Thu Feb 17 02:41:51 UTC 2011     root@mason.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC  amd64
share|improve this question

1 Answer 1

The ms/w column in gstat shows that your i/o latency is through the roof. Are you sure that's a dedicated physical server and not a VPS? Your top output suggests that it's mysql (it's the only process with any reads or writes) - I would strongly suspect it's the nature of your queries or size of your db.

Have a look at this: Profiling tools, tips and tricks And this mysql tuning thread - turn on your slow queries log and look at it. You have 6g of ram you're not using at all, you can crank some of the parameters up in my.cnf to give mysql more of that.

You should absolutely have your data and binary logs on separate physical drives if possible (but you only have one drive in there....)

share|improve this answer
    
Yes, I am sure its not a VPS (:-p) thank you so much for your recommendations. I will give them a try! –  Lucas Feb 16 at 17:45
1  
Yould also be a crappy myaql configuration. At the end, though, SSD or a bunch of SAS discs are the solution - there is a limit what you can do with a crappy SATA disc optimized for low price and.... size, not speed. –  TomTom Feb 16 at 17:53
    
"crappy SATA disc optimized for low price" - love it. Got burned a few years past... shit for servers when IO start increasing. –  ETL Feb 16 at 21:15

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.