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 .