Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-metrics-table.html
The setup_metrics table lists the available metrics: mysql> select * from performance_schema.setup_metrics\G *************************** 34. row *************************** NAME: undo_tablespaces_active METER: mysql.inno METRIC_TYPE: ASYNC GAUGE ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math-expressions.html
With precision math, exact-value numbers are used as given whenever possible. For example, numbers in comparisons are used exactly as given without a change in value. In strict SQL mode, for INSERT into a column with an exact data type (DECIMAL or ...
https://dev.mysql.com/doc/refman/8.4/en/regexp.html
This section discusses the functions and operators available for regular expression matching and illustrates, with examples, some of the special characters and constructs that can be used for regular expression operations. MySQL implements regular ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-replica.html
This section explains the server options and system variables that apply to replica servers and contains the following: Startup Options for Replica Servers System Variables Used on Replica Servers Specify the options either on the command line or ...
https://dev.mysql.com/doc/refman/8.4/en/resetting-permissions.html
If you have never assigned a root password for MySQL, the server does not require a password at all for connecting as root. For instructions on assigning a password, see Section 2.9.4, “Securing the Initial MySQL Account”. If you know the root ...
https://dev.mysql.com/doc/refman/8.4/en/secure-client-programming.html
Client applications that access MySQL should use the following guidelines to avoid interpreting external data incorrectly or exposing sensitive information. Handle External Data Properly Handle MySQL Error Messages Properly Handle External Data ...
https://dev.mysql.com/doc/refman/8.4/en/server-status-variables.html
The MySQL server maintains many status variables that provide information about its operation. You can view these variables and their values by using the SHOW [GLOBAL | SESSION] STATUS statement (see Section 15.7.7.37, “SHOW STATUS Statement”).
https://dev.mysql.com/doc/refman/8.4/en/spatial-convenience-functions.html
The functions in this section provide convenience operations on geometry values. Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL, the return value is NULL. If any geometry ...
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-functions.html
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 nearest integer. ASCII(str) Returns the numeric value of the leftmost character of ...