Re: random-access I/O
Compressing has improved definitively the read speed so it worth's it to have it despite the decrease on loading speed.
yes, the IO test was done at the same time in order to ensure that the HD is not overloaded. If it was it would not be able to achieve such high speeds. What I did was basically I copied very large files from and to those disks.
It is a linux server and I have RAID 10 for the disks that are used by MySQL.
Last question, is this possible to be created due to the memory limications on innodb settings? Can this be a result of MySQL having not enough memory to get all the records? Is there any other tests that I can do, or something else to look to?
Subject
Views
Written By
Posted
3587
January 31, 2012 03:50AM
1084
January 31, 2012 08:25PM
1023
February 01, 2012 05:19AM
987
February 03, 2012 01:41AM
1245
February 03, 2012 02:39AM
1070
February 03, 2012 11:08PM
Re: random-access I/O
1014
February 04, 2012 08:54AM
1536
February 05, 2012 12:56PM
1034
February 08, 2012 07:22AM
1494
February 08, 2012 11:17PM
927
February 09, 2012 05:30AM
1016
February 09, 2012 01:48AM
846
February 09, 2012 01:58AM
1061
February 09, 2012 10:52AM
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.