Search Results
https://dev.mysql.com/doc/refman/8.4/en/string-functions.html
[USING charset_name]) CHAR() interprets each argument N as an integer and returns a string consisting of the characters given by the code values of those integers. For more information about that option, see Section 6.5.1, “mysql — The MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/cast-functions.html
CAST(expr AS type [ARRAY]) CAST(timestamp_value AT TIME ZONE timezone_specifier AS DATETIME[(precision)]) timezone_specifier: [INTERVAL] '+00:00' | 'UTC' With CAST(expr AS type syntax, the CAST() function takes an expression of any type and produces ...For a DATE, DATETIME, or TIMESTAMP value, return the YEAR portion of the ... Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY Cast a string to a binary string Yes CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log.html
If you disable binary logging, either omit these options, or specify --log-replica-updates=OFF and --skip-replica-preserve-commit-order. You can remove the files manually, but it is preferable to use PURGE BINARY LOGS, which also safely updates the ...The binary log also contains information about how long each statement took that updated ... The binary log contains ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-operations.html
When you add a primary key using the ALGORITHM=COPY clause, MySQL converts NULL values in the associated columns to default values: 0 for numbers, an empty string for character-based columns and BLOBs, and 0000-00-00 00:00:00 for DATETIME. Online ...Index Operations Primary Key Operations Column Operations Generated Column Operations Foreign Key Operations Table Operations Tablespace Operations Partitioning Operations Index Operations The following table provides an overview of online DDL support for index ...
https://dev.mysql.com/doc/ndbapi/en/ndb-dictionary.html
The Ndb object and its associated Dictionary support one schema transaction at a time. Tables created using this method cannot be seen by the MySQL Server, cannot be updated by MySQL clients, and cannot be replicated. This means that they cannot be ...For these reasons, it is often preferable to avoid working with ...
https://dev.mysql.com/doc/refman/8.4/en/converting-tables-to-innodb.html
While a transaction is open, the system keeps a snapshot of the data as seen at the beginning of the transaction, which can cause substantial overhead if the system inserts, updates, and deletes millions of rows while a stray transaction keeps ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-configurator-workflow-server.html
Otherwise, the process stops and displays an error message if an individual action times out. MySQL Configurator performs the initial configuration, a reconfiguration, and also functions as part of the uninstallation process. This does not apply to ...Note Full permissions are granted to the user executing MySQL Configurator to all generated files, such as ...
https://dev.mysql.com/doc/refman/8.4/en/version-tokens-usage.html
The next time the client sends a statement to server 2, its own token list no longer matches the server token list and an error occurs: mysql> UPDATE emp.employee SET salary = salary * 1.1 WHERE id = 4982; ERROR 3136 (42000): Version token mismatch ...Client applications that access the servers to retrieve and update data, choosing servers according to the purposes assigned ...A scenario in which Version Tokens can be useful is a system that accesses a collection of MySQL servers ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndbd.html
--connect-delay=# Command-Line Format --connect-delay=# Deprecated Yes Type Numeric Default Value 5 Minimum Value 0 Maximum Value 3600 Determines the time to wait between attempts to contact a management server when starting (the number of attempts ... The ndbd binary provides the single-threaded version of the process that is used to handle all the data in tables employing the NDBCLUSTER storage ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-reference.html
replica_checkpoint_period: Update progress status of multithreaded replica and flush relay log info to disk after this number of milliseconds. replica_transaction_retries: Number of times replication SQL thread retries transaction in case it failed ... The following two sections provide basic information about the MySQL command-line options and system variables applicable to replication and the binary ...