Service Introduction

This service is named as pfs_plugin_table and it exposes two major methods which are

• add_tables : plugin/component to add tables in performance schema
• delete_tables : plugin/component to delete tables from performance schema

There are three major actors in its implementation:

• PFS_engine_table_proxy
  This structure is collection of function pointers which are to be implemented by plugins/components who wish to expose table in performance_schema.
• PFS_engine_table_share_proxy
  This structure is to keep the required information which would be used to register a table in performance_schema. Table share in pfs would be initialized using instance of PFS_engine_table_share_proxy and it would be passed by plugin while registering table.
• Table_Handle
  An instance of this structure will be created when a table is opened in performance_schema. This will be used to keep current status of table during operation being performed on table.

Diagram

Following diagram shows the block diagram of PFS services functionality, to add a plugin table in performance schema, exposed via mysql-server component.