🚀 Advanced Web Server Manager
Complete File Manager & Terminal - Standalone Version
By Sid Gifari | Gifari Industries
Current path:
/
/
etc
✏️
Editing: my.cnf
# For advice on how to change settings please see # http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html [mysqld] long_query_time = 2 slow_query_log_file = /var/log/mysql/mysql-slow.log slow_query_log = ON # disable-log-bin=1 default-authentication-plugin=mysql_native_password # performance-schema=0 # # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128M # # Remove the leading "# " to disable binary logging # Binary logging captures changes between backups and is enabled by # default. It's default setting is log_bin=binlog # disable_log_bin # # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M # # Remove leading # to revert to previous value for default_authentication_plugin, # this will increase compatibility with older clients. For background, see: # https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin # default-authentication-plugin=mysql_native_password datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock performance-schema = 0 sql_mode = NO_ENGINE_SUBSTITUTION event_scheduler = off max_connections = 200 max_user_connections = 50 wait_timeout = 100 interactive_timeout = 150 sort_buffer_size = 1M innodb_buffer_pool_size=8G default-storage-engine = InnoDB default-tmp-storage-engine = InnoDB disable-log-bin = 1 mysqlx = 0 log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid # innodb_buffer_pool_size=8192M max_allowed_packet=268435456 open_files_limit=80000 innodb_file_per_table=1 # mysqlx=0 tmp_table_size=1281M innodb_buffer_pool_instances=13 max_heap_table_size=1281M innodb_log_file_size=3328M join_buffer_size=1M key_buffer_size=369M
💾 Save Changes
❌ Cancel