Search Results
https://dev.mysql.com/doc/refman/8.4/en/features.html
This section describes some of the important characteristics of the MySQL Database Software. In most respects, the roadmap applies to all versions of MySQL. Tested with Purify (a commercial memory leakage detector) as well as with Valgrind, a GPL ...
https://dev.mysql.com/doc/refman/8.4/en/federated-create.html
Important When you create the local table it must have an identical field definition to the remote table. To create a FEDERATED table you should follow these steps: Create the table on the remote server. Alternatively, make a note of the table ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-installation.html
MySQL Enterprise Firewall installation is a one-time operation that installs the elements described in Section 8.4.7.1, “Elements of MySQL Enterprise Firewall”. Installation can be performed using a graphical interface or manually: On Windows, ...
https://dev.mysql.com/doc/refman/8.4/en/fixed-point-types.html
These types are used when it is important to preserve exact precision, for example with monetary data. The DECIMAL and NUMERIC types store exact numeric data values. In MySQL, NUMERIC is implemented as DECIMAL, so the following remarks about ...
https://dev.mysql.com/doc/refman/8.4/en/flush.html
The .cfg file contains metadata needed to reimport the tablespace files later, into the same or different server. For the procedure to reimport the copied table data into a MySQL instance, see Section 17.6.1.3, “Importing InnoDB Tables”. | ...
https://dev.mysql.com/doc/refman/8.4/en/forcing-innodb-recovery.html
If you encounter a runaway rollback caused by a failing mass import or ALTER TABLE, you can kill the mysqld process and set innodb_force_recovery to 3 to bring the database up without the rollback, and then DROP the table that is causing the runaway ... To investigate database page corruption, you might dump your tables from the database with SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/general-tablespaces.html
DISCARD TABLESPACE and ALTER TABLE ...IMPORT TABLESPACE are not supported for tables that belong to a general tablespace. A general tablespace is a shared InnoDB tablespace that is created using CREATE TABLESPACE syntax. The server keeps tablespace ...
https://dev.mysql.com/doc/refman/8.4/en/general-thread-states.html
The following list describes thread State values that are associated with general query processing and not more specialized activities such as replication. Many of these are useful only for finding bugs in the server. After create This occurs when ...
https://dev.mysql.com/doc/refman/8.4/en/geometry-well-formedness-validity.html
Spatial import functions that parse WKT or WKB values raise an error for attempts to create a geometry that is not syntactically well-formed. For geometry values, MySQL distinguishes between the concepts of syntactically well-formed and ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-optimization.html
The most important preconditions for using indexes for GROUP BY are that all GROUP BY columns reference attributes from the same index, and that the index stores its keys in order (as is true, for example, for a BTREE index, but not for a HASH ...