32bit counters in user statistics
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Medium
|
Laurynas Biveinis | ||
5.1 |
Fix Released
|
Medium
|
Laurynas Biveinis | ||
5.5 |
Fix Released
|
Medium
|
Laurynas Biveinis | ||
5.6 |
Fix Released
|
Medium
|
Laurynas Biveinis |
Bug Description
Hi,
Percona Server 11.6 on RHEL5 64bit (from RPM)
Note the numbers for s lot of counters from SHOW USER STATISTICS are showing as max 32bit integer.
I'm observing same behavior for show table_statistics for number of rows x number of indexes. show index_statistics is also affected
Total_
Concurrent_
Binlog_
Commit_
Rollback_
Denied_
Lost_
I
Related branches
- Vlad Lesin (community): Approve
-
Diff: 386 lines (+201/-128)1 file modifiedPercona-Server/sql/sql_show.cc (+201/-128)
- Vlad Lesin (community): Approve
-
Diff: 401 lines (+210/-134)1 file modifiedPercona-Server/sql/sql_show.cc (+210/-134)
- Vlad Lesin (community): Approve
-
Diff: 748 lines (+346/-270)2 files modifiedPercona-Server/mysql-test/suite/funcs_1/r/is_columns_is.result (+136/-136)
Percona-Server/sql/sql_show.cc (+210/-134)
Changed in percona-server: | |
status: | New → Confirmed |
importance: | Undecided → Medium |
tags: | added: low-hanging-fruit |
Changed in percona-server: | |
status: | Confirmed → Triaged |
Changed in percona-server: | |
assignee: | nobody → Laurynas Biveinis (laurynas-biveinis) |
Changed in percona-server: | |
status: | Triaged → In Progress |
Changed in percona-server: | |
status: | In Progress → Incomplete |
tags: | added: overflow |
tags: | added: userstat |
tags: | added: i32205 |
What exact commands should reproduce this? running= ON; SCHEMA. USER_STATISTICS ;
If I do
SET GLOBAL userstat_
then immediately
SHOW USER_STATISTICS;
SELECT * FROM INFORMATION_
I see zeros and not 32-bit uint max values there, same for other stat tables.