Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
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.
Attachments
Issue Links
- relates to
-
MDEV-350 self-tuning cost coefficients
- Stalled
-
MDEV-17213 range optimizer costly filesort on indexed column
- Open