20131209 mysql server default configuration - plembo/onemoretech GitHub Wiki

title: MySQL server default configuration link: https://onemoretech.wordpress.com/2013/12/09/mysql-server-default-configuration/ author: phil2nc description: post_id: 6759 created: 2013/12/09 12:36:53 created_gmt: 2013/12/09 17:36:53 comment_status: closed post_name: mysql-server-default-configuration status: publish post_type: post

MySQL server default configuration

Command to use in order to see the default values for a mysql/mariadb server. On RHEL and RHEL-inspired distributions, right up to Fedora 19:

/usr/libexec/mysqld --verbose --help

It's all pretty much listed there for you. Very helpful for deciding what to clutter your /etc/my.cnf with and as a sanity check against suggestions found in various places on the web. Do this and you've got yourself a quick-reference guide:

/usr/libexec/mysqld --verbose --help >mysql-manual.txt