InnoDB read ahead still active with random_read_ahead OFF
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
New
|
Undecided
|
Unassigned |
Bug Description
Hi,
In Percona 5.7, it seems even with innodb_
mysql> show global variables LIKE '%innodb_version%';
+------
| Variable_name | Value |
+------
| innodb_version | 5.7.18-14 |
+------
1 row in set (0.00 sec)
mysql> show global variables LIKE '%ahead%';
+------
| Variable_name | Value |
+------
| innodb_
| innodb_
| innodb_
+------
3 rows in set (0.00 sec)
mysql> show global status LIKE '%ahead%';
+------
| Variable_name | Value |
+------
| Innodb_
| Innodb_
| Innodb_
+------
3 rows in set (0.00 sec)
mysql> show global status LIKE '%ahead%';
+------
| Variable_name | Value |
+------
| Innodb_
| Innodb_
| Innodb_
+------
Is this expected?
Thanks and regards,
Jocelyn Fournier
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PS-3707