10/31/2022 0 Comments Dod cac on a macBut really, today, you buy SSD and go for size on them - they are so superior in IOPS capabilities, it makes no sense to fight this game with SAS drives.Īnd yes, your IOPS numbers do not look bad for the hardware. I have seen databaes with 100+ discs just to get the IOPS they needed. Anything you do higher up in the kernel - better know you can live with the negative side effects.Īt the end, databases need IOPS, and you may be surprised to see how tiny your setup is compared to some others here. The Raid controller in write back mode will do that - confirm the write as flushed even if it is not - but it can do so because the BBU is assumed to safe the day when power fails. The only kernel tunes you could do would invalidate your transactional integrity - partially you CAN get away with that. THe log file needs to be WRITTEN for basic ACID conditions to be guaranteed. Any decent database will do a lot of IOPS and flush the buffers. Your SAS discs were a mediocre choise to start with (too large to get a lot of IOPS) For a higher use database (more smaller discs would mean a lot more IOPS), but at the end SSD are the game changer here. Phyiscal spinning disc just can not keep up with the IOPS capabilities of discs. This is the reason SSD are killers in DB space and so much cheaper than any SAS drive. Result? You can do around 60.000 (that is 60 thousand) IOPS per drive. Plug in SATA SSD - enterprise level, like the Samsung 843T. Yes, as a hard disc - even SAS - has a head that takes time to move. If doing a hardware upgrade, is the number of disks key to performance?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |