[client-server]
!includedir /etc/my.cnf.d
[mysqld]
log-error = /var/lib/mysql/199-193-7-132.cprapid.com.err
performance-schema = 0
innodb_buffer_pool_size = 1G
max_allowed_packet = 268435456
innodb_file_per_table = 1
unix_socket = OFF
tmpdir = /tmp/.mysql/
slow_query_log_file = /var/lib/mysql/mysql-slow-query.log
log_error = /var/lib/mysql/mysqld-err.log
max_user_connections = 50
innodb_log_file_size = 128M
sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
innodb_flush_method = fsync
max_connections = 500
long_query_time = 3
slow_query_log = 1
query_cache_limit = 32768
query_cache_min_res_unit = 2048
default-storage-engine = MyISAM
query_cache_type = 0
query_cache_size = 0
tmpdir=/tmp/.mysql/
slow_query_log_file=/var/lib/mysql/mysql-slow-query.log
log_error=/var/lib/mysql/mysqld-err.log
max_user_connections=50
table_open_cache = 30000
open_files_limit = 500000
table_definition_cache = 30000
All system for education purposes only. For more tools: Telegram @jackleet