Bug #100624 | Total memory allocation for P_S is different in different sources | ||
---|---|---|---|
Submitted: | 24 Aug 2020 15:05 | Modified: | 25 Aug 2020 5:48 |
Reporter: | Valeriy Kravchuk | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Performance Schema | Severity: | S3 (Non-critical) |
Version: | 5.7.30, 8.0.21, 5.7.31 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[24 Aug 2020 15:05]
Valeriy Kravchuk
[25 Aug 2020 5:48]
MySQL Verification Team
Hello Valeriy, Thank you for the report and feedback. Verified as described. regards, Umesh
[25 Aug 2020 5:49]
MySQL Verification Team
- 5.7.31 bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e"select sum(SUM_NUMBER_OF_BYTES_ALLOC) alloc, sum(SUM_NUMBER_OF_BYTES_FREE) free, sum(CURRENT_NUMBER_OF_BYTES_USED) used from performance_schema.memory_summary_global_by_event_name where event_name like 'memory/performance%'" +-----------+------+-----------+ | alloc | free | used | +-----------+------+-----------+ | 137641608 | 0 | 137641608 | +-----------+------+-----------+ bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e"show engine performance_schema status\G" | tail -4 *************************** 229. row *************************** Type: performance_schema Name: performance_schema.memory Status: 137640120 - 8.0.21 bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e"select sum(SUM_NUMBER_OF_BYTES_ALLOC) alloc, sum(SUM_NUMBER_OF_BYTES_FREE) free, sum(CURRENT_NUMBER_OF_BYTES_USED) used from performance_schema.memory_summary_global_by_event_name where event_name like 'memory/performance%'" +-----------+------+-----------+ | alloc | free | used | +-----------+------+-----------+ | 218186480 | 0 | 218186480 | +-----------+------+-----------+ bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e"show engine performance_schema status\G" | tail -4 *************************** 243. row *************************** Type: performance_schema Name: performance_schema.memory Status: 188071536