lsuonline / lsuce-block_quickmail

6 stars 37 forks source link

Best way to clear old data from block_quickmail_msg_recips table? #61

Open codeulike opened 1 year ago

codeulike commented 1 year ago

Hi, I have 26 million rows in the mdl_block_quickmail_msg_recips table, going back 10 years, its taking up 3.5 gigs of space. Whats the best way to clean it out? Can I just delete anything older than (say) 2 years from the table directly in MySql? Or is there an official way to automatically clean up old history?