[MDEV-14006] SUGGESTION: Deafult MariaDB Server Configuration Variables - Created: 2017-10-05  Updated: 2017-10-06

Status: Open
Project: MariaDB Server
Component/s: None
Fix Version/s: None

Type: Task Priority: Major
Reporter: Juan Telleria Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: innodb


 Description   

Dear MariaDB Developers,

I am writing to suggest that MariaDB changes its default innodb_read[write]_io_threads default value in order to obtain a better default performance out-of-the-box.

Nowadays, many computers use SSD, or high-speed HDD, so default value, 4, is certainly low.
It should be, in my opinion:

  • innodb_read_io_threads = 8
  • innodb_write_io_threads = 8

And in the Windows / Linux MariaDB installer, just as innodb_buffer_pool_size is configured depending on the Server, this values shall be increased to:

  • innodb_read_io_threads = 16
  • innodb_write_io_threads = 16

This is of special importance, as MariaDB uses from 10.2 engine InnoDB, and not XtraDB, and this is the bottleneck which prevents InnoDB having the same performance than XtraDB.

Thank you,
Juan

 Comments   
Comment by Vladislav Vaintroub [ 2017-10-05 ]

Can you give an example benchmark on Windows, that would benefit from increasing number of threads that much. I never noticed that number of threads would be a bottleneck, but perhaps I was mistaken.

Comment by Juan Telleria [ 2017-10-06 ]

8 is the number of io read/write threads I think Percona Server uses, although I might be wrong.

Here is a Percona Server benchmark:

Percona Server 5.7 performance improvements

A closer look at Percona Server 5.6

I personally benefit from it, because in InnoDB I have the logs in one Hard Drive, and Data in another. And my Server has 12 cores. Maybe in a personal computer MariaDB installation, such configuration should not be so critical, or even counterproductive.

Also, I understood that putting both values in 16 is better for SSD disks.

Hope to help,
Juan

Comment by Vladislav Vaintroub [ 2017-10-06 ]

asynchronous IO on Windows is different than on Linux, and in mariadb async IO on Windows is different and more efficient that in MySQL. Percona does not run on Windows, so those benchmarks are not very relevant

Generated at Thu Feb 08 08:10:10 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.