[Erp5-dev] mysql and replication

[Sebastien Robin]

Hi all,

We can find on the documentation of mysql :

"""The binary log is also used on master replication servers as a record 
of the statements to be sent to slave servers."""

This explains why we have on our main server running erp5 many big files 
inside /var/lib/mysql called like this:

bigleon-bin.001
bigleon-bin.002
....
bigleon-bin.055
bigleon-bin.056
bigleon-bin.057

Some of them takes about 1GB of place, so we should delete old logs by 
using this command with mysql :

mysql> PURGE MASTER LOGS TO 'bigleon-bin.058';

Thanks to this command I was able to free about 30Gb !!!

  Seb.
-- 
Sebastien ROBIN

About www.nexedi.com 

Nexedi is a consulting and development services company helping small and 
medium organisations to choose open source / free software and fulfill 
their IT application needs. Nexedi is the founder of the ERP5 project, a 
Free / Open Source ERP software based on innovative technologies 
(www.erp5.org).

About www.storever.com

Storever provides a reliable source for OpenBrick, WiFi infrastructure, 
notebooks and servers preconfigured with the GNU/Linux operating system