I was just curious -
I’m using my BBB rev C as a datalogger (among other things.) I’m going to be writing approximately 200 bytes of data to a mySQL database a minute pretty much 24x7 (somewhere around 300Kb per day I’m guessing.) I’m not going to be doing much erasing of data; maybe occasional purges of old data, but not very often. Mostly it will be used to store the sensor values, and then I’ll write a webserver front-end to access the data, do aggregation and charting, etc.
At this point, my eMMC has about 2.3GB free (I did a lot of cleanup, removing the x system, etc.) At this point, at the current write rate, theoretically I could write for around 20 years before the drive fills up.
What I’m curious about though is - knowing my current usage, and that it’s not anticipated to change very much in the future, how well will the eMMC hold up? I’ve been doing a lot of googling, but haven’t really found any write cycle information for the Kingston ke4cn2h5a on the board.
The data written to the database will be similar to:
and the table structure is: