I have around 500 tables and each table is for a specific device. every table is getting full with data that comes every 3 minutes. Now I need to store averages of different timeframes of one same column(data) in tables .
timeframes are 10 minutes, 1 hour , 12 hour , 24 hour ,1 month.
Is mysql events good for this purpose? If yes how many of them is required , I mean should I create a table called 10 minute averages with 500 columns with one event or divide them into 5 tables with 100 column and with 5 events? in second case there would be 25 events
If not what is the better solution? as you see these are datacentric jobs.
Thanks a lot.