• 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)
  • Plugin Author Anton Aleksandrov

    (@antonaleksandrov)

    try changing

    innodb_buffer_pool_instances=2

    try disabling last 2 lines:

    #!includedir /etc/mysql/conf.d/
    #!includedir /etc/mysql/mariadb.conf.d/

    remember to restart mysql to apply changes 😉

Viewing 1 replies (of 1 total)

The topic ‘Importing large amount of data to database’ is closed to new replies.