title: High values of innodb_lock_wait_timeout on Mysql
body: <p>we're trying to get some statistics over our large log tables on MySQL. Some select queries are taking too long to complete and causing exceptions as;<br>
  <strong>Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction</strong><br>
  This is causing our whole application to stop serving with the same error. After some research we decided to change 'innodb_lock_wait_timeout' variable of our MySQL server configuration.</p>
  
  <p>But, What are the drawbacks of this configuration change?</p>