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

Question

I want to store a large number of Time Series (time vs value) data points. I would prefer using MySQL for the same. Right now I am planning to store the time series as a Binary Blob in MySQL. Is this the best way, what would be the best approach.

Answer 1

You should store your values as whatever type they are (int, boolean, char) and your times as either date, or int containing the UNIX timestamp, whatever fits your application better.

Answer 2

If you want to process the information in any way using mysql you should store it as a date type, numeric type . The only scaling issue i see (if you only intend to store the information) is extra disk size.