#
# 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/compusyscloud.dedicated.co.za.err
default-storage-engine=MyISAM
innodb_file_per_table=1
performance-schema=0
max_connections=500
myisam_sort_buffer_size = 32M
join_buffer_size = 16M
read_buffer_size = 16M
sort_buffer_size = 16M
table_open_cache=1500
thread_cache_size = 128
interactive_timeout = 150
wait_timeout = 120
connect_timeout = 10
max_allowed_packet=268435456
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 64M
query_cache_type = 1

innodb_buffer_pool_size=1024M
#innodb_flush_method=O_DIRECT

tmpdir = /dev/shm
max_delayed_threads=0
open_files_limit=50000
plugin-load-add=auth_socket.so
unix_socket=OFF