title: Lost connection to mysql during query, mysql workbench
body: <p>I have the same problem as <a href="https://stackoverflow.com/questions/10563619/error-code-2013-lost-connection-to-mysql-server-during-query/12790569#12790569">this</a> when I want to index a very large table on one of its non-unique columns which is an integer, and I tried all the solutions that are proposed in that post that has at least one vote up. I still couldn't fix it. Any other ideas?</p>
  
  <p>I have enough memory:</p>
  
  <p>max_allowed_packet: 2G,
  innodb_buffer_pool_size: 9G</p>
  
  <p>All the time out settings mentioned in <a href="https://stackoverflow.com/questions/10563619/error-code-2013-lost-connection-to-mysql-server-during-query/12790569#12790569">this post</a> and <a href="http://dev.mysql.com/doc/refman/5.0/en/error-lost-connection.html" rel="nofollow noreferrer">here</a> are set to much higher numbers than the default.</p>