X-Git-Url: https://git.cyclocoop.org/?a=blobdiff_plain;f=etc%2Fmysql%2Fmy.cnf;fp=etc%2Fmysql%2Fmy.cnf;h=60dd256caa2a297e017760d00def6cf82b012921;hb=a79f9f3838b98f9b06fa492a2bbd902658ff223d;hp=0000000000000000000000000000000000000000;hpb=09436582477e790bb70a0fc2904595b0530fe0f1;p=lhc%2Fateliers.git diff --git a/etc/mysql/my.cnf b/etc/mysql/my.cnf new file mode 100644 index 0000000..60dd256 --- /dev/null +++ b/etc/mysql/my.cnf @@ -0,0 +1,51 @@ +[client] +port = 3306 +socket = /var/run/mysqld/mysqld.sock +[mysqld_safe] +nice = 0 +socket = /var/run/mysqld/mysqld.sock +[mysqld] +# chroot = /var/lib/mysql/ +# ssl-ca=/etc/mysql/cacert.pem +# ssl-cert=/etc/mysql/server-cert.pem +# ssl-key=/etc/mysql/server-key.pem +basedir = /usr +bind-address = 127.0.0.1 +#binlog_do_db = include_database_name +#binlog_ignore_db = include_database_name +datadir = /home/mysql +expire_logs_days = 10 +#general_log = 1 +#general_log_file = /var/log/mysql/mysql.log +key_buffer = 16M +lc-messages-dir = /usr/share/mysql +#log-queries-not-using-indexes +#log_bin = /var/log/mysql/mysql-bin.log +#log_slow_queries = /var/log/mysql/mysql-slow.log +#long_query_time = 2 +max_allowed_packet = 16M +max_binlog_size = 100M +#max_connections = 100 +myisam-recover = BACKUP +pid-file = /var/run/mysqld/mysqld.pid +port = 3306 +query_cache_limit = 1M +query_cache_size = 16M +#server-id = 1 +skip-external-locking +socket = /var/run/mysqld/mysqld.sock +#table_cache = 64 +thread_cache_size = 8 +#thread_concurrency = 10 +thread_stack = 192K +tmpdir = /tmp +user = mysql +[mysqldump] +max_allowed_packet = 16M +quick +quote-names +[mysql] +#no-auto-rehash # faster start of mysql but no tab completition +[isamchk] +key_buffer = 16M +!includedir /etc/mysql/conf.d/