MySQL replication files are too big

Hi everyone

I'm running MySQL (3.23.55) replication on my main server (RH 7.3 plain) to a backup server.

Over the last few months the 'bin' files in /var/lib/mysql on the master server have been getting very big, but they don't ever seem to go away!

The directory listing (snipped):

Code: 
ls -lh /var/lib/mysql/
-rw-rw----    1 mysql    mysql        286M May 18 21:30 ns-bin.001
-rw-rw----    1 mysql    mysql        155M May 21 14:26 ns-bin.002
-rw-rw----    1 mysql    mysql        179M May 25 04:02 ns-bin.003
-rw-rw----    1 mysql    mysql         109 May 25 04:02 ns-bin.004
-rw-rw----    1 mysql    mysql        277M May 29 17:20 ns-bin.005
-rw-rw----    1 mysql    mysql        104M Jun  1 04:02 ns-bin.006
-rw-rw----    1 mysql    mysql         109 Jun  1 04:02 ns-bin.007
-rw-rw----    1 mysql    mysql        391M Jun  8 04:02 ns-bin.008
-rw-rw----    1 mysql    mysql         109 Jun  8 04:02 ns-bin.009
-rw-rw----    1 mysql    mysql        414M Jun 15 04:02 ns-bin.010
-rw-rw----    1 mysql    mysql         109 Jun 15 04:02 ns-bin.011
-rw-rw----    1 mysql    mysql        421M Jun 22 04:02 ns-bin.012
-rw-rw----    1 mysql    mysql         109 Jun 22 04:02 ns-bin.013
-rw-rw----    1 mysql    mysql        432M Jun 29 04:02 ns-bin.014
-rw-rw----    1 mysql    mysql         109 Jun 29 04:02 ns-bin.015
-rw-rw----    1 mysql    mysql        252M Jul  3 09:37 ns-bin.016
-rw-rw----    1 mysql    mysql         208 Jun 29 04:02 ns-bin.index
I'm running out of space very quickly on this partition, so can I safely delete any of these files? If so, which ones?

If I can't delete them, how can I make MySQL tidy them up?

Thanks

Matt

 

 

 

 

Top