Importing large amount of data to database
-
Hi, I have 2 server (Hyper-v VM with 16 vcore and 16 Gb Ram) with MariaDB 10.6.11 but both have a bad value on “Importing large amount of data to database”,
This is my configuration:[client]
port=3306
socket=/run/mysqld/mysqld.sock
[mysqld_safe]
socket=/run/mysqld/mysqld.sock
[mysqld]
user=mysql
pid-file=/run/mysqld/mysqld.pid
socket=/run/mysqld/mysqld.sock
port=3306
basedir=/usr
datadir=/var/lib/mysql
tmpdir=/tmp
lc-messages-dir=/usr/share/mysql
log_error=/var/log/mysql/error.log
symbolic-links=0
local-infile=0
innodb_flush_log_at_trx_commit=0
innodb_file_per_table=1
innodb_thread_concurrency=0
innodb_buffer_pool_size=4G
innodb_buffer_pool_instances=8
innodb_log_file_size=512M
query_cache_type=1
query_cache_limit=128K
query_cache_size=64M
query_cache_min_res_unit=512
performance_schema=0
sql-mode="NO_ENGINE_SUBSTITUTION"
innodb_log_buffer_size=512M
disable_log_bin
innodb_io_capacity = 2000
innodb_io_capacity_max = 5000
innodb_checksum_algorithm = crc32
innodb_log_compressed_pages=OFF
innodb_change_buffering=all
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/Do you have any advice?
Thank you a lot!
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
The topic ‘Importing large amount of data to database’ is closed to new replies.