High Disk Space Usage on Node03 of Oracle Big Data Appliance (BDA)
(Doc ID 1529237.1)
Last updated on FEBRUARY 16, 2023
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% /
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
....................
-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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |