MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: Very high disk utilization by mysql server during reads.
Posted by: Aftab Khan
Date: July 07, 2012 06:07AM

>Key_buffer_size=5G, innodb_buffer_pool_size=24G

The combine size should be < 80% of your RAM. How big are INNODB tables that you have? If your INNODB buffer pool is too big then you may try to reduce its size to allow O/S to cache myisam table's data

http://mysqlopt.blogspot.co.uk/2012/01/mysql-server-tuning.html

> Index_length: 3141316608

So you may decrease key_buffer_size to 1G

>`field1` bigint(20) NOT NULL DEFAULT '0',
You can use INT UNSIGNED

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Very high disk utilization by mysql server during reads.
4021
Shantanu B
July 05, 2012 12:49PM
Re: Very high disk utilization by mysql server during reads.
1506
Aftab Khan
July 06, 2012 02:51AM
Re: Very high disk utilization by mysql server during reads.
1374
Shantanu B
July 06, 2012 10:38AM
Re: Very high disk utilization by mysql server during reads.
1357
Aftab Khan
July 07, 2012 06:07AM
Re: Very high disk utilization by mysql server during reads.
1253
Rick James
July 07, 2012 12:34PM
Re: Very high disk utilization by mysql server during reads.
1174
Shantanu B
July 09, 2012 01:59PM
Re: Very high disk utilization by mysql server during reads.
1208
Rick James
July 10, 2012 09:47AM


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.