Gabriele.vivinetto: Created page with "{{Stub}} * Limitare i binlog a tre giorni, altrimenti occupa troppo spazio: cat env_vars/.MYSQL_ROOT_PASSWORD docker exec -it zabbix-mysql-server-1 bash mysql -u root -p SHOW BINARY LOGS; PURGE BINARY LOGS TO 'binlog.xxxxxx'; * Change automatic default purge expiry from 30days (deafault) to 3days SET GLOBAL binlog_expire_logs_seconds = 259200; SET PERSIST binlog_expire_logs_seconds = 259200; * The above value is in seconds, i.e. 3 days in seconds = (60..."

2023-07-12T11:35:52Z

Created page with "{{Stub}} * Limitare i binlog a tre giorni, altrimenti occupa troppo spazio: cat env_vars/.MYSQL_ROOT_PASSWORD docker exec -it zabbix-mysql-server-1 bash mysql -u root -p SHOW BINARY LOGS; PURGE BINARY LOGS TO 'binlog.xxxxxx'; * Change automatic default purge expiry from 30days (deafault) to 3days SET GLOBAL binlog_expire_logs_seconds = 259200; SET PERSIST binlog_expire_logs_seconds = 259200; * The above value is in seconds, i.e. 3 days in seconds = (60..."

New page

{{Stub}}

* Limitare i binlog a tre giorni, altrimenti occupa troppo spazio:
cat env_vars/.MYSQL_ROOT_PASSWORD

docker exec -it zabbix-mysql-server-1 bash

mysql -u root -p

SHOW BINARY LOGS;

PURGE BINARY LOGS TO 'binlog.xxxxxx';

* Change automatic default purge expiry from 30days (deafault) to 3days

SET GLOBAL binlog_expire_logs_seconds = 259200;

SET PERSIST binlog_expire_logs_seconds = 259200;

* The above value is in seconds, i.e. 3 days in seconds = (60 seconds x 60 minutes x 24 hours x 3 days) = 259200

=Riferimenti=
*[https://askubuntu.com/questions/1322041/how-to-solve-increasing-size-of-mysql-binlog-files-problem log - How to Solve Increasing Size of MySQL Binlog Files Problem? - Ask Ubuntu]

Installazione di Zabbix con Docker - Revision history