Not the answer you need?
Register and ask your own question!

Consistently limited I/O bandwidth out of Percona Server 8.0

kanwukanwu EntrantCurrent User Role Novice
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



2) 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

Comments

  • Woll-EWoll-E Entrant Current User Role Novice
    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.