File manager

File manager - Edit - /etc/my.cnf.bak

Back
[mysqld] performance-schema=0 innodb_file_per_table=1 # Ensure that each innodb table is it's own binary data block just in case there's corruption. query_cache_size=64M thread_cache_size=4 # can be increased on servers with large numbers of active users key_buffer_size=32M max_allowed_packet=268435456 table_open_cache=512 # max 2048, can be increased if more Opened tables - SHOW STATUS LIKE 'Opened_tables'; wait_timeout=300 # can be increased if using persistent connections max_user_connections=25 open_files_limit=40000 #delayed_insert_timeout=20 # Turn on if max_connections being reached due to delayed inserts #delayed_queue_size=300 # Turn on if max_connections being reached due to delayed inserts myisam_sort_buffer_size=2M # can be increased per sessions if needed for alter tables (indexes, repair) #query_cache_limit=2M # leave at default unless there is a good reason #join_buffer=2M # leave at default unless there is a good reason #sort_buffer_size=2M # leave at default unless there is a good reason #read_rnd_buffer_size=256K # leave at default unless there is a good reason #read_buffer_size=2M # leave at default unless there is a good reason collation_server=utf8_unicode_ci character_set_server=utf8 #innodb_flush_method=O_DSYNC # Do not enable this without a good reason - it doesn't work well on new dedis innodb_buffer_pool_size=128M # check mysql -e "SHOW GLOBAL STATUS LIKE 'Innodb_buffer_pool%';" - free vs total innodb_thread_concurrency=16 # Number of physical + virtual CPU's, be careful of adding more tmp_table_size=768M max_heap_table_size=768M max_connections=150 # Should be between 100-150, increase slowly because it causes MySQL to consume more memory! table_definition_cache=512 # increase by the same factor as table_open_cache innodb_flush_log_at_trx_commit=2 innodb_log_buffer_size=64M general_log=0 slow_query_log=0 log-output=TABLE # select * from mysql.general_log order by event_time desc limit 10; long_query_time=20 # select * from mysql.slow_log order by start_time desc limit 10; innodb_io_capacity=100

| ver. 1.4 | . | PHP 8.1.32 | Generation time: 0 | proxy | phpinfo | Settings