What is the best way to store a Time Series in MySQL?

Question

I want to store a large number of Time Series data points (time vs value). I would rather use MySQL for the same. Right now, I plan on storing time series as a binary block in MySQL. This is the best way, what would be the best approach.

Answer 1

You should store your values ​​either in any type (int, boolean, char), or as a date, or int containing a UNIX timestamp, which is best for your application.

Answer 2

mysql, , . , ( ), .

Answer 3

, MySQL, - (- > SQL).

, , , / , MySQL , blob, blob / / , : .

, , . , / . NoSQL , , , , (, / db Riak)

Answer 4

MySQL . . , LineString. , . , " LineString ". :

-- if you see a blob, use Convert( AsText(...) using 'utf8')
SELECT AsText(GeomFromText('LineString(1 1, 2 2, 3.5 3.9)'));

:

https://dev.mysql.com/doc/refman/5.1/en/spatial-extensions.html https://dev.mysql.com/doc/refman/5.1/en/populating-spatial-columns.html