Consistently limited I/O bandwidth out of Percona Server 8.0

MySQL & MariaDB Other MySQL® Questions
1

Hi there,

When running Percona Server for MySQL 8.0 with TPC-C workloads on Linux, we consistently seeing very limited I/O (40MB/s read, 40MB/s write) out of Percona Server. Could someone help with this issue? thanks.

  1. specifically, our configuration is:
    skip_name_resolve
    table_open_cache = 200000
    table_open_cache_instances=64
    back_log=3500
    max_connections = 4000

innodb_log_file_size=10G # different: 512MB

innodb_buffer_pool_size = 1G # different 512M
innodb_log_buffer_size=64M # different

innodb_flush_method=O_DIRECT_NO_FSYNC #different: fsync
innodb_adaptive_flushing = 0 # same
innodb_flush_neighbors = 0 # same

max_prepared_stmt_count=1000000 # different: 16382

innodb_doublewrite=ON # undo log: default ON, open
server_id=master-01
log_bin

  1. the problem we saw: there is consistent low IO bandwidth out of Percona Server (40MB/s read, 40MB/s write); which is far from the limit of the disk.

Could someone provide suggestions on this? thanks

2

Hi kanwum,

Try to add the following values:

innodb_io_capacity = 15000
innodb_io_capacity_max = 30000

Depends on your system, though. This should speed up things a little bit.