Answers.Body: <p>I have definitely altered this variable for upgrades, but my notes show I only increased the values to <code>1800</code>.</p>
  
  <p>I don't recall whether this was because I found that <code>-1</code> didn't work, or because I preferred to not allow a connection to remain open indefinitely.</p>
  
  <p>So yes, I think you should alter it if necessary to complete upgrade.</p>
  
  <p>If you find setting to <code>-1</code> works, make sure to change it back post-upgrade!</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-12-28T20:28:53.067Z
Answers.LastActivityDate: 2016-12-28T20:34:24.913Z
Answers.LastEditDate: 2016-12-28T20:34:24.913Z
Answers.UserDisplayName: Chris Burgess
Body: <p>MySQL has been losing connection on me while trying to complete the upgrade. I am wondering if I should change the php.ini variable <code>mysql.connect_timeout = 60</code> to a value of <code>-1</code> (unlimited) and if this will help?</p>
  
Tags: <drupal><upgrade><mysql>
Title: Should I change mysql.connect_timeout variable in php.ini?
ThreadText: # Should I change mysql.connect_timeout variable in php.ini?
  
  (Asked by: username_0 on 2016-12-28)
  
  MySQL has been losing connection on me while trying to complete the upgrade. I am wondering if I should change the php.ini variable `mysql.connect_timeout = 60` to a value of `-1` (unlimited) and if this will help?
  
  **Tags:** drupal, upgrade, mysql
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2016-12-28. Score: 3 | Accepted answer
  
  I have definitely altered this variable for upgrades, but my notes show I only increased the values to `1800`.
  
  I don't recall whether this was because I found that `-1` didn't work, or because I preferred to not allow a connection to remain open indefinitely.
  
  So yes, I think you should alter it if necessary to complete upgrade.
  
  If you find setting to `-1` works, make sure to change it back post-upgrade!
  
  
  ---
  
  