Body: <p>It takes about 130s to send a test message</p>
  <ul>
  <li>No other queries are running on the database</li>
  <li>Mariadb 10.5.13-1</li>
  </ul>
  <p>join_buffer_size=2M
  key_buffer_size=28M
  innodb_buffer_pool_size=4G
  innodb_log_file_size=1G</p>
  <p>The server has 20GB ram.</p>
  <p>170k records in civicrm_mailing_recipients</p>
  <p>CiviCRM 5.66
  CiviMail: Version 5.66.0
  Mosaico: Version 3.2.1691060437</p>
  <pre><code>Query   |   76 | Sending data | INSERT INTO civicrm_mailing_recipients (mailing_id, contact_id, email_id)
  </code></pre>
  <p>Any ideas?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-10-06T00:01:38.670Z
Comments.Text: 130s! Where is your server located? On the moon!? (if so, you may need to enable the Lunar Module )
Comments.UserDisplayName: Coleman
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-10-06T00:37:26.940Z
Comments.Text: Sadly it is just down the road. 12ms.  Surely the data from 'insert into..' isn't blocking.
Comments.UserDisplayName: Interlated
Tags: <mariadb>
Title: Saving a draft mailing and sending a test message is very slow?
ThreadText: # Saving a draft mailing and sending a test message is very slow?
  
  (Asked by: username_0 on 2023-10-05)
  
  It takes about 130s to send a test message
  
  No other queries are running on the database
  Mariadb 10.5.13-1
  
  join_buffer_size=2M
  key_buffer_size=28M
  innodb_buffer_pool_size=4G
  innodb_log_file_size=1G
  The server has 20GB ram.
  170k records in civicrm_mailing_recipients
  CiviCRM 5.66
  CiviMail: Version 5.66.0
  Mosaico: Version 3.2.1691060437
  Query   |   76 | Sending data | INSERT INTO civicrm_mailing_recipients (mailing_id, contact_id, email_id)
  
  Any ideas?
  
  **Tags:** mariadb
  
  > **Comments:**
  > **username_1**: 130s! Where is your server located? On the moon!? (if so, you may need to enable the Lunar Module )  
  > **username_0**: Sadly it is just down the road. 12ms.  Surely the data from 'insert into..' isn't blocking.  
  
  ---
  
  ## 0 answers
  
  