Periodically Delete CDRs Older than N Months

FreePBX Version : 12.7.5-1805-3.sng7

Before setting up cron for automated deletion of CDR, i tried to delete CDR by following these ;

mysql
use asteriskcdrdb;
DELETE from cdr WHERE calldate < ‘2018-06-05 00:00:00’;

Everything worked perfectly, as expected . before setting up cron job for automated job, i tried to repair as well optimize database as suggested in this thread but after executing these ,
repair table cdr;
repair table cel;
optimize table cdr;
optimize table cel;

| asteriskcdrdb.cdr | repair | note | The storage engine for the table doesn’t support repair | ,

I am getting this message . I tried to lookup into things and it seems InnoDB storage type is used , we can’t use repair or optimize for InnoDB type .

To follow this script either i have to convert to MyISAM to use repair or optimize command , or should i leave it to default InnoDB and ignore repair or optimize ?

Please suggest .

Thank you

Sorry for bumping old thread for my query .