Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
how to reducethe size of cel.MYD file --Asterisk
- Thread starter actbala
- Start date
DoubleDriveLine
IS-IT--Management
Your best bet is to ask that question at IncrediblePBX forums
VOIP-Info.org
There are 10 kinds of people in the World.
Those that understand Binary and those that don't.
VOIP-Info.org
There are 10 kinds of people in the World.
Those that understand Binary and those that don't.
If you have no use for data in the cel database table, you should consider changing the Asterisk configuration to disable CEL events. That can be done by "enable=no" in the cel.conf (or an included configuration file).
To delete the CEL events from the database table and reclaim the space used by the database table, you should
1. Login into mysql as root or a user that has rights to modify the database (e.g., if the database name is asteriskcdrdb, you would use "mysql -p -u root asteriskcdrdb")
2. Delete all rows in the cel table ("DELETE FROM cel;")
3. Optimize the database table to reclaim the space ("OPTIMIZE TABLE cel;")
To delete the CEL events from the database table and reclaim the space used by the database table, you should
1. Login into mysql as root or a user that has rights to modify the database (e.g., if the database name is asteriskcdrdb, you would use "mysql -p -u root asteriskcdrdb")
2. Delete all rows in the cel table ("DELETE FROM cel;")
3. Optimize the database table to reclaim the space ("OPTIMIZE TABLE cel;")
- Thread starter
- #4
- Status
Similar threads
- Question
