MySQL Forums
Forum List  »  MyISAM

Write Buffering / Write Cache to reduce SSD / CFast Flash wearing
Posted by: Michael Uray
Date: January 22, 2018 06:20AM

I ran a MySQL MyISAM database engine for a measurement data recording system which writes new values every second, sometimes more often.

After a few weeks the CFast (https://en.wikipedia.org/wiki/CompactFlash#CFast) card died due to to many write cycles.
According to the data sheets are 691.2 TBW allowed on this flash card, but only 3000 Erase/Write cycles:
https://www.br-automation.com/en-ca/products/industrial-pcs/panel-pc-3100-multi-touch/cfast-cards/5cfast256g-10/#techdata

There are a lot of measurement values which get recorded, but the recording depends on a change of the measured value and a minimum recording time delay, which is different on each datapoint.

There is one table for each recording value which contains just two columns:
DateTime: doubleunsigned
Value: 2-8 Byte, depending on the datapoint to record

I think there gets a lot of small data recorded very often, what often causes the flash memory to delete flash blocks and rewrite them.

Is there any way to configure a write buffering / write cache, that changes only get written if they are bigger than xxx bytes (which I would configure to the block size of the flash memory) and / or any option that changes get written at least every yyy seconds if I do not exceed the xxx bytes within this time?

Options: ReplyQuote


Subject
Views
Written By
Posted
Write Buffering / Write Cache to reduce SSD / CFast Flash wearing
354
January 22, 2018 06:20AM


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.