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?