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 on 2013-05-31
-
Diff: 386 lines (+201/-128)1 file modifiedPercona-Server/sql/sql_show.cc (+201/-128)
- Vlad Lesin (community): Approve on 2013-05-31
-
Diff: 401 lines (+210/-134)1 file modifiedPercona-Server/sql/sql_show.cc (+210/-134)
- Vlad Lesin (community): Approve on 2013-05-31
-
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 |
Olaf van Zandwijk (olafz) wrote : | #2 |
This issue still exists in 5.5.18.
Howto reproduce: after enabling userstats and waiting for a while (on a busy server it might not take that long ;)) several counters run to the 32bit counter maximum:
mysql> SELECT ... FROM INFORMATION_
*******
BYTES_RECEIVED: 2147483647
BYTES_SENT: 2147483647
TABLE_ROWS_READ: 2147483647
etc.
Thank you. Originally I misunderstood the issue to be that counters have 32bit maxints upon server startup.
Changed in percona-server: | |
status: | Incomplete → Triaged |
assignee: | Laurynas Biveinis (laurynas-biveinis) → nobody |
The issue seems to be that even though the structures are unlonglong and longlong is stored, the schema seems to be MYSQL_TYPE_LONG
{"BYTES_
{"BYTES_SENT", MY_INT64_
{"BINLOG_
Also,
table-
table-
table-
So, MYSQL_TYPE_LONGLONG needs to used instead of MYSQL_TYPE_LONG and ulonglong instead of longlong in ->store()
Same for other fields and other similar tables.
tags: | added: overflow |
tags: | added: userstat |
tags: | added: i32205 |
Shahriyar Rzayev (rzayev-sehriyar) wrote : | #5 |
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/
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.