MariaDB [asterisk]> delete from vicidial_api_urls;
Query OK, 2107654 rows affected (0.028 sec)
MariaDB [asterisk]> SELECT table_schema, table_name, ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS total_size_MB FROM information_schema.tables GROUP BY table_schema, table_name ORDER BY total_size_MB DESC LIMIT 10;
+--------------+------------------------------------+---------------+
| table_schema | table_name | total_size_MB |
+--------------+------------------------------------+---------------+
| asterisk | vicidial_url_log | 600.17 |
| asterisk | vicidial_api_log | 329.22 |
| asterisk | vicidial_list | 180.85 |
| asterisk | call_log | 105.10 |
| asterisk | vicidial_agent_latency_log_archive | 93.64 |
| asterisk | vicidial_dial_log | 81.70 |
| asterisk | vicidial_carrier_log | 64.72 |
| asterisk | recording_log | 59.82 |
| asterisk | vicidial_log_extended | 54.95 |
| asterisk | vicidial_log | 49.01 |
+--------------+------------------------------------+---------------+
10 rows in set (0.019 sec)
MariaDB [asterisk]> delete from vicidial_api_urls; Query OK, 6 rows affected (0.002 sec)
MariaDB [asterisk]> select * from vicidial_api_urls limit 3\G; Empty set (0.000 sec)
ERROR: No query specified
MariaDB [asterisk]> SELECT table_schema, table_name, ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS total_size_MB FROM information_schema.tables GROUP BY table_schema, table_name ORDER BY total_size_MB DESC LIMIT 10;
+--------------+------------------------------------+---------------+
| table_schema | table_name | total_size_MB |
+--------------+------------------------------------+---------------+
| asterisk | vicidial_url_log | 600.18 |
| asterisk | vicidial_api_log | 329.22 |
| asterisk | vicidial_list | 180.85 |
| asterisk | call_log | 105.10 |
| asterisk | vicidial_agent_latency_log_archive | 93.64 |
| asterisk | vicidial_dial_log | 81.70 |
| asterisk | vicidial_carrier_log | 64.73 |
| asterisk | recording_log | 59.82 |
| asterisk | vicidial_log_extended | 54.96 |
| asterisk | vicidial_log | 49.01 |
+--------------+------------------------------------+---------------+
10 rows in set (0.019 sec)
MariaDB [asterisk]> delete from vicidial_api_log;
Query OK, 2107675 rows affected (0.019 sec)
MariaDB [asterisk]> SELECT table_schema, table_name, ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS total_size_MB FROM information_schema.tables GROUP BY table_schema, table_name ORDER BY total_size_MB DESC LIMIT 10;
+--------------+------------------------------------+---------------+
