MySQL Forums
Forum List  »  InnoDB

Re: Slow inserts/restore from backup
Posted by: Michal Koscielny
Date: January 02, 2019 03:18PM

Here they are, I stripped comment lines.

MySQL 5.7:

[client]
port=3306

[mysql]
no-beep=
default-character-set=utf8

[mysqld]
port=3306
datadir=C:\db-data\mysql\5.7
character-set-server=utf8
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
log-output=FILE
general-log=0
general_log_file="DESKTOP-B2ON84C.log"
slow-query-log=1
slow_query_log_file="DESKTOP-B2ON84C-slow.log"
long_query_time=10
log-error="DESKTOP-B2ON84C.err"
server-id=1
secure-file-priv="C:/ProgramData/MySQL/MySQL Server 5.7/Uploads"
max_connections=151
table_open_cache=2000
thread_cache_size=10
myisam_max_sort_file_size=100G
innodb_flush_log_at_trx_commit=1
innodb_log_file_size=48M
innodb_thread_concurrency=9
innodb_autoextend_increment=64
innodb_concurrency_tickets=5000
innodb_old_blocks_time=1000
innodb_stats_on_metadata=0
innodb_file_per_table=1
innodb_checksum_algorithm=0
back_log=80
flush_time=0
join_buffer_size=256K
max_allowed_packet=40M
max_connect_errors=100
open_files_limit=4161
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


--------------------------
MySQL 8.0:

[client]
port=3308

[mysql]
no-beep

[mysqld]
port=3308
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"
log-output=FILE
general-log=0
general_log_file="DESKTOP-B2ON84C.log"
slow-query-log=1
slow_query_log_file="DESKTOP-B2ON84C-slow.log"
long_query_time=10
log-error="DESKTOP-B2ON84C.err"
server-id=1
lower_case_table_names=1
secure-file-priv="C:/ProgramData/MySQL/MySQL Server 8.0/Uploads"
max_connections=151
table_open_cache=2000
tmp_table_size=31M
thread_cache_size=10
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=54M
key_buffer_size=8M
read_buffer_size=64K
read_rnd_buffer_size=256K
innodb_flush_log_at_trx_commit=1
innodb_log_file_size=48M
innodb_thread_concurrency=9
innodb_autoextend_increment=64
innodb_concurrency_tickets=5000
innodb_old_blocks_time=1000
innodb_stats_on_metadata=0
innodb_file_per_table=1
innodb_checksum_algorithm=0
back_log=80
flush_time=0
join_buffer_size=256K
max_allowed_packet=4M
max_connect_errors=100
open_files_limit=4161
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
loose_mysqlx_port=33060
skip-log-bin

Options: ReplyQuote


Subject
Views
Written By
Posted
353
October 02, 2018 02:55AM
Re: Slow inserts/restore from backup
155
January 02, 2019 03:18PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.