MySQL Forums
Forum List  »  Performance

update performance problem with fast HDD&CPU
Posted by: Hoguw Kim
Date: November 14, 2008 04:02AM

Hello.

I wrote a test program.
It inserts 500000 rows and updates 500000 rows with random order at a table.(5 threads, 100000 data each, each thread has a connection) and Table .MYD file size is about 55M Bytes.

It marks about 10000 query / second.
CPU usage was 30% & HDD usage was just 2%.
Why CPU & HDD idle power is not used?

I ran two test programs simultaneously. Each one access different table. Then It marks about 20000 query / second. (I check it at 'mysql administrator' health tab, add a ^[com_update] graph)
Is there a limit with one table?

Machine spec : quad core 2 CPU, 4G RAM, SAS 15000rpm HDD, windows 2003x64, mysql 5.0.67 windows x64

Options: ReplyQuote


Subject
Views
Written By
Posted
update performance problem with fast HDD&CPU
3252
November 14, 2008 04:02AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.