PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/metadata-locking.html
Metadata Lock Release To ensure transaction serializability, the server must not permit one session to perform a data definition language (DDL) statement on a table that is used in an uncompleted explicitly or implicitly started transaction in ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-single-user-mode.html
Single user mode enables the database administrator to restrict access to the database system to a single API node, such as a MySQL server (SQL node) or an instance of ndb_restore. Once the cluster has entered single user mode, only the designated ...When entering single user mode, connections to all other API nodes are closed gracefully and all running transactions are ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-sql-statements.html
SELECT * FROM INFORMATION_SCHEMA.ENGINES [WHERE ENGINE LIKE 'NDB%'] This is the equivalent of SHOW ENGINES, but uses the ENGINES table of the INFORMATION_SCHEMA database. You can also query the tables in the ndbinfo information database for ... This ...See Section 15.7.7.15, “SHOW ENGINE Statement”, for a usage example and more detailed ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-aggregate-functions.html
If any geometry argument is not a syntactically well-formed geometry, an ER_GIS_INVALID_DATA error occurs. If those arguments are not in the same SRS, an ER_GIS_DIFFERENT_SRIDS_AGGREGATION error occurs. For general information about these functions, ... MySQL supports aggregate functions that perform a calculation on a set of ...
https://dev.mysql.com/doc/refman/8.0/en/window-function-optimization.html
For nonfloating-point data types, inverse aggregation is always safe and is used regardless of the windowing_use_high_precision value. Window functions affect the strategies the optimizer considers: Derived table merging for a subquery is disabled ...Semijoins are not applicable to window function optimization because semijoins apply to subqueries in WHERE and JOIN ...
https://dev.mysql.com/doc/refman/8.0/en/setting-environment-variables.html
To set a variable permanently, you can set it in a startup file or by using the interface provided by your system for this purpose. To have the settings take effect each time you log in, use the interface provided by your system or place the ...
https://dev.mysql.com/doc/refman/8.0/en/show-binary-logs.html
SHOW BINARY LOGS SHOW MASTER LOGS Lists the binary log files on the server. Encrypted binary log files have a 512-byte file header that stores information required for encryption and decryption of the file. This is included in the file size ...This ...
https://dev.mysql.com/doc/refman/8.0/en/create-view.html
For a view to be updatable, there must be a one-to-one relationship between the rows in the view and the rows in the underlying table. For example, if a view is defined as SELECT * on a table, new columns added to the table later do not become part ...If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE ...For information ...
https://dev.mysql.com/doc/refman/8.0/en/apache.html
There are programs that let you authenticate your users from a MySQL database and also let you write your log files into a MySQL table.
https://dev.mysql.com/doc/refman/8.0/en/server-status-variable-reference.html
The following table lists all status variables applicable within mysqld. The last column indicates whether the scope for each variable is Global, Session, or both. Please see the corresponding item descriptions for details on setting and using the ...