How to clear the disk space after deleting the database?

PURGE BINARY LOGS BEFORE '2024-05-06' this command freed up all the space occupied by binlog.001257 files in /var/lib/mysql. Added "binlog_expire_logs_seconds=86400" to the config.

0

6 месяцев назад

PavelDBA

Сергей
PURGE BINARY LOGS BEFORE '2024-05-06' this command...

You need used meaning in the parameters binlog_expire_logs_seconds or expire_logs_days it dependence from your system. If you use replication, maybe you need more value from this parameter.

0

6 месяцев назад

PavelDBA · Accepted Answer

PavelDBA

Usually, when you drop database, disk space released. You use option innodb_file_per_table = 1 ? Maybe your MySQL used disk space for this parameter, log-bin? Check this parameter in the config files. You can use commands, for example, PURGE BINARY LOGS TO 'mysql-bin.010'; PURGE BINARY LOGS BEFORE '2014-02-02'

0

6 месяцев назад

169 похожих чатов

How to clear the disk space after deleting the database?

5 ответов

Похожие вопросы