Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-sbr-rbr.html
(Row-based replication, however, simply replicates the value returned by the function or stored program, so its effect on table rows and data is the same on both the source and replica.) See Section 19.5.1.16, “Replication of Invoked Features”, ...For most users, the mixed replication format should provide the best combination of data integrity and ...
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-elements.html
In older versions of MySQL, the monitoring tables were INFORMATION_SCHEMA tables (see Section 28.5, “INFORMATION_SCHEMA Thread Pool Tables”). The INFORMATION_SCHEMA tables are deprecated; expect them to be removed in a future version of MySQL.
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-process.html
The data and the structures of the InnoDB tables might have changed during this period; so, some of the following steps are for making sure those changes are captured in the backup. It blocks DDL operations (except for those on user-created ... The ...
https://dev.mysql.com/doc/refman/8.4/en/declare-handler.html
It can take the following forms: mysql_error_code: An integer literal indicating a MySQL error code, such as 1051 to specify “unknown table”: DECLARE CONTINUE HANDLER FOR 1051 BEGIN -- body of handler END; Do not use MySQL error code 0 because ...statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-usagenotes-functionality-catalog-schema.html
Generally, catalogs are collections of schemas, so the fully qualified name would look like catalog.schema.table.column. In ODBC both schemas and catalogs can be used when referring to database objects such as tables. As a result the client software ... Many relational databases reference CATALOG and SCHEMA in ways that do not directly correspond to what MySQL refers to as a ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-functionality-catalog-schema.html
Generally, catalogs are collections of schemas, so the fully qualified name would look like catalog.schema.table.column. In ODBC both schemas and catalogs can be used when referring to database objects such as tables. As a result the client software ... Many relational databases reference CATALOG and SCHEMA in ways that do not directly correspond to what MySQL refers to as a ...
https://dev.mysql.com/doc/heatwave-aws/en/mysql-server-default-privileges.html
Default MySQL Privileges 3.1.2.9 Default MySQL Privileges This section lists the MySQL privileges granted to the MySQL Administrator user on the DB System and those explicitly revoked on the mysql and sys schemas.
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-functions.html
mysql> SELECT CONVERT_TZ('2004-01-01 12:00:00','GMT','MET'); -> '2004-01-01 13:00:00' mysql> SELECT CONVERT_TZ('2004-01-01 12:00:00','+00:00','+10:00'); -> '2004-01-01 22:00:00' Note To use named time zones such as 'MET' or 'Europe/Amsterdam', the ... This section describes the functions that can be used to manipulate temporal ...
https://dev.mysql.com/doc/refman/8.4/en/pam-pluggable-authentication.html
PAM pluggable authentication provides these capabilities: External authentication: PAM authentication enables MySQL Server to accept connections from users defined outside the MySQL grant tables and that authenticate using methods supported by PAM.
https://dev.mysql.com/doc/refman/8.4/en/spatial-type-overview.html
MySQL has spatial data types that correspond to OpenGIS classes. The basis for these types is described in Section 13.4.2, “The OpenGIS Geometry Model”. Some spatial data types hold single geometry values: GEOMETRY POINT LINESTRING POLYGON ...