Search Results
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-functions.html
(For our purposes, a single query also includes a call to a stored program (stored routine, trigger, or event) and all subprograms called by that program.) This principle also applies to CURDATE(), CURTIME(), UTC_DATE(), UTC_TIME(), UTC_TIMESTAMP(), ... This section describes the functions that can be used to manipulate temporal ...
https://dev.mysql.com/doc/refman/8.4/en/external-locking.html
External locking is unnecessary if you run a single server to access a given data directory (which is the usual case) and if no other programs such as myisamchk need to modify tables while the server is running. If you only read tables with other ...
https://dev.mysql.com/doc/refman/8.4/en/extensions-to-ansi.html
MySQL Server understands the || and && operators to mean logical OR and AND, as in the C programming language. MySQL Server supports some extensions that you are not likely to find in other SQL DBMSs. Be warned that if you use them, your code is ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema.html
Performance Schema events are distinct from events written to the server's binary log (which describe data modifications) and Event Scheduler events (which are a type of stored program). The MySQL Performance Schema is a feature for monitoring ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-installation.html
For remote cloning operations, the clone plugin must be installed on the donor and recipient MySQL server instances. To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-options-variables.html
If values specified at startup are incorrect, the clone plugin may fail to initialize properly and the server does not load it. In this case, the server may also produce error messages for other clone settings because it does not recognize them.
https://dev.mysql.com/doc/refman/8.4/en/faqs-replication.html
How do I tell whether a replication source server is using statement-based or row-based binary logging format? A.14.11. Verify that the skip_networking system variable has not been enabled in the configuration file for either server. What issues ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-ip-address-permissions.html
If you specify an allowlist on a server s1, then when server s2 is establishing a connection to s1 for the purpose of engaging group communication, s1 first checks the allowlist before accepting the connection from s2. The automatic allowlist of ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-ipv6.html
To use IPv6 addresses, the operating system on the server host and the MySQL Server instance must both be configured to support IPv6. For instructions to set up IPv6 support for a server instance, see Section 7.1.13, “IPv6 Support”. If a host ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-redo-log.html
The Innodb_redo_log_capacity_resized server status variable indicates the total redo log capacity for all redo log files. The following query retrieves data from all of the table's columns: SELECT FILE_ID, START_LSN, END_LSN, SIZE_IN_BYTES, IS_FULL, ... The redo log is a disk-based data structure used during crash recovery to correct data written by incomplete ...