All posts by Mayank Prasad

About Mayank Prasad

Mayank is working as a MySQL developer and specifically works in MySQL- Performance Schema developments. View all posts by Mayank Prasad →

MySQL 8.0: Performance Schema Instrumentation of Server Errors

September 19, 2016MySQL, Performance SchemaMayank Prasad

In MySQL 8.0.0, the Performance Schema can now instrument server errors. There are 5 new summary tables introduced:

mysql> show tables like "%by_error%";
+-------------------------------------------+
| Tables_in_performance_schema (%by_error%) |
+-------------------------------------------+
| events_errors_summary_by_account_by_error |
| events_errors_summary_by_host_by_error    |
| events_errors_summary_by_thread_by_error  |
| events_errors_summary_by_user_by_error    |
| events_errors_summary_global_by_error     |
+-------------------------------------------+
5 rows in set (0.02 sec)

mysql> show tables like "%by_error%";

+-------------------------------------------+

| Tables_in_performance_schema (%by_error%) |

+-------------------------------------------+

| events_errors_summary_by_account_by_error |

| events_errors_summary_by_host_by_error |

| events_errors_summary_by_thread_by_error |

| events_errors_summary_by_user_by_error |

| events_errors_summary_global_by_error |

+-------------------------------------------+

5 rows in set (0.02 sec)

As names suggest, statistics of errors in these tables are aggregated by error.…

New in MySQL 5.7: Performance Schema scalable memory allocation

February 11, 2016MySQL, Performance SchemaMayank Prasad

Performance Schema is a mechanism to collect and report run time statistics for running MySQL server. These statistics are stored-in and fetched-from internal memory buffers. In MySQL 5.6 GA, memory for these buffers is allocated during MySQL server startup with either user specified configuration values or with default values that autosize.…

MySQL Statement Digests

March 25, 2015MySQL, Performance Schemaperformance schemaMayank Prasad

Decoupling Statement Digests From Performance Schema

MySQL Statement Digests are a feature originally introduced as part of the MySQL Performance Schema in MySQL 5.6 to aggregate statement statistics based on the normalized statements executed within the server (for additional info, see here).…

MySQL Statement Digests: Configurable Max Lengths

March 24, 2015MySQL, Performance Schemaperformance schemaMayank Prasad

Digest calculations are done based on the tokens found in the statement text.…

MySQL Performance Schema: Instrumentation Exceptions

March 23, 2015MySQL, Performance Schemaperformance schemaMayank Prasad

The setup_actors table in MySQL Performance Schema can be used to specify what users and hosts one wants to have instrumentation enabled for. By default, connections from all users and hosts are instrumented:

mysql> select * from performance_schema.setup_actors;
+------+------+------+
| HOST | USER | ROLE |
+------+------+------+
| %    | %    | %    |
+------+------+------+
1 row in set (0.00 sec)

mysql> select * from performance_schema.setup_actors;

+------+------+------+

| HOST | USER | ROLE |

+------+------+------+

| % | % | % |

+------+------+------+

1 row in set (0.00 sec)

You can then use standard SQL against this setup_actors table in order to specify what users and hosts you want to have instrumentation enabled for.

…

MySQL Performance Schema : Prepared Statements Instrumentation

April 4, 2014Performance Schema, Prepared StatementsMayank Prasad

MySQL 5.7.4 has a new Performance Schema feature, namely instrumentation for prepared statements. This instrumentation gives details of PREPARE and EXECUTE statistics for a prepared statement.

New Table
New table added to display run time statistics of Prepared Statements is named as prepared_statements_instances.…

Performance Schema implementation Internals: Registering instruments

January 23, 2014MySQL, Performance, Performance Schemaperformance schemaMayank Prasad

This is the very first post in the series of Performance Schema Implementation Internals. This series is for MySQL Developers to understand implementation of Performance Schema. For user point of view of performance Schema, please refer to mysql documentation link : http://dev.mysql.com/doc/refman/5.7/en/performance-schema-quick-start.html

This post talks about the mechanism to register instruments in Performance Schema (referred as P_S from hereon) so that their statistics could be collected at runtime.…

MySQL Server Blog

News from the MySQL Server Team

All posts by Mayank Prasad

About Mayank Prasad

MySQL 8.0: Performance Schema Instrumentation of Server Errors

New in MySQL 5.7: Performance Schema scalable memory allocation

MySQL Statement Digests

Decoupling Statement Digests From Performance Schema

MySQL Statement Digests: Configurable Max Lengths

MySQL Performance Schema: Instrumentation Exceptions

MySQL Performance Schema : Prepared Statements Instrumentation

Performance Schema implementation Internals: Registering instruments