#
# This group is read both by the client and the server
# use it for options that affect everything
#
[client-server]

#
# include *.cnf from the config directory
#
!includedir /etc/my.cnf.d

[mysqld]
log-error=/var/lib/mysql/wayed.tasjeel.ae.err
performance-schema=0
max_allowed_packet=268435456
open_files_limit=40000
innodb_file_per_table=1
plugin-load-add=auth_socket.so
unix_socket=OFF
tmpdir=/mytmp
max_connections = 300
max_user_connections = 20
innodb_buffer_pool_size = 2G
innodb_log_file_size = 256M
key_buffer_size = 256M
query_cache_type = 0
sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
table_open_cache = 5000
table_definition_cache = 5000