Purge MYSQL Binary Logs On TMG - Revision history

Lucas Trottier: Redirect to a field notice page with more details

2015-07-20T17:10:29Z

Redirect to a field notice page with more details

← Older revision		Revision as of 13:10, 20 July 2015
Line 1:		Line 1:
			#REDIRECT [[FN13763]]
	This page shows how to manually erase MYSQL Binary Logs On TMG to save your hard disk space		This page shows how to manually erase MYSQL Binary Logs On TMG to save your hard disk space
	<br>		<br>

Nicole Tan at 15:16, 10 July 2015

2015-07-10T15:16:25Z

← Older revision		Revision as of 11:16, 10 July 2015
Line 15:		Line 15:
	== MYSQL binlogs location ==		== MYSQL binlogs location ==
	The directory of MYSQL binlogs is defined at /etc/my.cnf		The directory of MYSQL binlogs is defined at /etc/my.cnf

	[mysqld]		[mysqld]

	datadir=/var/lib/mysql		datadir=/var/lib/mysql

Line 21:		Line 23:

	1. Access mysql database		1. Access mysql database
	mysql -u user –ppassword		mysql -u user –ppassword
	e.g. mysql -u tbdb –ptbdbpw		e.g. mysql -u tbdb –ptbdbpw

	2. Execute the Purge command:		2. Execute the Purge command:
	~~Examples:~~		To erase all binlogs before a specific binlog file:
	To erase all binlogs before a specific binlog file:		PURGE BINARY LOGS TO 'mysql-bin.010';
	PURGE BINARY LOGS TO 'mysql-bin.010';
	To erase all binlogs before a specific Date/Time:		To erase all binlogs before a specific Date/Time:
	PURGE BINARY LOGS BEFORE '2015-04-02 22:46:26';		PURGE BINARY LOGS BEFORE '2015-04-02 22:46:26';

	== Expire binary log files automatically ==		== Expire binary log files automatically ==

Nicole Tan: NT: completed the page

2015-07-09T15:17:45Z

NT: completed the page

← Older revision		Revision as of 11:17, 9 July 2015
Line 9:		Line 9:
	/dev/sda7 21G 3.7G 17G 19% /mnt/.0		/dev/sda7 21G 3.7G 17G 19% /mnt/.0
	/dev/sda6 2.0G 36M 1.9G 2% /tmp		/dev/sda6 2.0G 36M 1.9G 2% /tmp
	/dev/sda2 4.9G 4.6G 5.3M 100% /var		'''/dev/sda2 4.9G 4.6G 5.3M 100% /var'''
	/dev/sda1 494M 16M 453M 4% /boot		/dev/sda1 494M 16M 453M 4% /boot
	tmpfs 997M 0 997M 0% /dev/shm		tmpfs 997M 0 997M 0% /dev/shm

	== MYSQL binlogs location ==		== MYSQL binlogs location ==
			The directory of MYSQL binlogs is defined at /etc/my.cnf
			[mysqld]
			datadir=/var/lib/mysql

	== Purge unnecessary binlogs ==		== Purge unnecessary binlogs ==
Line 27:		Line 30:
	To erase all binlogs before a specific Date/Time:		To erase all binlogs before a specific Date/Time:
	PURGE BINARY LOGS BEFORE '2015-04-02 22:46:26';		PURGE BINARY LOGS BEFORE '2015-04-02 22:46:26';


	== Expire binary log files automatically ==		== Expire binary log files automatically ==
Line 34:		Line 36:
	[mysqld]		[mysqld]
	expire-logs-days=60		expire-logs-days=60
	Note: a 60 days rotation log is enabled by default in more recent TB products.		**Note: a 60 days rotation log is enabled by default in more recent TB products.

	Restart mysql		Restart mysql
			service mysqld restart

	Then mysqld will delete them for you automatically		Then mysqld will delete them for you automatically

Nicole Tan at 15:13, 9 July 2015

2015-07-09T15:13:26Z

← Older revision		Revision as of 11:13, 9 July 2015
Line 4:		Line 4:
	You need to SSh to the TMG host for the following procedures:		You need to SSh to the TMG host for the following procedures:
	== Verify your hard disk space ==		== Verify your hard disk space ==
	~~example:~~		[root@TB00xxxx mysql]# df -h
	[root@TB00xxxx mysql]# df -h		Filesystem Size Used Avail Use% Mounted on
	Filesystem Size Used Avail Use% Mounted on		/dev/sda5 3.9G 1.1G 2.7G 29% /
	/dev/sda5 3.9G 1.1G 2.7G 29% /		/dev/sda7 21G 3.7G 17G 19% /mnt/.0
	/dev/sda7 21G 3.7G 17G 19% /mnt/.0		/dev/sda6 2.0G 36M 1.9G 2% /tmp
	/dev/sda6 2.0G 36M 1.9G 2% /tmp		/dev/sda2 4.9G 4.6G 5.3M 100% /var
	/dev/sda2 4.9G 4.6G 5.3M 100% /var		/dev/sda1 494M 16M 453M 4% /boot
	/dev/sda1 494M 16M 453M 4% /boot		tmpfs 997M 0 997M 0% /dev/shm
	tmpfs 997M 0 997M 0% /dev/shm

	== MYSQL binlogs location ==		== MYSQL binlogs location ==

Nicole Tan: NT: Added more information

2015-07-09T15:10:11Z

NT: Added more information

← Older revision		Revision as of 11:10, 9 July 2015
Line 1:		Line 1:
	This page shows how to manually		This page shows how to manually erase MYSQL Binary Logs On TMG to save your hard disk space
	<br>		<br>

			You need to SSh to the TMG host for the following procedures:
	== Verify your hard disk space ==		== Verify your hard disk space ==
			example:
			[root@TB00xxxx mysql]# df -h
			Filesystem Size Used Avail Use% Mounted on
			/dev/sda5 3.9G 1.1G 2.7G 29% /
			/dev/sda7 21G 3.7G 17G 19% /mnt/.0
			/dev/sda6 2.0G 36M 1.9G 2% /tmp
			/dev/sda2 4.9G 4.6G 5.3M 100% /var
			/dev/sda1 494M 16M 453M 4% /boot
			tmpfs 997M 0 997M 0% /dev/shm

	== MYSQL binlogs location ==		== MYSQL binlogs location ==

Nicole Tan: NT: Created the new page

2015-07-09T14:55:24Z

NT: Created the new page

New page

This page shows how to manually
<br>

== Verify your hard disk space ==

== MYSQL binlogs location ==

== Purge unnecessary binlogs ==

1. Access mysql database
mysql -u user –ppassword
e.g. mysql -u tbdb –ptbdbpw

2. Execute the Purge command:
Examples:
To erase all binlogs before a specific binlog file:
PURGE BINARY LOGS TO 'mysql-bin.010';
To erase all binlogs before a specific Date/Time:
PURGE BINARY LOGS BEFORE '2015-04-02 22:46:26';

== Expire binary log files automatically ==
You can also set the expire_logs_days system variable to expire binary log files automatically after a given number of days.
Simply add this to /etc/my.cnf
[mysqld]
expire-logs-days=60
Note: a 60 days rotation log is enabled by default in more recent TB products.

Restart mysql

Then mysqld will delete them for you automatically