# this is read by the standalone daemon and embedded servers
[server]

# this is only for the mysqld standalone daemon
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mysqld/mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mariadb/mariadb.log
pid-file=/run/mariadb/mariadb.pid
skip-external-locking
skip-name-resolve
max_heap_table_size=512M
tmp_table_size=32M
sql_mode=NO_ENGINE_SUBSTITUTION
key_buffer = 640M
default-time-zone = 'America/Mexico_City'
sql-mode=""
open_files_limit = 1024000
max_connections = 600
key_buffer_size=2G
max_allowed_packet=16M
table_open_cache=8192
table_cache = 8192
query_cache_size=2M
query_cache_type=0
query_cache_limit=500M
join_buffer_size=1024M
table_definition_cache=2048
sort_buffer_size=16M
net_buffer_length=8K
read_buffer_size=32M
read_rnd_buffer_size=32M
myisam_sort_buffer_size=256M
thread_concurrency=16
thread_cache_size = 512
default-storage-engine=MyISAM
expire_logs_days=3
delay_key_write=ALL
max_write_lock_count=1
performance_schema=ON
innodb_log_file_size=16M
thread_cache_size = 1024
innodb_buffer_pool_size=10M


#
# * 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.3 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.3]