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. Thanks much! Chris PS - The data written to the database will be similar to: 25,t,75.20 25,h,47.00 26,t,73.40 26,h,40.00 28,t,69.80 28,h,38.00 29,t,77.00 29,h,36.00 30,t,73.40 30,h,39.00 31,t,75.20 31,h,40.00 32,t,71.60 32,h,45.00 48,t,73.40 48,h,40.00 and the table structure is: mysql> describe sensorData; +-------------+--------------+------+-----+-------------------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+-------------------+-------+ | sensorNum | int(2) | YES | | NULL | | | sensorType | char(1) | YES | | NULL | | | sensorValue | decimal(4,2) | YES | | NULL | | | timestamp | timestamp | NO | | CURRENT_TIMESTAMP | | +-------------+--------------+------+-----+-------------------+-------+ mysql> select * from sensorData order by timestamp desc limit 16; +-----------+------------+-------------+---------------------+ | sensorNum | sensorType | sensorValue | timestamp | +-----------+------------+-------------+---------------------+ | 32 | t | 71.60 | 2014-06-29 15:17:54 | | 32 | h | 45.00 | 2014-06-29 15:17:54 | | 48 | t | 73.40 | 2014-06-29 15:17:54 | | 48 | h | 40.00 | 2014-06-29 15:17:54 | | 30 | t | 73.40 | 2014-06-29 15:17:53 | | 30 | h | 39.00 | 2014-06-29 15:17:53 | | 31 | t | 75.20 | 2014-06-29 15:17:53 | | 31 | h | 41.00 | 2014-06-29 15:17:53 | | 28 | t | 69.80 | 2014-06-29 15:17:52 | | 28 | h | 39.00 | 2014-06-29 15:17:52 | | 29 | t | 75.20 | 2014-06-29 15:17:52 | | 29 | h | 37.00 | 2014-06-29 15:17:52 | | 25 | t | 75.20 | 2014-06-29 15:17:51 | | 25 | h | 47.00 | 2014-06-29 15:17:51 | | 26 | t | 73.40 | 2014-06-29 15:17:51 | | 26 | h | 39.00 | 2014-06-29 15:17:51 | +-----------+------------+-------------+---------------------+ -- For more options, visit http://beagleboard.org/discuss --- You received this message because you are subscribed to the Google Groups "BeagleBoard" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
