Search Results
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-type-syntax.html
The way the server handles TIMESTAMP definitions depends on the value of the explicit_defaults_for_timestamp system variable (see Section 7.1.8, “Server System Variables”). If explicit_defaults_for_timestamp is disabled, the server handles ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-elements.html
System variables enable firewall configuration and status variables provide runtime operational information. MySQL Enterprise Firewall is based on a plugin library that includes these elements: A server-side plugin named MYSQL_FIREWALL examines SQL ...Stored procedures perform tasks such as registering firewall profiles, establishing their operational mode, and managing transfer of firewall data between the cache and persistent ...
https://dev.mysql.com/doc/refman/8.4/en/index-condition-pushdown-optimization.html
(For information about triggered conditions, see Section 10.2.2.3, “Optimizing Subqueries with the EXISTS Strategy”.) Conditions cannot be pushed down to derived tables containing references to system variables. It can be controlled with the ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-table.html
OPTIMIZE TABLE rebuilds the table using the table copy method under the following conditions: When the old_alter_table system variable is enabled. The table and indexes are reorganized, and disk space can be reclaimed for use by the operating system. After deleting a large part of a MyISAM or ARCHIVE table, or making many changes to a MyISAM or ARCHIVE table with variable-length rows (tables that have VARCHAR, VARBINARY, BLOB, or TEXT ...
https://dev.mysql.com/doc/refman/8.4/en/replication-functions-synchronization.html
On a multithreaded replica, the function waits until expiry of the limit set by the replica_checkpoint_group or replica_checkpoint_period system variable, when the checkpoint operation is called to update the status of the replica. Depending on the ... The functions listed in this section are used for controlling position-based synchronization of source and replica servers in MySQL ...Table 14.28 Positional Synchronization Functions Name Description Deprecated MASTER_POS_WAIT() Block until the replica has read and applied all updates up to the specified position Yes SOURCE_POS_WAIT() Block until the replica has read and ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-view.html
row *************************** View: v Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`bob`@`localhost` SQL SECURITY DEFINER VIEW `v` AS select 1 AS `a`,2 AS `b` character_set_client: utf8mb4 collation_connection: utf8mb4_0900_ai_ci ...MySQL lets ... SHOW CREATE VIEW view_name This statement shows the CREATE VIEW statement that creates the named ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-optional-metadata.html
For metadata-optional connections, the client sets the resultset_metadata system variable to control whether the server returns result set metadata. For example, if a client executes a stored procedure that returns multiple result sets and might ...
https://dev.mysql.com/doc/relnotes/mysql-enterprise-backup/8.4/en/news-8-3-0.html
Bugs Fixed When creating a backup, mysqlbackup reset the system variable log_error_suppression_list on the server being backed up to its default value. With this fix, the value of the system variable is preserved. MySQL Enterprise Backup 8.3.0 is ...(Bug #35748874) mysqlbackup failed to restore a partial backup when it contained tables with foreign key ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-elements.html
Tables in the mysql system database provide persistent storage of filter and user account data, unless you set the audit_log_database system variable at server startup to specify a different database. System variables enable audit log configuration ... MySQL Enterprise Audit is based on the audit log plugin and related elements: A server-side plugin named audit_log examines auditable events and determines whether to write them to the audit ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-postgresql-typemapping.html
MySQL Server 5.6 and higher can have CHAR columns with a length up to 255 characters. MySQL Server 5.6 and higher can have VARCHAR columns with a length up to 65535 characters. MySQL Server 5.6 and higher can have VARCHAR columns with a length up to ... The following table shows the mapping between PostgreSQL (source) data types and MySQL data ...