Search Results
https://dev.mysql.com/doc/refman/8.4/en/encrypted-connection-protocols-ciphers.html
To determine the value of tls_version at runtime, use this statement: mysql> SHOW GLOBAL VARIABLES LIKE 'tls_version'; +---------------+-----------------------+ | Variable_name | Value | +---------------+-----------------------+ | tls_version | ...
https://dev.mysql.com/doc/refman/8.4/en/events-status-info.html
INTO var_list statements, if the query returns no rows, a warning with error code 1329 occurs (No data), and the variable values remain unchanged. For statements that may retrieve multiple rows, another strategy is to use LIMIT 1 to limit the result ... The Event Scheduler writes information about event execution that terminates with an error or warning to the MySQL Server's error ...
https://dev.mysql.com/doc/refman/8.4/en/function-loading.html
Installing Loadable Functions Uninstalling Loadable Functions Reinstalling or Upgrading Loadable Functions Installing Loadable Functions To load a loadable function manually, use the CREATE FUNCTION statement. Uninstalling Loadable Functions To ...
https://dev.mysql.com/doc/refman/8.4/en/functions.html
Expressions can be used at several points in SQL statements, such as in the ORDER BY or HAVING clauses of SELECT statements, in the WHERE clause of a SELECT, DELETE, or UPDATE statement, or in SET statements. Expressions can be written using values ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-adding-instances.html
At this point, the group has one member in it, server s1, which has some data in it. It is now time to expand the group by adding the other two servers configured previously. 20.2.1.6.1 Adding a Second Instance In order to add a second instance, ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-change-primary.html
Explicitly defined transactions (with a START TRANSACTION or BEGIN statement) are subject to the timeout, disconnection, and incoming transaction blocking even if they do not modify any data. To allow inspection of the primary while the function is ... This section explains how to change which member of a single-primary group is the primary, using the group_replication_set_as_primary() function, which can be can be run on any member of the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tablespaces-table.html
Use the INFORMATION_SCHEMA COLUMNS table or the SHOW COLUMNS statement to view additional information about the columns of this table, including data types and default values. The INNODB_TABLESPACES table provides metadata about InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-create-table-external.html
TABLESPACE Syntax Creating a Table in an External General Tablespace Using the DATA DIRECTORY Clause You can create an InnoDB table in an external directory by specifying a DATA DIRECTORY clause in the CREATE TABLE statement. When you specify a DATA ... There are different reasons for creating InnoDB tables externally; that is, creating tables outside of the data ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-redo-log.html
During normal operations, the redo log encodes requests to change table data that result from SQL statements or low-level API calls. Disabling Redo Logging You can disable redo logging using the ALTER INSTANCE DISABLE INNODB REDO_LOG statement. The ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-management.html
Some aspects of the cluster's operation can be also be monitored from an SQL node using the SHOW ENGINE NDB STATUS statement. The values of these variables can be read in the mysql client from the output of a SHOW STATUS statement, or by querying ...