Title: Recommended SQL modes for managed DBs
Last modified: May 8, 2020

---

# Recommended SQL modes for managed DBs

 *  [slate](https://wordpress.org/support/users/meanwood/)
 * (@meanwood)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/recommended-sql-modes-for-managed-dbs/)
 * What is the recommended for wordpress websites?
    -  This topic was modified 6 years, 1 month ago by [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/).

Viewing 5 replies - 1 through 5 (of 5 total)

 *  Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * (@sterndata)
 * Volunteer Forum Moderator
 * [6 years, 1 month ago](https://wordpress.org/support/topic/recommended-sql-modes-for-managed-dbs/#post-12804921)
 * I just use the defaults. Unless you have some extra-ordinary needs, they should
   work for you. (I’m using Maria 10.4)
 * Moved to “fixing wordpress” as this is not a “requests/feedback” topic.
 *  Thread Starter [slate](https://wordpress.org/support/users/meanwood/)
 * (@meanwood)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/recommended-sql-modes-for-managed-dbs/#post-12804984)
 * Im using MySQL 8, did have some problems in the past with collation and zeroes
   in dates which required me to do a lot of digging. So now I want to find out 
   the recommended modes. Currently im only using:
    ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
 *  Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * (@sterndata)
 * Volunteer Forum Moderator
 * [6 years, 1 month ago](https://wordpress.org/support/topic/recommended-sql-modes-for-managed-dbs/#post-12805026)
 * As far as I know, there’s no recommended modes.
 * This is my server.conf file in /etc/my.conf.d/
 * (update .. this is from my production server)
 *     ```
       $ more server.cnf
       #
       # These groups are read by MariaDB server.
       # Use it for options that only the server (but not clients) should see
       #
       # See the examples of server my.cnf files in /usr/share/mysql/
       #
   
       # this is read by the standalone daemon and embedded servers
       [server]
       query_cache_type=1
       tmp_table_size=20M
       max_heap_table_size=20M
       table_open_cache=2500
       innodb-buffer_pool_size=250M
   
       log_error=/var/log/mysql/mysql_error.log
   
       # this is only for the mysqld standalone daemon
       [mysqld]
   
       #
       # * Galera-related settings
       #
       [galera]
       # Mandatory settings
       #wsrep_on=ON
       #wsrep_provider=
       #wsrep_cluster_address=
       #binlog_format=row
       #default_storage_engine=InnoDB
       #innodb_autoinc_lock_mode=2
       #
       # Allow server to accept connections on all interfaces.
       #
       #bind-address=0.0.0.0
       #
       # Optional setting
       #wsrep_slave_threads=1
       #innodb_flush_log_at_trx_commit=0
   
       # this is only for embedded server
       [embedded]
   
       # This group is only read by MariaDB servers, not by MySQL.
       # If you use the same .cnf file for MySQL and MariaDB,
       # you can put MariaDB-only options here
       [mariadb]
   
       # This group is only read by MariaDB-10.2 servers.
       # If you use the same .cnf file for MariaDB of different versions,
       # use this group for options that older servers don't understand
       [mariadb-10.2]
       ```
   
 * I used the mysql-tuner.pl script to get some of those size values.
    -  This reply was modified 6 years, 1 month ago by [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/).
    -  This reply was modified 6 years, 1 month ago by [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/).
 *  Thread Starter [slate](https://wordpress.org/support/users/meanwood/)
 * (@meanwood)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/recommended-sql-modes-for-managed-dbs/#post-12805372)
 * Im familiar with mysql-tuner, it shows me some different values though. I did
   read in some forums, that there are a couple mysql-modes wordpress is not compatible
   with, such as ANSI, so i want to make sure this time i will set it up correctly.
   why are you using mariadb over mysql?
 *  Moderator [Yui](https://wordpress.org/support/users/fierevere/)
 * (@fierevere)
 * 永子
 * [6 years, 1 month ago](https://wordpress.org/support/topic/recommended-sql-modes-for-managed-dbs/#post-12805982)
 * `ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION`
 * this is fine and should be compatible with the most web apps, including WordPress
 * > why are you using mariadb over mysql
 * this is a difficult question to answer, most people user whatever is present 
   and preferred by their OS distribution. And most current preferences are – MariaDB
   over Oracle MySQL, due to being more open. You can find more information on the
   web, its outside of this forum scope.
    Technically both – MariaDB and/or MySQL
   are fine.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Recommended SQL modes for managed DBs’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 5 replies
 * 3 participants
 * Last reply from: [Yui](https://wordpress.org/support/users/fierevere/)
 * Last activity: [6 years, 1 month ago](https://wordpress.org/support/topic/recommended-sql-modes-for-managed-dbs/#post-12805982)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics