title: Why is there no free space in MySQL database?
body: <p>Recently, I checked the SQL databases I'm using in phpMyAdmin (with WAMP), and they all report no free space. This was not true before, and I'm not sure what caused it to change. The lack of free space is making calls to the databases very, very slow. I've reinstalled WAMP, created a new user for phpMyAdmin, and reimported the databases into the new user, but to no avail.</p>
  
  <p>Here is the query I used to check for space and the result:</p>
  
  <pre><code>SELECT table_schema "beek", SUM( data_length + index_length ) /1024 / 1024 "Data Base Size in MB", SUM( data_free ) /1024 /1024 "Free Space in MB"
  FROM information_schema.TABLES
  GROUP BY table_schema
  LIMIT 0 , 30
  </code></pre>
  
  <pre>
  beek
  Data Base Size in MB
  Free Space in MB
  
  -------------------------------------------
  beek
  
  Data Base Size in MB 4.11813927
  
  Free Space in MB 0.00000000
  
  -----------------------------------------
  information_schema
  
  Data Base Size in MB 0.00976563
  
  Free Space in MB 0.00000000
  
  ---------------------------------------
  mysql
  
  Data Base Size in MB 0.76406479
  
  Free Space in MB 0.00000000
  
  -------------------------------------
  performance_schema
  
  Data Base Size in MB 0.00000000
  
  Free Space in MB 0.00000000
  
  --------------------------------------------
  </pre>
  
  <p>Does anyone know why all of the extra space in these databases has disappeared?</p>