jeudi 5 février 2015

I/O capacity with innodb_io_capacity parameter


I use hdparm to test my SSD hard drive I/O benchmark :



[root@mail ~]# hdparm -t -T /dev/xvda2

/dev/xvda2:
Timing cached reads: 12906 MB in 1.99 seconds = 6477.79 MB/sec
Timing buffered disk reads: 1650 MB in 3.00 seconds = 550.21 MB/sec


I saw innodb_io_capacity parameter for MariaDB is :



Storage type The innodb_io_capacity value
HDD 200
RAID 10 HDD 1,000
SSD 5,000
Fusion IO 10,000


Could some body please tell me which value i should use in this case ?





Aucun commentaire:

Enregistrer un commentaire