[mysqld] log-bin=mysql-bin server-id= binlog-ignore-db=mysql binlog-ignore-db=LicenseDB binlog-ignore-db=GlobalMetaDataDB_BAK binlog-ignore-db=GlobalMetaDataDB binlog-ignore-db=ConfigurationDB datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock pid-file=/var/lib/mysql/mysqld.pid skip-innodb # Must set default user if we start mysqld as root user=mysql max_allowed_packet=17M max_connections=2000 read_buffer_size=2M sort_buffer=2M # Increase write timeout from server in order to tolerate # clients having a long query but processing them slowly. net_write_timeout=2700 # Set key_buffer to 5 - 50% of your RAM depending on how # much you use MyISAM tables. key_buffer=256M default_table_type=myisam #delay_key_write = ON #delayed_insert_limit = 500 [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid skip-networking=OFF [client] ssl-ca=/var/etc/openssl/cacert.pem ssl-cert=/var/etc/openssl/mysql-cert.pem ssl-key=/var/etc/openssl/mysql-key.pem [mysqld] ssl-ca=/var/etc/openssl/cacert.pem ssl-cert=/var/etc/openssl/mysql-cert.pem ssl-key=/var/etc/openssl/mysql-key.pem [mysqld_safe] open-files-limit=50000 [mysqld_multi] mysqld = /usr/bin/mysqld_safe mysqladmin = /usr/bin/mysqladmin