PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/data-masking-plugin-installation.html
This section describes how to install or uninstall MySQL Enterprise Data Masking and De-Identification, which is implemented as a plugin library file containing a plugin and several loadable functions. For general information about installing or ...
https://dev.mysql.com/doc/refman/8.0/en/error-message-elements.html
This section discusses how error messages originate within MySQL and the elements they contain. The MySQL client library takes errors received from the server and makes them available to the host client program. Error Message Elements When an error ...The MySQL server writes some error messages to its error ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-table-wait-summary-tables.html
For example, columns that aggregate all writes hold the sum of the corresponding columns that aggregate inserts, updates, and deletes. They are the same as the sum of the corresponding xxx_INSERT, xxx_UPDATE, and xxx_DELETE columns. COUNT_UPDATE, ...
https://dev.mysql.com/doc/refman/8.0/en/table-cache.html
When you execute a mysqladmin status command, you should see something like this: Uptime: 426 Running threads: 1 Questions: 11082 Reloads: 1 Open tables: 12 The Open tables value of 12 can be somewhat puzzling if you have fewer than 12 tables. (By ...MySQL is multithreaded, so there may be many clients issuing queries for a given table ...
https://dev.mysql.com/doc/refman/8.0/en/derived-condition-pushdown-optimization.html
MySQL 8.0.22 and later supports derived condition pushdown for eligible subqueries. When a derived table cannot be merged into the outer query (for example, if the derived table uses aggregation), pushing the outer WHERE condition down to the ...
https://dev.mysql.com/doc/refman/8.0/en/engine-condition-pushdown-optimization.html
This optimization improves the efficiency of direct comparisons between a nonindexed column and a constant. column BETWEEN constant1 AND constant2 constant1 and constant2 must each be a constant, literal value. In all of the cases in the preceding ...In such cases, the condition is “pushed down” to the storage engine for ...
https://dev.mysql.com/doc/refman/8.0/en/install-plugin.html
For maximal compatibility, plugin names should be limited to ASCII letters, digits, and underscore because they are used in C source files, shell command lines, M4 and Bourne shell scripts, and SQL environments. INSTALL PLUGIN loads and initializes ... INSTALL PLUGIN plugin_name SONAME 'shared_library_name' This statement installs a server ...
https://dev.mysql.com/doc/refman/8.0/en/limit-optimization.html
MySQL sometimes optimizes a query that has a LIMIT row_count clause and no HAVING clause: If you select only a few rows with LIMIT, MySQL uses indexes in some cases when normally it would prefer to do a full table scan. If you need only a specified ...If you combine LIMIT row_count with ORDER BY, MySQL stops sorting as soon as it has found the first row_count rows of the sorted result, rather than sorting the entire ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk.html
myisamchk works with MyISAM tables (tables that have .MYD and .MYI files for storing data and indexes). You can also use the CHECK TABLE and REPAIR TABLE statements to check and repair MyISAM tables. See Section 15.7.3.2, “CHECK TABLE ... The ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-preparation.html
If the source cluster is already in use, you can create a backup of the source and load this onto the replica to cut down on the amount of time required for the replica to synchronize itself with the source. For additional options that can be set in ... Preparing the NDB Cluster for replication consists of the following steps: Check all MySQL servers for version compatibility (see Section 25.7.2, “General Requirements for NDB Cluster ...