Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-system-variables.html
If an error occurs that is not instrumented, information for the occurrence is aggregated to the NULL row in each summary table; that is, to the row with ERROR_NUMBER=0, ERROR_NAME=NULL, and SQLSTATE=NULL. The Performance Schema automatically sizes ...
https://dev.mysql.com/doc/refman/8.4/en/replication-administration-status.html
row *************************** Id: 10 User: root Host: replica1:58371 db: NULL Command: Binlog Dump Time: 777 State: Has sent all binlog to slave; waiting for binlog to be updated Info: NULL Because it is the replica that drives the replication ...
https://dev.mysql.com/doc/refman/8.4/en/replication-functions-synchronization.html
The function returns NULL if the replication SQL thread is not started, the replica's source information is not initialized, the arguments are incorrect, or an error occurs. If the replication SQL thread stops while SOURCE_POS_WAIT() is waiting, the ... The functions listed in this section are used for controlling position-based synchronization of source and replica servers in MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/row-constructor-optimization.html
row *************************** id: 1 select_type: SIMPLE table: t1 partitions: NULL type: ref possible_keys: PRIMARY key: PRIMARY key_len: 4 ref: const rows: 3 filtered: 100.00 Extra: Using where In such cases, rewriting the row constructor ...For ...
https://dev.mysql.com/doc/refman/8.4/en/set.html
For example, a column specified as SET('one', 'two') NOT NULL can have any of these values: '' 'one' 'two' 'one,two' A SET column can have a maximum of 64 distinct members. A SET is a string object that can have zero or more values, each of which ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-geohash-functions.html
Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL, the return value is NULL. Geohash is a system for encoding latitude and longitude coordinates of arbitrary precision into a ...
https://dev.mysql.com/doc/refman/8.4/en/sys-innodb-lock-waits.html
locked_table_partition The name of the locked partition, if any; NULL otherwise. locked_table_subpartition The name of the locked subpartition, if any; NULL otherwise. This field reports NULL if the session that issued the blocking query becomes ...
https://dev.mysql.com/doc/refman/8.4/en/system-schema.html
row *************************** CATALOG_NAME: def SCHEMA_NAME: mysql DEFAULT_CHARACTER_SET_NAME: utf8mb4 DEFAULT_COLLATION_NAME: utf8mb4_0900_ai_ci SQL_PATH: NULL DEFAULT_ENCRYPTION: NO *************************** 2. row *************************** ...It contains tables that store information required by the MySQL server as it ...
https://dev.mysql.com/doc/refman/8.4/en/upgrading-from-previous-series.html
In MySQL 8.4, setting any of these to NULL is specifically disallowed, and attempting to do is rejected with an error. The WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS() SQL function, deprecated in MySQL 8.0 has been removed; attempting to invoke it now causes ... Before upgrading to MySQL 8.4, review the changes described in the following sections to identify those that apply to your current MySQL installation and ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-scheduled-backups.html
Outputs from the stderr and stdout streams are redirected to /dev/null/, so they will not invoke other actions on the part of the Cron server (for example, email notifications to the user). Maintaining a regular backup schedule is an important ...