This discussion is archived
2 Replies Latest reply: Nov 29, 2012 1:29 AM by 915190 RSS

VDI 3.4.1 and mysql filling the disk space

915190 Newbie
Currently Being Moderated
Dear VDI gang,

I wonder if someone else hit that issue apart of me.

Basically I run a small Oracle Virtual Desktop Infrastructure 3.4.1 (Build 10) on Oracle Linux release 5.7, single server, with 30 Sun Rays connected to it.

Recently my beloved VDI crashed and when trying to pinpoint the reason I realised that /var/opt/SUNWvda/mysql filled the whole free space on that disk (approx 10GB). As a quick fix I moved it somewhere else and created a symlink which cured it - but still cannot understand why this database is so huge. After having a closer look it turns out that it is not the actual size of VDA database but rather a binary logs being soooo large. At least this is what I think.

My question, did you see this behaviour before?
Is it safe to run "PURGE BINARY LOGS BEFORE 'some date here';" ?
and then trigger it regularly from cron?
And why this binary log is so huge in the first place?

I'm not an expert, neither in VDI area nor DBA, just trying to get my head around all this.
So any hint would be gratefully received :-)

Cheers
  • 1. Re: VDI 3.4.1 and mysql filling the disk space
    user157995 Explorer
    Currently Being Moderated
    Interesting, ours isnt blowing up like that... whats the output of ls -lath /var/opt/SUNWvda/mysql/ look like?

    We have 400 seats in VDI and our database dir is only 98M, the id_logfile is only 5M.
  • 2. Re: VDI 3.4.1 and mysql filling the disk space
    915190 Newbie
    Currently Being Moderated
    Morning,

    Here it is:

    lordVader@deathStar:~ # ls -lath /var/opt/SUNWvda/mysql/
    total 12G
    -rw-rw---- 1 vdadb vdadb 5.0M Nov 29 09:22 ib_logfile1
    -rw-rw---- 1 vdadb vdadb 512M Nov 29 09:22 mysql-bin.000018
    -rw-rw---- 1 vdadb vdadb 5.0M Nov 29 09:22 ib_logfile0
    -rw-rw---- 1 vdadb vdadb 18M Nov 29 09:22 ibdata1
    drwxr-xr-x 6 root root 8.0K Nov 29 09:22 ..
    -rw-rw---- 1 vdadb vdadb 252K Nov 29 09:18 mysqld-slow.log
    -rw-rw---- 1 vdadb vdadb 10K Nov 26 11:42 mysqld_safe.err
    drwxr-xr-x 4 vdadb vdadb 3.9K Nov 26 11:42 .
    -rw-rw---- 1 vdadb vdadb 6 Nov 26 11:42 mysqld.pid
    -rw-rw---- 1 vdadb vdadb 342 Nov 26 11:42 mysql-bin.index
    -rw-rw---- 1 vdadb vdadb 264M Nov 26 11:11 mysql-bin.000017
    -rw-rw---- 1 vdadb vdadb 1.1G Nov 25 04:38 mysql-bin.000016
    -rw-rw---- 1 vdadb vdadb 1.1G Nov 21 15:31 mysql-bin.000015
    -rw-rw---- 1 vdadb vdadb 1.1G Nov 18 01:28 mysql-bin.000014
    drwx------ 2 vdadb vdadb 3.9K Nov 14 16:16 vda
    drwx------ 2 vdadb vdadb 3.9K Nov 14 16:16 mysql
    -rw-rw---- 1 vdadb vdadb 1.1G Nov 14 05:32 mysql-bin.000013
    -rw-rw---- 1 vdadb vdadb 1.1G Nov 10 09:50 mysql-bin.000012
    -rw-rw---- 1 vdadb vdadb 1.1G Nov 6 00:30 mysql-bin.000011
    -rw-rw---- 1 vdadb vdadb 1.1G Nov 1 09:20 mysql-bin.000010
    -rw-rw---- 1 vdadb vdadb 1.1G Oct 29 18:34 mysql-bin.000009
    -rw-rw---- 1 vdadb vdadb 1.1G Oct 27 02:17 mysql-bin.000008
    -rw-rw---- 1 vdadb vdadb 1.1G Oct 23 22:02 mysql-bin.000007
    -rw-rw---- 1 vdadb vdadb 1.1G Oct 19 09:21 mysql-bin.000006
    -rw-rw---- 1 vdadb vdadb 44M Sep 18 07:42 mysql-bin.000005
    -rw-rw---- 1 vdadb vdadb 41M Sep 4 11:12 mysql-bin.000004
    -rw-rw---- 1 vdadb vdadb 1.1M Aug 21 10:10 mysql-bin.000003
    -rw-rw---- 1 vdadb vdadb 707K Aug 21 10:00 mysql-bin.000002
    -rw-rw---- 1 vdadb vdadb 19K Aug 21 10:00 mysql-bin.000001


    and

    lordVader@deathStar:~ # du -sh /var/opt/SUNWvda/mysql/mysql
    896K /var/opt/SUNWvda/mysql/mysql

    lordVader@deathStar:~ # du -sh /var/opt/SUNWvda/mysql/vda
    428K /var/opt/SUNWvda/mysql/vda


    BTW: Do you have anything in mysqld-slow.log?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points