#
# 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/vmi288028.contaboserver.net.err
performance-schema=0
max_connections = 300
innodb_buffer_pool_size=134217728
max_allowed_packet=268435456
open_files_limit=40000
innodb_file_per_table=1
unix_socket=OFF

# Sorting optimization
sort_buffer_size=4M  # Increased sort buffer to handle ORDER BY more efficiently

# Query cache (if applicable for MySQL version)
query_cache_size=64M
query_cache_limit=2M

innodb_buffer_pool_size=2G
tmp_table_size=64M
max_heap_table_size=64M
plugin-load-add=auth_socket.so

log_slow_query=0
log_slow_query_file="/var/lib/mysql/slow_query.log"
log_slow_query_time=1000 # Time threshold for slow queries (in seconds)
log_queries_not_using_indexes = 1 # Log queries that do not use indexes