By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,810 Members | 783 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,810 IT Pros & Developers. It's quick & easy.

Mysql Update Speeds

P: n/a
Hello,

I know mysql update queries can only utilize one index, making them
slow in some cases.

My update are taking about 3 hours, joining 2 tables on their primary
keys. (table sizes about 1 mil in 1 table, 2 mill in the other).

My real question though is, mysql is only using about 10% of the cpu
whilst running this update query (on a linux server), what can I do to
let it run flat out at 100%, and presumably finish 10 times quicker?

Or isnt it as simple as that, is hard drive access the bottle-neck?
Select queries always seem to run a lot quicker and use a lot more of
the cpu.

Many thanks,

Paul
Jul 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Paul wrote:
Or isnt it as simple as that, is hard drive access the bottle-neck?
Select queries always seem to run a lot quicker and use a lot more of
the cpu.


When you update, you will use the hard drive propably a lot of times(for
writing), but also for reading (to search correct rows).

When you run a select, you propably use some indexes, which means less
reading and more comparing (more cpu usage).

Also writing is usually always slower than reading, so I think it really
is that simple. Your hard drive is the bottle-neck.
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.