PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-statements-current-table.html
END_EVENT_ID This column is set to NULL when the event starts and updated to the thread current event number when the event ends. This enables you to check the source to determine exactly what code is involved. This value is computed in microseconds ...The table stores one row per thread showing the current status of the thread's most recent monitored statement event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-transactions-current-table.html
END_EVENT_ID This column is set to NULL when the event starts and updated to the thread current event number when the event ends. This is because immediately after the XA transaction is prepared, it is detached from the replication applier thread, ...The table stores one row per thread showing the current status of the thread's most recent monitored transaction event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-waits-current-table.html
END_EVENT_ID This column is set to NULL when the event starts and updated to the thread current event number when the event ends. This enables you to check the source to determine exactly what code is involved. For example, if a mutex or lock is ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-examples.html
The Performance Schema is a tool to help a DBA do performance tuning by taking real measurements instead of “wild guesses.” This section demonstrates some ways to use the Performance Schema for this purpose. At each iteration, the Performance ...The discussion here relies on the use of event filtering, which is described in Section 25.4.2, “Performance Schema Event ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-prepared-statements-instances-table.html
This is accessed through the MySQL C API and maps onto underlying server commands as shown in the following table. This is accessed using SQL statements and maps onto underlying server commands as shown in the following table. This table enables ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-applier-status-by-worker-table.html
If the replica is not multithreaded, this table shows the status of the applier thread. Otherwise, the replica uses multiple worker threads and a coordinator thread to manage them, and this table shows the status of the worker threads. The ...For a ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-instruments-table.html
This affects primarily mutexes, conditions, and rwlocks in the server, although there may be other instruments for which this is true. (Events do not really have a “name,” but this provides a way to associate events with instruments.) ENABLED ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-thread-filtering.html
This includes wait, stage, statement, and transaction events and affects logging to these tables: events_waits_history events_waits_history_long events_stages_history events_stages_history_long events_statements_history ... The threads table ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-timing.html
This section discusses the available timers and their characteristics, and how timing values are represented in events. For this reason, the conversion is a quick and fairly rough multiplication operation. This in turn causes those values to be ...
https://dev.mysql.com/doc/refman/5.7/en/replace.html
SELECT statements depend on the ordering of rows from the SELECT and this order cannot always be guaranteed, it is possible when logging these statements for the source and the replica to diverge. You should be aware that, if you do this, the ...