[MDEV-6114] merge new P_S instrumentation and tables from 5.7 Created: 2014-04-15  Updated: 2021-02-24  Resolved: 2020-11-13

Status: Closed
Project: MariaDB Server
Component/s: Performance Schema
Fix Version/s: 10.5.2

Type: Task Priority: Critical
Reporter: Sergei Golubchik Assignee: Sergei Golubchik
Resolution: Fixed Votes: 14
Labels: None

Issue Links:
Duplicate
duplicates MDEV-9067 performance_schema from 5.7 Closed
PartOf
includes MDEV-16340 Implement way to determine which conn... Closed
includes MDEV-16431 merge 5.7 P_S memory instrumentation ... Closed
includes MDEV-16432 merge 5.7 P_S mdl instrumentation and... Closed
includes MDEV-16433 merge 5.7 P_S ps instrumentation and ... Closed
includes MDEV-16434 merge 5.7 P_S sp instrumentation and ... Closed
includes MDEV-16435 merge 5.7 P_S transaction instrumenta... Closed
includes MDEV-16436 merge 5.7 P_S sxlocks instrumentation... Closed
includes MDEV-16437 merge 5.7 P_S replication instrumenta... Closed
includes MDEV-16438 merge 5.7 P_S [show] status instrumen... Closed
includes MDEV-16439 merge 5.7 P_S user variables instrume... Closed
includes MDEV-16440 merge 5.7 P_S sysvars instrumentation... Stalled
Relates
relates to MDEV-16437 merge 5.7 P_S replication instrumenta... Closed
relates to MDEV-16441 merge 5.7 P_S group replication instr... Closed
relates to MDEV-24310 Implement option to allow performance... Open
relates to MDEV-15798 Mutex leak on accessing INFORMATION_S... Closed
relates to MDEV-24388 Implement schema_unused_indexes in pe... Closed
Sprint: 10.2.2-1, 10.2.2-3, 10.2.2-4

 Description   

Meta task to merge new P_S instrumentation and tables from 5.7

See linked tasks. After they're all closed, one still needs to compare tables and their structures with 5.7 and to implement whatever was not covered by linked tasks.

Done and released with MariaDB 10.5.2 everything except:

  • sysvars instrumentation
  • replication instrumentation
  • group replication Instrumentation

 Comments   
Comment by guo feng [ 2015-11-26 ]

Hope sys schema comes soon!

Comment by Chris Calender (Inactive) [ 2016-08-10 ]

Can this fix please be added to 10.1 instead of 10.2?

I don't think it should matter so long as only new tables are being added.

Many thanks for your consideration.

Comment by Sergei Golubchik [ 2016-08-14 ]

No, it can not. "Adding new P_S tables" means doing lots of changes inside the server to all all the necessary instrumentation.

Comment by Jonathan Day (Inactive) [ 2016-08-18 ]

I have a large prospect interested in tracking prepared statements. I believe the "prepared_statements_instance" table is needed in particular. Thanks!

Comment by Marko Mäkelä [ 2019-02-05 ]

As part of doing this, I suggest considering the patch that is attached to MDEV-15798. It removes InnoDB rw_lock_list, the table information_schema.innodb_mutexes and the show engine innodb mutex output.

Generated at Thu Feb 08 07:09:28 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.