Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-quick-start.html
This section briefly introduces the Performance Schema with examples that show how to use it. For additional examples, see Section 29.19, “Using the Performance Schema to Diagnose Problems”. To enable or disable it explicitly, start the server ...
https://dev.mysql.com/doc/refman/8.4/en/show-index.html
SHOW [EXTENDED] {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index information. This statement requires some privilege for any column in the table. row *************************** Table: ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-aggregate-functions.html
MySQL supports aggregate functions that perform a calculation on a set of values. For general information about these functions, see Section 14.19.1, “Aggregate Function Descriptions”. ST_Collect() can be used as a window function, as signified ...
https://dev.mysql.com/doc/refman/8.4/en/sql-mode.html
Setting the SQL Mode The Most Important SQL Modes Full List of SQL Modes Combination SQL Modes Strict SQL Mode Comparison of the IGNORE Keyword and Strict SQL Mode For answers to questions often asked about server SQL modes in MySQL, see Section ...
https://dev.mysql.com/doc/refman/8.4/en/string-functions.html
All international alphabetic characters outside the A-Z range are treated as vowels. For functions that operate on string positions, the first position is numbered 1. For functions that take length arguments, noninteger arguments are rounded to the ...
https://dev.mysql.com/doc/refman/8.4/en/string-types.html
The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. For information about storage requirements of the string data types, see Section 13.7, “Data Type Storage Requirements”. For descriptions of functions that ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-is-consumer-enabled.html
Returns YES or NO to indicate whether a given Performance Schema consumer is enabled, or NULL if the argument is NULL. If the argument is not a valid consumer name, an error occurs. This function accounts for the consumer hierarchy, so a consumer ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-is-instrument-default-enabled.html
Returns YES or NO to indicate whether a given Performance Schema instrument is enabled by default. Example mysql> SELECT sys.ps_is_instrument_default_enabled('memory/innodb/row_log_buf'); ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-is-instrument-default-timed.html
Returns YES or NO to indicate whether a given Performance Schema instrument is timed by default. Example mysql> SELECT sys.ps_is_instrument_default_timed('memory/innodb/row_log_buf'); ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-disable-consumer.html
Disables Performance Schema consumers with names that contain the argument. 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. Example Disable ...