title: Optimize MySql 5.7 table without downtime
body: <p>I have a table in MySql 5.7 server. We store around 1M rows every day. After each row insertion, we do some processing on that row after that we delete that row. </p>
  
  <p>Table disk space is rapidly increasing because of this huge number of write operations. So I want to do OPTIMIZE the Table.</p>
  
  <p>So if I apply OPTIMIZE Table command on production table does it give any downtime.</p>
  
  <p>What is the best way to do OPTIMIZE table?</p>
  
  <p><strong>MySql Server details</strong></p>
  
  <p>Server version: <strong>5.7</strong></p>
  
  <p>Engine: <strong>InnoDB</strong></p>
  
  <p>Hosting: <strong>Google Cloud Sql</strong></p>
  
  <p>Thanks</p>