| Bug #91396 | Sys Schema reports negative memory use by session | ||
|---|---|---|---|
| Submitted: | 24 Jun 2018 23:47 | Modified: | 25 Jun 2018 5:00 |
| Reporter: | Peter Zaitsev | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server: Performance Schema | Severity: | S3 (Non-critical) |
| Version: | 8.0.11 | OS: | Linux |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | sys_schema | ||
[25 Jun 2018 5:00]
MySQL Verification Team
Hello Peter, Thank you for the report and feedback. This is already reported by our Shane Bug #80523, please see Bug #80523. Marking as duplicate for now. Regards, Umesh
Description: running select * from sys.session I observe many negative memory usage: *************************** 128. row *************************** thd_id: 254 conn_id: 214 user: root@localhost db: tpcc command: Query state: update time: 0 current_statement: INSERT INTO orders3 ... ES (3424,8,68,1773,NOW(),15,1) statement_latency: 14.53 ms progress: NULL lock_latency: 6.67 ms rows_examined: 0 rows_sent: 0 rows_affected: 0 tmp_tables: 0 tmp_disk_tables: 0 full_scan: NO last_statement: NULL last_statement_latency: NULL current_memory: -132145 bytes last_wait: NULL last_wait_latency: NULL source: NULL trx_latency: 22.15 ms trx_state: ACTIVE trx_autocommit: NO pid: 3892 program_name: NULL How to repeat: In this case I'm running sysbench_tpcc but I have seen it with other workloads too.