I have an asterisk PBX that has call recordings stored in a SQL database table.

This table has 9199 rows and is consuming 21GB on my server. I want to dump the data in this table to restore space on the server. I also only have 2GB of space left on my server. So could someone please help me with the following:

  1. Is there an issue if I start to flush the table with only 2GB of space on my disk?
  2. What would be the best command to use to flush this table?
  • 1
    Is the table MyISAM or InnoDB? If InnoDB - what's innodb_file_per_table?
    – akuzminsky
    Mar 5 '16 at 17:05
  • You can redirect mysqldump output to gzip, that might put it well under 2GB depending on the data.
    – jkavalik
    Mar 6 '16 at 18:56
  • SHOW TABLE STATUS for the 21GB table.
    – Rick James
    Mar 7 '16 at 0:01
  • What is the name of the biggest file?
    – Rick James
    Mar 7 '16 at 0:02

Try cleaning the logs if you don't need them.

there is something freak in 9199 rows and consuming 21GB

see Freeing up disk space in 'mysql\data'

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.