High Disk Space Usage on Node03 of Oracle Big Data Appliance (BDA) (Doc ID 1529237.1)

Last updated on OCTOBER 11, 2016

Applies to:

Big Data Appliance Integrated Software - Version 2.0.1 to 4.0 [Release 2.0 to 4.0]
Linux x86-64

Symptoms

Noticed that nearly 90% of disk space is consumed on Node03 of Oracle Big Data Appliance(BDA), where MySQL master server resides.

/var/lib/mysql is the culprit, taking up lots of disk space.

# df -k mysql
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/md2 168625000 143090752 16830252 90% /

 
In /var/lib/mysql , there are large number of mysql binary log files

# ls -l /var/lib/mysql/mysql-bin*
-rw-rw---- 1 mysql mysql 3548 Jan 10 16:24 mysql/mysql-bin.000001
-rw-rw---- 1 mysql mysql 126 Jan 10 16:25 mysql/mysql-bin.000002
-rw-rw---- 1 mysql mysql 126 Jan 10 16:25 mysql/mysql-bin.000003
-rw-rw---- 1 mysql mysql 1073765129 Jan 11 07:30 mysql/mysql-bin.000004
-rw-rw---- 1 mysql mysql 1073752676 Jan 11 17:06 mysql/mysql-bin.000005
-rw-rw---- 1 mysql mysql 1073756687 Jan 12 00:45 mysql/mysql-bin.000006
-rw-rw---- 1 mysql mysql 1073775711 Jan 12 08:23 mysql/mysql-bin.000007
..........
........
-rw-rw---- 1 mysql mysql 1073749529 Feb 10 23:41 mysql/mysql-bin.000100
-rw-rw---- 1 mysql mysql 1073751597 Feb 11 07:20 mysql/mysql-bin.000101
-rw-rw---- 1 mysql mysql 1073748359 Feb 11 14:45 mysql/mysql-bin.000102
-rw-rw---- 1 mysql mysql 344171687 Feb 11 17:11 mysql/mysql-bin.000103
....................

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms