Bug #70697 Performance Schema events_statements_summary_by_digest.row_size issue
Submitted: 23 Oct 2013 10:43 Modified: 4 Nov 2013 8:19
Reporter: Mahesh Patil Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Performance Schema Severity:S3 (Non-critical)
Version:5.6.14 OS:Linux
Assigned to: Marc ALFF CPU Architecture:Any
Tags: Performace schema

[23 Oct 2013 10:43] Mahesh Patil 
Description:
Row size value from 
SHOW ENGINE `performance_schema` STATUS;

should match with 

Select count(*) from events_statements_summary_by_digest;

How to repeat:
Execute these queries and compare output:

SELECT COUNT(*) FROM `events_statements_summary_by_digest`;

and 

SHOW ENGINE `performance_schema` STATUS; and see value for 
events_statements_summary_by_digest.row_size 

I think they both should return same value .. isn't it? 

Suggested fix:
Value should be same as count(*) from events_statements_summary_by_digest
[25 Oct 2013 10:53] MySQL Verification Team 
Hello Mahesh,

Thank you for the report.

Thanks,
Umesh
[4 Nov 2013 8:19] Marc ALFF 
SHOW ENGINE PERFORMANCE_SCHEMA STATUS reports in 'xxx.row_size' the size of the internal buffer used for the row.

This is documented in :
http://dev.mysql.com/doc/refman/5.6/en/show-engine.html

row_size has nothing to do with select count(*).

Not a bug, works as expected.