MySQL Forums
Forum List  »  Performance

How To Use More Resources
Posted by: Luis Cavazos
Date: January 07, 2015 11:12AM

Hi,
I have Mysql 5.6 64 Bit Running on a 16 Core Server with 32 GB Ram. on Windows 2012 Server

it is working fine, but I have som tables with around 180 Million records, and sometime I need to update a bunch of records let say 50 Million, overall the DB responce to the rest of the clients is still fast there is almos no diference.

But I can see on the resource Monito when doing this updates it only uses about 20% of CPU and 10 MB/s io Disk. I know the capability of IO of the Disk os about 160 BM/S

How can I make Mysqld to use let say 75% of CPU and 120 MB IO Disk.
this server si Mostly for the Database.

Thanks in Advance.

Options: ReplyQuote


Subject
Views
Written By
Posted
How To Use More Resources
1746
January 07, 2015 11:12AM
746
January 07, 2015 07:14PM
1133
January 07, 2015 09:14PM
1088
January 07, 2015 11:21PM
702
January 07, 2015 11:42PM
784
January 08, 2015 05:48PM
845
January 09, 2015 02:39PM


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.