[MDEV-17436] Add new meta system configuration variables Created: 2018-10-12  Updated: 2018-10-29

Status: Open
Project: MariaDB Server
Component/s: Configuration, Optimizer, Storage Engine - InnoDB, Storage Engine - RocksDB
Fix Version/s: None

Type: Task Priority: Major
Reporter: VAROQUI Stephane Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-350 self-tuning cost coefficients Stalled
relates to MDEV-17213 range optimizer costly filesort on in... Open

 Description   

Many part of the mariadb architecture would benefit to know what type of storage is used

system_disk_type =[SPINNING | SSD | NVME | NETWORK]
system_disk_io_capacity
system_disk_latency

Such variables can be used to deprecate or facilitate dynamic config of many
InnoDB and MyRock variables

innodb_write_io_threads = auto set
innodb_io_capacity = auto set
innodb_io_capacity_max = auto set
innodb_flush_neighbors = auto set

but also inside the optimizer to compute better ordered scan computation sorting for clustered range.



 Comments   
Comment by Sergei Golubchik [ 2018-10-29 ]

I'd personally prefer to autodetect that. For example, via MDEV-350

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