I need help in managing the influxdb database. As i have to create new databases every week, and its growing and growing.
If i create a database “test_database” for a customer. In this database i am putting the data of 10 different sensors like dht11,dht22,bme280 etc. Now all 10 sensors are measuring one common parameters that is temperature.
I am managing like this
sensor temperature1 temperature2 temperaure3 . . . . . . . . . .temperature10
problem with this structure is i have to remember every time, which temperature value belongs to which sensor.
Is there any good method??? Its really getting worse for me, as databases growing bigger and bigger.