Database Speed Issues

     Database speed issues may or may not be resolved tomorrow with maintenance.

     The preferred way of using this drive is to invoke a feature called Atomic Writes.  What that does is it bypasses cache on a write and writes directly to flash memory eliminating the need for the database to do a double write while still insuring data integrity.

     The challenge is that drivers have not been officially supported for these drives since Sans Disk bought them and that was kernel release 3.6.x and we’re on 5.10.x.  However, a volunteer effort has brought the drivers forward for kernel 5.10.x but aren’t well tested.  And while I’ve located the drive code I still have not found the fusion I/O file system tools yet.

     Tomorrow the hardware issues will be addressed but the software may or may not.

Fusion I/O Flash Drive Hardware Work Friday March 5th

     The Fusion I/O Flash drive that Amazon first told me would arrive on March 5th, then updated and said it will arrive between March 5th and March 12th, arrived today.

     I will be installing it on Friday evening.  During this time most services will be unavailable for probably about 1/2 hour starting around 11PM.  When completed, this should resolve the database bottleneck.