Re: Very high disk utilization by mysql server during reads.
Eventually I will be using this MyISAM table for searches. Is Innodb a good candidate for the searching? How much performance improvement do you expect if I use Innodb engine instead of Myisam?
How about partioning the myisam table using field1 in the table. Will it improve performance? Something like following -
PARTITION p0 VALUES LESS THAN (1990),
PARTITION p1 VALUES LESS THAN (1995),
PARTITION p2 VALUES LESS THAN (2000),
PARTITION p3 VALUES LESS THAN (2005)
Thanks guys for your inputs.
Subject
Views
Written By
Posted
4021
July 05, 2012 12:49PM
1506
July 06, 2012 02:51AM
1374
July 06, 2012 10:38AM
1357
July 07, 2012 06:07AM
1253
July 07, 2012 12:34PM
Re: Very high disk utilization by mysql server during reads.
1173
July 09, 2012 01:59PM
1208
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.