Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-limitations.html
OPTIMIZE TABLE for an InnoDB table is mapped to an ALTER TABLE operation to rebuild the table and update index statistics and free unused space in the clustered index. Tables created before MySQL 5.6 that include temporal columns (DATE, DATETIME or ... The following limitations apply to online DDL operations: The table is copied when creating an index on a TEMPORARY ...
https://dev.mysql.com/doc/refman/8.4/en/json-search-functions.html
JSON_CONTAINS(target, candidate[, path]) Indicates by returning 1 or 0 whether a given candidate JSON document is contained within a target JSON document, or—if a path argument was supplied—whether the candidate is found at a specific path ...
https://dev.mysql.com/doc/refman/8.4/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-certificates.html
The certificates table contains the following columns: Node_id ID of the node where this certificate is found Name Certificate name Expires Expiration date, in mm-nnn-yyyy format (for example, 18-Dec-2023). The certificates table provides ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndbd.html
In a multi-processor system performing a large number of operations (including updates), the ndbd process can consume up to 2 CPUs if permitted to do so. The ndbd binary provides the single-threaded version of the process that is used to handle all ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-what-is-new.html
Previously, when SQL nodes performing binary logging used log_replica_updates=OFF, any replicated updates which were applied on a replica NDB cluster were sent on to the SQL nodes performing binary logging. These updates were not actually applied or ... What is New in NDB Cluster 8.4 Changes in NDB 8.x Innovation Releases The following sections describe changes in the implementation of MySQL NDB Cluster in NDB Cluster 8.0 through 8.0.44, as compared to earlier release ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-commands.html
If you are running with --safe-updates enabled, status also prints the values for the mysql variables that affect your queries. mysql sends each SQL statement that you issue to the server to be executed. There is also a set of commands that mysql ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-enterprise-monitor.html
After this date, MySQL Enterprise Monitor will no longer receive security updates, non-security updates, bug fixes, or online technical content updates. For information about MySQL Enterprise Monitor behavior, see the MySQL Enterprise Monitor ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-tips.html
Input-Line Editing Disabling Interactive History Unicode Support on Windows Displaying Query Results Vertically Using Safe-Updates Mode (--safe-updates) Disabling mysql Auto-Reconnect mysql Client Parser Versus Server Parser Input-Line Editing mysql ... This section provides information about techniques for more effective use of mysql and about mysql operational ...
https://dev.mysql.com/doc/refman/8.4/en/mysqld-safe.html
mysqld_safe tries to use the sleep and date system utilities to determine how many times per second it has attempted to start. mysqld_safe is the recommended way to start a mysqld server on Unix. mysqld_safe adds some safety features such as ...