MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 201 to 208 of 208 total results

« Previous
19
20
21
Next »

30.4.4.6 The ps_setup_disable_instrument() Procedure

https://dev.mysql.com/doc/refman/9.7/en/sys-ps-setup-disable-instrument.html

Parameters in_pattern VARCHAR(128): The value used to match instrument names, which are identified by using %in_pattern% as an operand for a LIKE pattern match. Disables Performance Schema instruments with names that contain the argument. Example ...

30.4.4.9 The ps_setup_enable_consumer() Procedure

https://dev.mysql.com/doc/refman/9.7/en/sys-ps-setup-enable-consumer.html

Parameters consumer VARCHAR(128): The value used to match consumer names, which are identified by using %consumer% as an operand for a LIKE pattern match. Enables Performance Schema consumers with names that contain the argument. Example Enable all ...

30.4.4.10 The ps_setup_enable_instrument() Procedure

https://dev.mysql.com/doc/refman/9.7/en/sys-ps-setup-enable-instrument.html

Parameters in_pattern VARCHAR(128): The value used to match instrument names, which are identified by using %in_pattern% as an operand for a LIKE pattern match. Enables Performance Schema instruments with names that contain the argument. Example ...

30.4.4.22 The ps_trace_statement_digest() Procedure

https://dev.mysql.com/doc/refman/9.7/en/sys-ps-trace-statement-digest.html

Traces all Performance Schema instrumentation for a specific statement digest. If you find a statement of interest within the Performance Schema events_statements_summary_by_digest table, specify its DIGEST column MD5 value to this procedure and ...

30.4.4.23 The ps_trace_thread() Procedure

https://dev.mysql.com/doc/refman/9.7/en/sys-ps-trace-thread.html

in_outfile VARCHAR(255): The name to use for the .dot output file. Dumps all Performance Schema data for an instrumented thread to a .dot formatted graph file (for the DOT graph description language). Each result set returned from the procedure ...

30.4.4.26 The statement_performance_analyzer() Procedure

https://dev.mysql.com/doc/refman/9.7/en/sys-statement-performance-analyzer.html

in_table VARCHAR(129): The table parameter used for some of the actions specified by the in_action parameter. Creates a report of the statements running on the server. The views are calculated based on the overall and/or delta activity. This ...

15.2.20 WITH (Common Table Expressions)

https://dev.mysql.com/doc/refman/9.7/en/with.html

A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that statement, possibly multiple times. The following discussion describes how to write ...

14.11 XML Functions

https://dev.mysql.com/doc/refman/9.7/en/xml-functions.html

Table 14.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation UpdateXML() Return replaced XML fragment This section discusses XML and related functionality in MySQL. Note It is possible to obtain ...