title: How to clean or resize the ibtmp1 file in MySQL?
body: <p>MySQL 5.7 introduces a new file <strong>ibtmp1</strong> for storing temporary data in InnoDB to increase the performance.</p>
  
  <p>But I have noted that its size increases continuously. On my db server its sizes increases to 92GB.</p>
  
  <p>Is there any way of reducing size or deleting the file <strong>without restarting the server</strong> ?</p>
  
  <p>Thanks</p>