Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [client]
- socket=MYSQL
- port=3306
- [mysql]
- no-beep
- [mysqld]
- enable-named-pipe
- shared-memory
- shared-memory-base-name=MYSQL
- socket=MYSQL
- port=3306
- datadir=C:/ProgramData/MySQL/MySQL Server 8.0/Data
- default_authentication_plugin=mysql_native_password
- default-storage-engine=INNODB
- sql-mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,TRADITIONAL,ERROR_FOR_DIVISION_BY_ZERO,STRICT_ALL_TABLES"
- default-time-zone='-7:00'
- log-output=FILE
- general-log=1
- general_log_file="DANTE-PC.log"
- slow-query-log=1
- slow_query_log_file="DANTE-PC-slow.log"
- long_query_time=1
- log-error="DANTE-PC.err"
- log-bin="DANTE-PC-bin"
- event_scheduler=OFF
- server-id=1
- report_port=3306
- lower_case_table_names=2
- secure-file-priv="C:/ProgramData/MySQL/MySQL Server 8.0/Uploads"
- max_connections=151
- table_open_cache=2000
- tmp_table_size=47M
- thread_cache_size=25
- myisam_max_sort_file_size=100G
- myisam_sort_buffer_size=84M
- key_buffer_size=20M
- read_buffer_size=64K
- read_rnd_buffer_size=256K
- innodb_flush_log_at_trx_commit=1
- innodb_buffer_pool_size=1024M
- innodb_buffer_pool_instances=8
- innodb_log_buffer_size=1M
- innodb_log_file_size=48M
- innodb_thread_concurrency=4
- innodb_autoextend_increment=64
- innodb_concurrency_tickets=5000
- innodb_old_blocks_time=1000
- innodb_open_files=300
- innodb_stats_on_metadata=0
- innodb_file_per_table=1
- innodb_checksum_algorithm=0
- back_log=80
- flush_time=1
- mysqlx_interactive_timeout=1
- mysqlx_wait_timeout=1
- interactive_timeout=1
- wait_timeout=1
- mysqlx_idle_worker_thread_timeout=1
- lock_wait_timeout=60
- rpl_stop_slave_timeout=90
- join_buffer_size=256K
- max_allowed_packet=4M
- max_connect_errors=100
- open_files_limit=41610
- sort_buffer_size=256K
- table_definition_cache=1400
- binlog_row_event_max_size=8K
- sync_master_info=10000
- sync_relay_log=10000
- sync_relay_log_info=10000
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement