Hoe can I reduce my Avergae Disk Queue length when using MySQL


I have found th eproblem of my slow server. It seems my Average Disk Queue Length peaks at 37! Apparently it should be no more than 2!
All that is on that disk is the MySql datafile.
What I have done is made a copt of a 500MB MyIsam table and converted it to Innodb, which is now about 1 Gig.
When I run my site against the innodb table, I get very high Disk I/O to the datafile.
I have plenty of physical memory left and the cpu is not overloaded, its just the disk access thats killing my server.
I have tried changing all the parameters but cant seem to get the disk accees down.
Any Ideas what I should be changing?

Im only running less than 100 connections.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Lost any indexes while converting or they need maintenance?  Sorry but can't help you technicaly for MySql
How many harddrives do you have? If the perfmon reports 37 and you have 10 hard drives in your diskarray then your diskqueue lenght is only 3,7 ( 37 divided by number of harddrives )

-Make sure you are not doing any table scans
-Make sure you are only returning as much data you need
-Make sure you are using as narrow columns as you can
-Make sure you have correct indexes
-Make sure your indexes are not fragmented
-Make sure your indexes have high selectivity ( less then 10% )


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.