PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-filtering-names.html
For example, to select all file I/O instruments, it is better to use a pattern that includes the entire instrument name prefix: ... To check which instrument or consumer names a pattern matches, perform a simple test: SELECT NAME FROM ... Names ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-obtaining-parent-events.html
The following scenario illustrates how to find the parent transaction of a statement in which a lock was taken: Session A: [1] START TRANSACTION; [2] SELECT * FROM t1 WHERE pk = 1; [3] SELECT 'Hello, world'; Session B: SELECT ... Rows of this table ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-queries.html
By contrast, post-filtering is performed by individual users through the use of queries with appropriate WHERE clauses that restrict what event information to select from the events available after pre-filtering has been applied. Pre-filtering ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-table-characteristics.html
Privileges are as for other databases and tables: To retrieve from performance_schema tables, you must have the SELECT privilege. The name of the performance_schema database is lowercase, as are the names of tables within it. Many tables in the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-tp-thread-group-state-table.html
This is the same as MAX(TP_THREAD_NUMBER) for the threads when selected from the tp_thread_state table. That is, these two queries are equivalent: SELECT TP_GROUP_ID, MAX_THREAD_IDS_IN_GROUP FROM tp_thread_group_state; SELECT TP_GROUP_ID, ... Note ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-transaction-tables.html
To selectively examine transaction history, use the attribute columns in the transaction event tables: ACCESS_MODE, ISOLATION_LEVEL, and AUTOCOMMIT. Within the event hierarchy, wait events nest within stage events, which nest within statement ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-variables-info-table.html
The variables_info table shows, for each system variable, the source from which it was most recently set, and its range of values. VARIABLE_SOURCE The source from which the variable was most recently set: COMMAND_LINE The variable was set on the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-wait-tables.html
The Performance Schema instruments waits, which are events that take time. Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within transaction events. These tables store wait events: ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-expressions.html
(See Section 7.1.11, “Server SQL Modes”.) The following discussion mentions strict mode (selected by the STRICT_ALL_TABLES or STRICT_TRANS_TABLES mode values) and ERROR_FOR_DIVISION_BY_ZERO. With precision math, exact-value numbers are used as ...
https://dev.mysql.com/doc/refman/8.0/en/prepare.html
This can happen, for example, when the parameter is a top-level node in a SELECT list, or when it is part of a comparison operator. If a parameter is an immediate member of a SELECT list that is not part of an INSERT statement, the derived type of ... PREPARE stmt_name FROM preparable_stmt The PREPARE statement prepares a SQL statement and assigns it a name, stmt_name, by which to refer to the statement ...