[MDEV-22860] Change EXAMINED_ROWS in I_S.PROCESSLIST from INT to BIGINT UNSIGNED Created: 2020-06-10 Updated: 2023-09-26 Resolved: 2023-09-26 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | N/A |
| Fix Version/s: | N/A |
| Type: | Task | Priority: | Major |
| Reporter: | Hartmut Holzgraefe | Assignee: | Daniel Black |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||||||||||||||
| Description |
|
Currently the EXAMINED_ROWS column in INFORMATION_SCHEMA.PROCESSLIST is of type INT, so limited to 2^31, or about two billion max. When doing an UPDATE that requires a full table scan on a table with more than two billion rows, EXAMINED_ROWS value for that session goes up to 2147483647 but then stops at that value even though the query is still scanning more rows. |
| Comments |
| Comment by Daniel Black [ 2023-09-20 ] |
|
For review, https://github.com/MariaDB/server/pull/2767 |