Body: <p>I'm trying to make a local copy of our site in MAMP to play around with, but it's really, really slow. Extraordinarily slow. So slow, in fact, that the database connection seems to be timing out.</p>
  
  <p>The Drupal pages and admin area mostly seem to load OK, except for the following error appended to the bottom of the homepage:</p>
  
  <pre><code>Initialization Error
  
  Array
  (
      [callback] =&gt; Array
          (
              [0] =&gt; CRM_Core_Error
              [1] =&gt; simpleHandler
          )
  
      [code] =&gt; -24
      [message] =&gt; DB Error: connect failed
      [mode] =&gt; 16
      [debug_info] =&gt;  [nativecode=Operation timed out]
      [type] =&gt; DB_Error
      [user_info] =&gt;  [nativecode=Operation timed out]
      [to_string] =&gt; [db_error: message="DB Error: connect failed" code=-24 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info=" [nativecode=Operation timed out]"]
  )
  </code></pre>
  
  <p>When I click the CiviCRM link that would normally take me through to the CiviCRM homepage, I get just that same error on a white background.</p>
  
  <p>MAMP's WebStart page, PHPinfo and phpMyAdmin all seem to run just fine. I'm using a completely bog standard default MAMP config, with the site on localhost:8888, no custom locations. The only change I've made is to increase the PHP memory_limit to 512M.</p>
  
  <p>MAMP 5.5, PHP 7.3.8, mySQL 5.7.26, Drupal 7.67, CiviCRM 5.18.4</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-11-07T12:03:10.600Z
Comments.Text: I do think this might be something to do with the MySQL configuration and not the PHP configuration.
Comments.UserDisplayName: Jaap Jansma - CiviCooP
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-11-08T13:18:09.017Z
Comments.Text: It does look like it's timing out waiting for a response from MySQL. Any idea what might cause it?
Comments.UserDisplayName: somnolentsurfer
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-11-11T08:40:51.490Z
Comments.Text: Not really as I am not an expert in Mysql configuration.
Comments.UserDisplayName: Jaap Jansma - CiviCooP
Tags: <mamp>
Title: Operation timed out running Drupal/Civi on MAMP
ThreadText: # Operation timed out running Drupal/Civi on MAMP
  
  (Asked by: username_0 on 2019-11-05)
  
  I'm trying to make a local copy of our site in MAMP to play around with, but it's really, really slow. Extraordinarily slow. So slow, in fact, that the database connection seems to be timing out.
  
  The Drupal pages and admin area mostly seem to load OK, except for the following error appended to the bottom of the homepage:
  
  ```
  Initialization Error
  
  Array
  (
      [callback] => Array
          (
              [0] => CRM_Core_Error
              [1] => simpleHandler
          )
  
      [code] => -24
      [message] => DB Error: connect failed
      [mode] => 16
      [debug_info] =>  [nativecode=Operation timed out]
      [type] => DB_Error
      [user_info] =>  [nativecode=Operation timed out]
      [to_string] => [db_error: message="DB Error: connect failed" code=-24 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info=" [nativecode=Operation timed out]"]
  )
  
  ```
  
  When I click the CiviCRM link that would normally take me through to the CiviCRM homepage, I get just that same error on a white background.
  
  MAMP's WebStart page, PHPinfo and phpMyAdmin all seem to run just fine. I'm using a completely bog standard default MAMP config, with the site on localhost:8888, no custom locations. The only change I've made is to increase the PHP memory\_limit to 512M.
  
  MAMP 5.5, PHP 7.3.8, mySQL 5.7.26, Drupal 7.67, CiviCRM 5.18.4
  
  **Tags:** mamp
  
  > **Comments:**
  > **username_1**: I do think this might be something to do with the MySQL configuration and not the PHP configuration.  
  > **username_0**: It does look like it's timing out waiting for a response from MySQL. Any idea what might cause it?  
  > **username_1**: Not really as I am not an expert in Mysql configuration.  
  
  ---
  
  ## 0 answers
  
  