No cache version.

Caching disabled. Default setting for this page:enabled (code DEF204)
If the display is too slow, you can disable the user mode to view the cached version.

Rechercher dans le manuel MySQL

26.4.10 Determining What Is Instrumented

Contents

It is always possible to determine what instruments the Performance Schema includes by checking the setup_instruments table. For example, to see what file-related events are instrumented for the InnoDB storage engine, use this query:

  1. mysql> SELECT NAME, ENABLED, TIMED
  2.        FROM performance_schema.setup_instruments
  3.        WHERE NAME LIKE 'wait/io/file/innodb/%';
  4. +-------------------------------------------------+---------+-------+
  5. | NAME                                            | ENABLED | TIMED |
  6. +-------------------------------------------------+---------+-------+
  7. | wait/io/file/innodb/innodb_tablespace_open_file | YES     | YES   |
  8. | wait/io/file/innodb/innodb_data_file            | YES     | YES   |
  9. | wait/io/file/innodb/innodb_log_file             | YES     | YES   |
  10. | wait/io/file/innodb/innodb_temp_file            | YES     | YES   |
  11. | wait/io/file/innodb/innodb_arch_file            | YES     | YES   |
  12. | wait/io/file/innodb/innodb_clone_file           | YES     | YES   |
  13. +-------------------------------------------------+---------+-------+

An exhaustive description of precisely what is instrumented is not given in this documentation, for several reasons:

  • What is instrumented is the server code. Changes to this code occur often, which also affects the set of instruments.

  • It is not practical to list all the instruments because there are hundreds of them.

  • As described earlier, it is possible to find out by querying the setup_instruments table. This information is always up to date for your version of MySQL, also includes instrumentation for instrumented plugins you might have installed that are not part of the core server, and can be used by automated tools.


Find a PHP function
Error Infobrol

Can not display this page of the Infobrol website

Type of error (18-01)

Unknown format specifier "&"

Please try again in a few minutes…

Return to the home page




Steph