Search Results
https://dev.mysql.com/doc/refman/8.4/en/string-comparison-functions.html
Table 14.13 String Comparison Functions and Operators Name Description LIKE Simple pattern matching NOT LIKE Negation of simple pattern matching STRCMP() Compare two strings If a string function is given a binary string as an argument, the ...
https://dev.mysql.com/doc/refman/8.4/en/string-type-syntax.html
In some cases, MySQL may change a string column to a type different from that given in a CREATE TABLE or ALTER TABLE statement. The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. For definitions of character ...
MySQL 8.4 Reference Manual :: 30.4.3.4 The host_summary_by_stages and x$host_summary_by_stages Views
https://dev.mysql.com/doc/refman/8.4/en/sys-host-summary-by-stages.html
By default, rows are sorted by host and descending total latency. The host_summary_by_stages and x$host_summary_by_stages views have these columns: host The host from which the client connected. Rows for which the HOST column in the underlying ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-reset-to-default.html
Parameters in_verbose BOOLEAN: Whether to display information about each setup stage during procedure execution. row *************************** status: Resetting: setup_actors DELETE FROM performance_schema.setup_actors WHERE NOT (HOST = '%' AND ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-thread-stack.html
Returns a JSON formatted stack of all statements, stages, and events within the Performance Schema for a given thread ID. The value should match the THREAD_ID column from some Performance Schema threads table row. row *************************** ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-thread-trx-info.html
The information includes the current transaction, and the statements it has already executed, derived from the Performance Schema events_transactions_current and events_statements_history tables. Returns a JSON object containing information about a ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-truncate-all-tables.html
Parameters in_verbose BOOLEAN: Whether to display each TRUNCATE TABLE statement before executing it. Truncates all Performance Schema summary tables, resetting all aggregated instrumentation as a snapshot. Example mysql> CALL ...
https://dev.mysql.com/doc/refman/8.4/en/sys-quote-identifier.html
Given a string argument, this function produces a quoted identifier suitable for inclusion in SQL statements. This is useful when a value to be used as an identifier is a reserved word or contains backtick (`) characters. Example mysql> SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-views.html
SQL statements are truncated to a maximum display width using format_statement(). The sys schema contains many views that summarize Performance Schema tables in various ways. Most of these views come in pairs, such that one member of the pair has ...
https://dev.mysql.com/doc/refman/8.4/en/sys-sys-config-insert-set-user.html
For rows added to the sys_config table by INSERT statements, the sys_config_insert_set_user trigger sets the set_by column to the current user.