title: How to optimize the tables in information_Schema database
body: <p>I got the free space (fragmentation issues) in my <strong>information_Schema</strong> database.</p>
  
  <p>Alert shows that there are 1500% free space in some tables like <strong>COLUMNS , ROUTINES.</strong></p>
  
  <p>I am worried how this is possible because i don't have any routines in my database and how i can optimize the information_schema because its memory based database and created on the starting of mysql service.</p>
  
  <p>Also when i query <strong>"SHOW CREATE TABLE"</strong> on any of the information_schema table it gives me innodb as engine of these table, but i think it should be memory.</p>
  
  <p>Any idea to optimize these tables without restart?</p>
  
  <p>Thanks</p>