Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysqlcheck.html
--extended, -e Command-Line Format --extended If you are using this option to check tables, it ensures that they are 100% consistent but takes a long time. If you are using this option to repair tables, it runs an extended repair that may not only ...Each table is locked and therefore unavailable to other sessions while it is being processed, although for check operations, the table is locked with a READ lock only (see Section 15.3.6, “LOCK TABLES and UNLOCK TABLES Statements”, for more information about READ and WRITE ...
https://dev.mysql.com/doc/refman/8.4/en/webauthn-pluggable-authentication.html
When device registration has been performed for the account, the server updates the mysql.user system table row for that account to update the device registration status and to store the public key and credential ID. WebAuthn stands for Web ... Note ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-what-is-new.html
These updates were not actually applied or used for any other purpose; this entailed unnecessary network traffic and consumption of resources. In NDB 8.4.0 and later, updates applied on the replica SQL node are filtered out on this node, and are no ...NDB Cluster 7.5, 7.4, and 7.3 were previous GA releases which have reached their end of life, and are no longer supported or ... What is New in NDB Cluster 8.4 Changes in NDB 8.x Innovation Releases The following sections ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-transaction-compression.html
However, the effort required for data compression also increases, taking time and CPU and memory resources on the originating server. Note You can enable binary logging of compressed transactions for tables using the NDB storage engine at run time ... MySQL supports binary log transaction compression; when this is enabled, transaction payloads are compressed using the zstd algorithm, and then written to the server's binary log file as a single event (a ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.incremental.html
To restore data up to, for example, time t, you simply restore first the full backup, and then, on top of it, the differential backup taken for time t. Each subsequent incremental backup is thus usually smaller in size than a differential backup, ...
https://dev.mysql.com/doc/mysql-installer/en/mysql-installer-catalog-dashboard.html
By default, and when an Internet connection is present, MySQL Installer attempts to update the catalog at startup every seven days. Upgrade: This operation loads the Select Products to Upgrade page and populates it with all the upgrade candidates.
https://dev.mysql.com/doc/internals/en/optimizer-partition-pruning.html
7.3.2.1.1 Partition Pruning Overview Partition pruning is performed using the following steps: Analyze the WHERE clause and construct an interval graph describing the results of this analysis. Walk the graph, and find sets of partitions (or ...
https://dev.mysql.com/doc/refman/8.4/en/information-functions.html
It is advisable to execute BENCHMARK() several times, and to interpret the result with regard to how heavily loaded the server machine is. BENCHMARK() is intended for measuring the runtime performance of scalar expressions, which has some ...It may ...The result value is 0, or NULL for inappropriate arguments such as a NULL or negative repeat ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-replication.html
In other words, it is possible for client A to make an update to co-source 1, and in the meantime, before it propagates to co-source 2, client B could make an update to co-source 2 that makes the update of client A work differently than it did on ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-functions-general-purpose.html
MySQL Server supports a keyring service that enables internal components and plugins to store sensitive information securely for later retrieval. The functions described here are general-purpose and intended for use with any keyring component or ...