tag:blogger.com,1999:blog-9144505959002328789.post7403708003256485390..comments2024-03-28T11:39:50.622+01:00Comments on Karlsson on databases and stuff: MySQL Database cleaner 1.0 releasedKarlssonhttp://www.blogger.com/profile/04874338187076980133noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-9144505959002328789.post-89720601456898422852011-05-28T00:37:18.819+02:002011-05-28T00:37:18.819+02:00For feature request 1, also add a sleep option in ...For feature request 1, also add a sleep option in milliseconds or microseconds in between rounds and/or commits.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9144505959002328789.post-46973653984750743052011-05-28T00:19:49.321+02:002011-05-28T00:19:49.321+02:00From reading the PDF file included with the progra...From reading the PDF file included with the program download, I think this is a great program. We do the cleaning in a similar way but use shell scripts for this.<br /><br />Here are some features I was looking to add to my shell scripts, but maybe could be instead incorporated into this program:<br />1) Modify batch size and commit-interval at run time to adjust for the load on live database system on as needed basis.<br />2) Support not only deletes, but also updates. At times we need to process lots of updates in a similar fashion. New values for specific columns and primary key could be loaded into a staging table and the cleaner program could do the rest of the magic.<br />3) Down the road make this program support multiple RDBMSs.Anonymousnoreply@blogger.com