MySQL Performance: MySQL => How to tell if you are Disk IO bound

Members

Help

Home

Home » Performance » MySQL » How to tell if you are Disk IO bound

Show: Today's Messages :: Show Polls :: Message Navigator

How to tell if you are Disk IO bound [message #443]

Mon, 04 December 2006 13:40

aronrosenberg
Messages: 16
Registered: September 2006

Junior Member

I assume that the way you tell if your MYSQL server is CPU bound is by watching the cpu usage percentage in top or ps....but how do I tell if its Disk IO bound?

Report message to a moderator

Re: How to tell if you are Disk IO bound [message #444 is a reply to message #443 ]

Mon, 04 December 2006 16:39

Peter
Messages: 405
Registered: August 2006

Senior Member
Super Guru

I normally check iostat -x and see % busy for disks.

If load is IO bound one of more of them will be close to 100%

You can also check iowait column in vmstat it shows time spent waited on IO

Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/

Report message to a moderator

Previous Topic:	MySQL Manager
Next Topic:	Create INDEX blocks writes to other tables

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 6 21:29:31 EDT 2009

Total time taken to generate the page: 0.00938 seconds

.:: Contact :: Home ::.

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.