title: /var directory is full because mysql?
body: <p>My server storage is almost full. If I run a <code>df -h</code> command on Centos, it shows me that my <code>/var</code> directory is at the edge of my disk capacity like this:</p>
  
  <pre><code>S.ficheros          TamaÃ±o Usado  Disp Uso% Montado en
  /dev/sda3             205G   23G  172G  12% /
  /dev/sda2             243G  225G  5,0G  98% /var
  /dev/sda1             289M   23M  251M   9% /boot
  tmpfs                 1,8G     0  1,8G   0% /dev/shm
  none                  1,8G  104K  1,8G   1% /var/lib/xenstored
  </code></pre>
  
  <p>If I check the total size of my files in <code>/var</code> using <code>du -chs</code> it shows:</p>
  
  <pre><code>5,3G    .
  5,3G    total
  </code></pre>
  
  <p>I suppose that MySQL is using the 220G left, so I execute the next query to check the total size of my databases:</p>
  
  <pre><code>SELECT SUM((data_length+index_length)/POWER(1024,3)) tablesize_gb FROM information_schema.tables
  </code></pre>
  
  <p>and the output is the next: </p>
  
  <pre><code>+-------------------+
  | tablesize_gb      |
  +-------------------+
  | 0.748469822108746 |
  +-------------------+
  1 row in set (0.05 sec)
  </code></pre>
  
  <p>I don't really know what am I missing here — can any one help me?</p>