#
# 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]

# this is only for the mysqld standalone daemon
[mysqld]
basedir=/usr
user=mysql
datadir=/var/lib/mysql/data
socket=/var/lib/mysql/mysql.sock
#tmpdir = /var/lib/mysql/tmp
tmpdir = /dev/shm
#general-log=1

# charset
init-connect='SET NAMES utf8'
character_set_server = utf8
collation_server = utf8_general_ci

#Replication
#server-id = 1
#log_bin = /var/log/mysql/mysql-bin
#relay-log = /var/log/mysql/relay-bin
#binlog-ignore-db = mysql
#binlog-format = mixed
#slave-net-timeout = 60
#skip_slave_start
##read-only
#log_slave_updates=0
#expire_logs_days=7

slow_query_log = 1
slow_query_log_file = /var/log/mysql/mysql-slow.log
general_log=0
general_log_file= /var/log/mysql/mysql.log

key_buffer_size = 2048M

max_allowed_packet = 128M

#default_table_type = InnoDB
table_open_cache = 1024
table_definition_cache = 1024

max_connections = 500
thread_cache_size = 50

# InnoDB configuration
# #innodb_buffer_pool_size = 10G
# jusqu'a 80% de la memoire physique (en general le plu gros index
innodb_buffer_pool_size = 12G
innodb_additional_mem_pool_size = 16M
innodb_log_buffer_size = 8M
innodb_max_dirty_pages_pct = 30
innodb_log_file_size = 64M
innodb_file_per_table
#innodb_flush_method = O_DIRECT
innodb_doublewrite = 0
innodb_flush_log_at_trx_commit = 0

bulk_insert_buffer_size = 16M

# 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.0 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.0]
#default-storage-engine = InnoDB