2017-11-17, 09:09 AM
Question is data logging and this not for a little time. and if he does go for sensors not just for a week or so on his testing and developement database special the logging of IOT data like sensors for a later review and sort things out he should compare in general why and what he is doing in comparison influxdb and mysql.
I hope this article helps to understand:
https://db-engines.com/de/blog_post/71
i think for the moment i leave a bit the sql sector shark did told his needs are mainly to have at a time a special information and time periods are not interesting for him. I am with data logging more interest in time periods to analyse. I think if you log a long time and keep the actual data in a array and look than in reviews for a time period say one or 2 years you will see how is the performance. For checking and lookig for servers i long time use nagios. I see in influx and grafana for our needs more advantages. If he will use Telegraph as collector on a third pc than he will see that mysql or the light version needs much more resources over the time.
I hope this article helps to understand:
https://db-engines.com/de/blog_post/71
i think for the moment i leave a bit the sql sector shark did told his needs are mainly to have at a time a special information and time periods are not interesting for him. I am with data logging more interest in time periods to analyse. I think if you log a long time and keep the actual data in a array and look than in reviews for a time period say one or 2 years you will see how is the performance. For checking and lookig for servers i long time use nagios. I see in influx and grafana for our needs more advantages. If he will use Telegraph as collector on a third pc than he will see that mysql or the light version needs much more resources over the time.