Search Results
https://dev.mysql.com/doc/refman/8.4/en/using-explain.html
That is, MySQL explains how it would process the statement, including information about how tables are joined and in which order. With the help of EXPLAIN, you can see where you should add indexes to tables so that the statement executes faster by ... The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE ...
https://dev.mysql.com/doc/refman/8.4/en/using-log-files.html
Note that before starting mysqld with the general query log enabled, you should check all your tables with myisamchk. If this happens, you should check all your tables with myisamchk (see Chapter 7, MySQL Server Administration), and test the ...If ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.incremental.html
Creating Incremental Backups Using Only the Redo Log The --incremental-with-redo-log-only might offer some benefits over the --incremental option for creating an incremental backup: The changes to the InnoDB tables are determined based on the ...In ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/restore-use-tts.html
Requirements for restoring backups created with transportable tablespaces (TTS) (that is, created with the --use-tts option) are similar to those listed in Section 5.1.4, “Table-Level Recovery (TLR)”, with some differences noted in the section.
https://dev.mysql.com/doc/relnotes/mysql-shell/8.4/en/news-8-4-0.html
(Bug #36338711) clusterSet.setPrimaryCluster and replicaSet.setPrimaryCluster invoked FLUSH TABLES WITH READ LOCK when dryRun was enabled. (Bug #35387205) AdminAPI no longer retrieves information from the following tables on MySQL 8.4, or higher: ...
https://dev.mysql.com/doc/ndbapi/en/ndb-tablespace.html
Tablespace Class Overview Tablespace Constructor Tablespace::getAutoGrowSpecification() Tablespace::getDefaultLogfileGroup() Tablespace::getDefaultLogfileGroupId() Tablespace::getExtentSize() Tablespace::getObjectId() Tablespace::getName() ...Return ...
https://dev.mysql.com/doc/refman/8.4/en/declare-condition.html
DECLARE condition_name CONDITION FOR condition_value condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value } The DECLARE ... CONDITION statement declares a named error condition, associating a name with a condition that needs ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-installation.html
The available scripts differ in the file name used to refer to the script: win_install_firewall.sql linux_install_firewall.sql The installation script creates stored procedures and tables in the firewall database you specify when you run the script.
https://dev.mysql.com/doc/refman/8.4/en/gis-data-formats.html
For example, a WKB value that corresponds to POINT(1 -1) consists of this sequence of 21 bytes, each represented by two hexadecimal digits: 0101000000000000000000F03F000000000000F0BF The sequence consists of the components shown in the following ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-9.html
It is suitable for use with MySQL Server versions 5.5, 5.6, 5.7, and 8.0. Components that support DDLS for tables, including the createTable(), dropTable(), and modifyTable() methods. (WL #11060) Connector/J now takes advantage of the MySQL Server ... Version 8.0.9 Release Candidate is the first release candidate of the 8.0 branch of MySQL Connector/J, providing an insight into upcoming ...