I have a flow that insert data into mySQL. But I am afraid what will happened if the disk is full.
I can't find any setting inside the mySQL workbench. (pls let me know if I can set anything.)
My plan is to use node-red to keep reading the total number of rows, and if it is above 100M rows, then, delete the last 10k rows. But the return will be slow and use lots of computation time.
My another plan is to use Influx, but I have to rebuild the data.
Is there any better suggestion? thx