PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-tp-thread-group-state-table.html
Note The Performance Schema table described here is available as of MySQL 8.0.14. Prior to MySQL 8.0.14, use the corresponding INFORMATION_SCHEMA table instead; see Section 28.5.2, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table”. The ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-user-defined-functions-table.html
The mysql.func system table also lists installed loadable functions, but only those installed using CREATE FUNCTION. This difference makes user_defined_functions preferable to mysql.func for checking which loadable functions are installed. The ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-numbers.html
In MySQL, the DECIMAL type has several synonyms: NUMERIC, DEC, FIXED. In MySQL, types that are synonymous with FLOAT or DOUBLE are DOUBLE PRECISION and REAL. The scope of precision math for exact-value operations includes the exact-value data types ...
https://dev.mysql.com/doc/refman/8.0/en/query-attribute-components.html
As of MySQL 8.0.23, a component service provides access to query attributes (see Section 11.6, “Query Attributes”). Purpose: Implements the mysql_query_attribute_string() function that takes an attribute name argument and returns the attribute ...The query_attributes component uses this service to provide access to query attributes within SQL ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-create-if-not-exists.html
IF NOT EXISTS statements are replicated: Every CREATE DATABASE IF NOT EXISTS statement is replicated, whether or not the database already exists on the source. Similarly, every CREATE TABLE IF NOT EXISTS statement without a SELECT is replicated, ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-user-names.html
The maximum length for user names in MySQL 8.0 is 32 characters. Replication of user names longer than 16 characters fails when the replica runs a version of MySQL previous to 5.7, because those versions support only shorter user names. This occurs ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-variables.html
However, when mysqlbinlog parses a SET @@sql_mode = mode statement, the full mode value, including NO_DIR_IN_CREATE, is passed to the receiving server. In addition, the enabling this variable has different effects with regard to temporary tables, ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-masterbaseconfig.html
It is recommended that you specify this option to give the binary log files a non-default base name, so that if the host name changes, you can easily continue to use the same binary log file names (see Section B.3.7, “Known Issues in MySQL”).
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-slavebaseconfig.html
If you are shutting down the replica server, you can edit the [mysqld] section of the configuration file to specify a unique server ID. For example: [mysqld] server-id=21 Binary logging is enabled by default on all servers. In addition to binary ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-monitoring.html
To monitor the connection status of all channels: mysql> SELECT * FROM replication_connection_status\G; *************************** 1. row *************************** CHANNEL_NAME: source_1 GROUP_NAME: SOURCE_UUID: ... To monitor the status of ...