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 |