[MDEV-22427] Unrealistic Rows_read status variable jumps Created: 2020-04-30  Updated: 2020-04-30

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

Type: Bug Priority: Major
Reporter: Louka Dlagnekov (Inactive) Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

MariaDB 10.1.44 server

Issue Links:
Relates
relates to MDEV-16083 Implausible high "Binlog_bytes_writte... Open

 Description   

We noticed that when trying to perform a mysqldump on a MariaDB server running a TPCC benchmark, there was a huge spike in rows read even though the dump took a long time.

timestamp Rows_read Uptime
2020-04-22 09:01:11.888041 1216156692 1591609
2020-04-22 09:01:16.953039 1216156692 1591614
2020-04-22 09:01:22.023961 2545979866 1591619
2020-04-22 09:01:27.092528 2545982976 1591625

This is closely related to this issue but with a different status variable.

Performance schema is turned on in that database if that is useful for debugging the issue.
Generated at Thu Feb 08 09:14:39 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.