VOS3000 Data Maintenance & AutoโCleanup: Important Database Management Guide
As your VOS3000 softswitch processes thousands of calls daily, the MySQL database grows continuously. Without proper VOS3000 data maintenance, old CDRs, logs, and reports consume disk space, slow down queries, and can eventually cause system instability. This guide covers everything you need to know about managing VOS3000 data โ from manual cleanup to fully automated maintenance routines.
By the end of this article, you’ll know how to keep your database lean, fast, and reliable for years of operation.
Table of Contents
Why VOS3000 Data Maintenance Matters
VOS3000 stores data in multiple MySQL tables that grow daily:
- CDR tables โ one per day (cdr_YYYYMMDD) โ can grow to gigabytes per month under heavy traffic.
- System logs โ record every user action and system event.
- Payment records โ all recharge and adjustment history.
- Alarm history โ past alarms and notifications.
- Report data โ preโcomputed summaries for quick access.
Without cleanup, you risk:
- Running out of disk space (causing MySQL crashes).
- Slow CDR queries (waiting minutes for results).
- Backup files becoming too large to handle.
Understanding VOS3000 Data Storage Structure
VOS3000 organizes data into separate tables by type and date. This design makes maintenance easier โ you can drop or archive entire tables without affecting current operations.
CDR Tables
Located under “System Management > Data Maintenance > CDR Tables”. Each table name ends with a date suffix, e.g., cdr_20250309. The “Data volume” column shows the number of records. Doubleโclick any table to view its contents.
System Log Tables
Found under “System Management > Data Maintenance > System Log Tables”. These record all user activities โ logins, configuration changes, etc. They’re essential for audits but can be purged after a retention period.
History Alarm Tables
Under “System Management > Data Maintenance > History Alarm Tables”. Stores past alarms. Once resolved, alarms move here from current alarm list.
Payment Record Tables
Under “System Management > Data Maintenance > Payment Record Tables”. All financial transactions are stored here permanently or until purged.
Data Report Tables
Under “System Management > Data Maintenance > Data Report Tables”. Preโgenerated reports (daily summaries) โ can be safely deleted if you regenerate reports on demand.
Other Income Report Tables
Under “System Management > Data Maintenance > Other Income Report Tables”. Contains package rent, monthly fees, and other nonโcall income records.
Manual Data Cleanup Methods
For oneโtime or occasional cleanup, you can manually delete old data through the web interface:
- Navigate to System Management > Data Maintenance.
- Select the table category (e.g., CDR Tables).
- Click Filter to show all tables.
- Check the boxes next to tables older than your retention period.
- Click Delete and confirm.
โ ๏ธ Warning: Deleted data cannot be recovered. Ensure you have verified backups before deleting anything.
Automating VOS3000 Data Cleanup – VOS3000 Data Maintenance
Manual cleanup is errorโprone. VOS3000 includes a powerful autoโcleanup feature that automatically removes old data based on your rules.
Enabling AutoโCleanup
Go to System Management > Data Maintenance > Automatically Cleanup. Here you can configure retention periods for each data type:
- CDR tables โ keep for X days, then delete.
- System log tables โ keep for X days.
- History alarm tables โ keep for X days.
- Payment record tables โ keep for X days (be careful โ financial records may need longer retention for legal reasons).
- Data report tables โ keep for X days.
- Other income report tables โ keep for X days.
You can also enable automatic cleanup of:
- Accounts โ delete accounts that have been inactive/expired for X days.
- Gateways โ delete gateways belonging to deleted accounts.
- Phones โ delete phones belonging to deleted accounts.
How AutoโCleanup Works
Once enabled, a background process runs daily (typically at lowโtraffic hours) and:
- Identifies tables older than the configured retention period.
- Drops those entire tables (fastest method).
- Logs the action in system logs for audit.
- If configured, deletes orphaned accounts/gateways/phones.
โ ๏ธ Important: Autoโcleanup deletes entire tables, not individual rows. This is extremely fast and efficient but means you cannot keep partial months โ it’s all or nothing per table.
Recommended Retention Periods – VOS3000 Data Maintenance
Based on typical VoIP operations, here are sensible starting points:
| Data Type | Retention Period | Reason |
|---|---|---|
| CDRs | 90 days | Enough for customer disputes and traffic analysis; older data can be archived externally. |
| System logs | 30 days | Security audits rarely need older logs; export if longer retention required. |
| History alarms | 60 days | Alarm patterns over two months help identify recurring issues. |
| Payment records | 365 days (or longer for compliance) | Financial records may need 1โ7 years depending on local laws โ adjust accordingly. |
| Data reports | 30 days | Reports can be regenerated from CDRs if needed. |
Backup Strategy Before Cleanup – VOS3000 Data Maintenance
Before enabling autoโcleanup or running manual deletes, ensure you have reliable backups:
- Daily mysqldump of the entire VOS3000 database (compressed).
- Binary logs for pointโinโtime recovery (if you need to restore to a specific moment).
- Offโsite storage โ keep backups on a different server or cloud storage.
Test your backups regularly by restoring to a test environment.
Monitoring Disk Space
Even with autoโcleanup, monitor disk usage:
- Use System Management > Server Monitor to see disk usage trends.
- Set up Disk Alarm under Alarm Management to notify you when disk usage exceeds thresholds (e.g., 80%, 90%).
- Check MySQL data directory size periodically:
du -sh /var/lib/mysql
Advanced: Archiving Old CDRs
If you need to keep CDRs longer than autoโcleanup allows, consider archiving:
- Export old CDR tables to CSV or SQL files.
- Compress and store them in a secure location.
- Delete the tables from the live database (either manually or via autoโcleanup).
- If you need to query archived data, import into a separate reporting database or use commandโline tools.
VOS3000 does not include builtโin archival tools, but you can script this using mysqldump and cron.
Frequently Asked Questions (VOS3000 Data Maintenance)
Will autoโcleanup delete accounts that still have active phones?
No. Autoโcleanup only deletes accounts that have been expired and have no associated active phones, gateways, or bind numbers. It checks dependencies before deleting.
Can I recover data after autoโcleanup deletes it?
Not from the live system. You must restore from backups if you need deleted data. This is why testing your backup restoration process is critical before enabling autoโcleanup.
Does deleting CDR tables affect current calls?
No. VOS3000 writes CDRs to a temporary table and moves them to the daily table after the call ends. Deleting old tables has no impact on ongoing calls.
Why are my CDR tables not being deleted even though autoโcleanup is enabled?
Check that the retention period is set correctly and that the cleanup process is running (system logs will show cleanup actions). Also ensure that the tables are indeed older than the retention period โ autoโcleanup runs daily, so tables become eligible only after the configured number of days have passed since their creation.
Can I keep payment records forever while autoโdeleting CDRs?
Yes. Each data type has independent retention settings. Set payment records to a high value (e.g., 3650 days) and CDRs to a lower value (e.g., 90 days).
Conclusion
Proper VOS3000 data maintenance ensures your softswitch runs smoothly, queries stay fast, and disk space never becomes a crisis. Whether you prefer manual control or fully automated cleanup, VOS3000 provides the tools you need. Start with conservative retention periods, monitor the results, and adjust as you gain confidence.
Need help setting up data maintenance or recovering from a disk space emergency? Contact us on WhatsApp: +8801911119966
Further Resources
- VOS3000 Official Site
- VOS3000 Official Blog
- VOS3000 Downloads
- Multahost Blog
- How to Backup/Restore VOS3000 MySQL Database
- VOS3000 Server Overview
![]() | ![]() | ![]() |














