Vicidial Deleting old Call Logs
VICIdial is an enterprise class, open source, contact center suite in use by many large call centers around the world. VICIdial has a full featured predictive dialer. It is capable of inbound, outbound, and blended phone call handling.
MySQL is an open-source relational database management system (RDBMS),
MariaDB is a fork of the MySQL database management system.
Vicidial use either mysql or mariadb as there default database software.
Purpose of this Article:
Over the years you might be running the vicidial which will save all the data like users call logs, Leads log, recording links, agent status, Reports etc, which will fill the database and disk space, In that scenario you might want to delete old data or Flush all data in vicidial kind of factory reset the vicidial.
In this blog post i have provide steps to delete old data in vicidial database, you can also use the same commands to flush all date.
I have Video tutorial for the same steps mentioned in this blog, refer below link
Steps To delete or Flush Old data
Step 1: Login to Mysql/mariadb
SSH to the server using the Putty
login to mysql by typing
mysql -ucron -p1234
Step 2: Select the Database Asterisk
--copy paste in mysql cli--
Step 3: Command to Check Space Used by Asterisk databasecopy paste the below command in mysql cli
SELECT table_schema AS "asterisk",
ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Size (MB)"
GROUP BY table_schema;
Step 4: Command to check disk space consumed by each tables
Copy paste the below command to check the space occupied by each table in vicidial
SELECT table_name AS "Table",ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Size (MB)"FROM information_schema.TABLESWHERE table_schema = "asterisk"ORDER BY (data_length + index_length) DESC;
you will see output similar to below picture,which shows space consumed by each tables in vicidial
In this step we will be deleting the data's of each table which is one year old, if you want to delete all data mention the date in which the vicidial is installed.
Deleting each table data for the date on or before 2019 dec 23:59
Run the below command in mysql console to delete old logs ie before DEC31-2019
Note: change the date as per your requirement
DELETE FROM vicidial_url_log WHERE url_date < '2019-12-31 23:59:00';optimize table vicidial_url_log;
DELETE FROM call_log WHERE start_time < '2019-12-31 23:59:00';optimize table call_log;
DELETE FROM vicidial_dial_log WHERE call_date < '2019-12-31 23:59:00';optimize table vicidial_dial_log;
DELETE FROM vicidial_agent_log WHERE event_time < '2019-12-31 23:59:00';optimize table vicidial_agent_log;
You need to run the Step 5 for each and every table which you want to delete of Flush data.
For Professional support reach me at skype:striker24x7