Search Results
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/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 ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-fetch-field.html
For metadata-optional connections, this function returns NULL when the resultset_metadata system variable is set to NONE. NULL if no columns are left or the result set has no metadata. MYSQL_FIELD * mysql_fetch_field(MYSQL_RES *result) Description ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-init.html
If mysql is a NULL pointer, the function allocates, initializes, and returns a new object. NULL if there was insufficient memory to allocate a new object. MYSQL * mysql_init(MYSQL *mysql) Description Allocates or initializes a MYSQL object suitable ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-keyring-plugins.html
The general descriptor also refers to keyring_system_variables, a structure that exposes a system variable to the SHOW VARIABLES statement: static struct st_mysql_sys_var *keyring_system_variables[]= { MYSQL_SYSVAR(data), NULL }; The keyring_init ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-password-validation-plugins.html
This section describes how to write a server-side password-validation plugin. The instructions are based on the source code in the plugin/password_validation directory of MySQL source distributions. The validate_password.cc source file in that ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-deploying-sandbox.html
Test a MySQL Router installation by setting up a Router sandbox with InnoDB Cluster. In this case, Router acts as an intermediate node redirecting client connections to a list of servers. If one server fails, clients are redirected to the next ...