cqr213
asked on
MySQL auto purge
I have a HMI that will be installed in remote field location, collecting data in MySQL tables over time. What tools does MySQL offer where I can set up for certain tables to be purged periodically weather based on a time period or on space.
Since this machine will be stand-alone I'm just looking for a way for this MySQL to manage itself to an extent just so the hard drive doesn't fill up. we shoulnd't need more than 3 months history on data at the most.
Since this machine will be stand-alone I'm just looking for a way for this MySQL to manage itself to an extent just so the hard drive doesn't fill up. we shoulnd't need more than 3 months history on data at the most.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What's an HMI?
ASKER
Ok however I'm not familiar with PHP. Is there a way for me to do this from inside Workbench? I was hoping it was as easy as maybe doing a Scheduled task in windows or a event schedule in Workbench somehow..
HMI - Human Machine Interface
It's basically just a computer running software that controls mechanical devices via PLC's (I/O).
HMI - Human Machine Interface
It's basically just a computer running software that controls mechanical devices via PLC's (I/O).
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
So by default will tables in a MySQL schema just append to new data or does it just add until it fill up all space?