Answers.Body: <p>It happened to me too after upgrading from 5.52.3 to 5.60. This post showed how to fix the 5 temp tables in my system:
  <a href="https://civicrm.stackexchange.com/questions/14444/civicrm-still-creates-myisam-tables-which-results-in-warning">CiviCRM still creates MyISAM tables which results in Warning</a>
  It looked like this:
  mysql&gt; alter table civicrm_temp_2281c543efe9ebaa8e9fd6331f53600d ENGINE=InnoDB;
  Query OK, 9274 rows affected (0.13 sec)
  Records: 9274  Duplicates: 0  Warnings: 0
  I did that for each InnoDB table it found.
  Should I change the default_storage_engine global from InnoDB to ISAM?</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-04-21T23:55:25.340Z
Answers.Text: Yes - I think it's a good idea to "change the default_storage_engine global from InnoDB to ISAM?"
  
  Also - your default charset should be utf8mb4 (not sure if that is relevant, just mentioning it)
Answers.UserDisplayName: eileen
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-04-18T14:22:03.337Z
Answers.LastActivityDate: 2023-04-18T14:22:03.337Z
Answers.UserDisplayName: vrapp
Body: <p>I am suddenly receiving the message, &quot;Your database is configured to use the MyISAM database engine. CiviCRM requires InnoDB. You will need to convert any MyISAM tables in your database to InnoDB. Using MyISAM tables will result in data integrity issues.</p>
  <p>I'm running 5.26.1</p>
  <p>How will this affect my Wordpress site?</p>
  <p>Thank,
  dt</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-08-18T18:03:01.557Z
Comments.Text: Can you run `show table status where engine like '%ISAM%';` on your database, e.g. using phpmyadmin or command line? It will tell you what tables it's talking about.
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-08-18T18:36:58.030Z
Comments.Text: Thanks so much Demerit! Turns out the tables in question are from the CiviElection extension. I've decided not to use that extension in favor of a WP plugin, so will delete that extension and see if message goes away.
Comments.UserDisplayName: Doug Thomson
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-08-18T18:40:09.080Z
Comments.Text: That did it. All is well. (For now) Thanks again.
Comments.UserDisplayName: Doug Thomson
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-08-18T18:46:22.623Z
Comments.Text: Ok cool. It's unlikely that extension specifically creates MyISAM tables and more likely it just doesn't specify, so it's probably that the system default is set to MyISAM, e.g. `show variables like 'default_storage_engine';`
Comments.UserDisplayName: Demerit
Tags: <mysql>
Title: I am suddenly receiving the message, "Your database is configured to use the MyISAM database engine
ThreadText: # I am suddenly receiving the message, "Your database is configured to use the MyISAM database engine
  
  (Asked by: username_0 on 2020-08-18)
  
  I am suddenly receiving the message, "Your database is configured to use the MyISAM database engine. CiviCRM requires InnoDB. You will need to convert any MyISAM tables in your database to InnoDB. Using MyISAM tables will result in data integrity issues.
  
  I'm running 5.26.1
  
  How will this affect my Wordpress site?
  
  Thank,
  dt
  
  **Tags:** mysql
  
  > **Comments:**
  > **username_1**: Can you run `show table status where engine like '%ISAM%';` on your database, e.g. using phpmyadmin or command line? It will tell you what tables it's talking about.  
  > **username_0**: Thanks so much username_1! Turns out the tables in question are from the CiviElection extension. I've decided not to use that extension in favor of a WP plugin, so will delete that extension and see if message goes away.  
  > **username_0**: That did it. All is well. (For now) Thanks again.  
  > **username_1**: Ok cool. It's unlikely that extension specifically creates MyISAM tables and more likely it just doesn't specify, so it's probably that the system default is set to MyISAM, e.g. `show variables like 'default_storage_engine';`  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2023-04-18. Score: 0
  
  It happened to me too after upgrading from 5.52.3 to 5.60. This post showed how to fix the 5 temp tables in my system:
  [CiviCRM still creates MyISAM tables which results in Warning](https://civicrm.stackexchange.com/questions/14444/civicrm-still-creates-myisam-tables-which-results-in-warning)
  It looked like this:
  mysql> alter table civicrm\_temp\_2281c543efe9ebaa8e9fd6331f53600d ENGINE=InnoDB;
  Query OK, 9274 rows affected (0.13 sec)
  Records: 9274 Duplicates: 0 Warnings: 0
  I did that for each InnoDB table it found.
  Should I change the default\_storage\_engine global from InnoDB to ISAM?
  
  > **Comments:**
  > **username_3**: Yes - I think it's a good idea to "change the default_storage_engine global from InnoDB to ISAM?"  Also - your default charset should be utf8mb4 (not sure if that is relevant, just mentioning it)  
  
  ---
  
  