Recommended SQL modes for managed DBs

Viewing 5 replies - 1 through 5 (of 5 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    6 years, 1 month ago

    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

    (@meanwood)

    6 years, 1 month ago

    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)

    (@sterndata)

    Volunteer Forum Moderator

    6 years, 1 month ago

    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.

    Thread Starter slate

    (@meanwood)

    6 years, 1 month ago

    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

    (@fierevere)

    永子

    6 years, 1 month ago

    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.