PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/rewriting-subqueries.html
Sometimes there are other ways to test membership in a set of values than by using a subquery. MySQL Server supports multiple-table DELETE statements that can be used to efficiently delete rows based on information from one table or even from many ...Also, on some occasions, it is not only possible to rewrite a query without a subquery, but it can be more efficient to make use of some of these techniques rather than to use ...
https://dev.mysql.com/doc/refman/5.7/en/xa-states.html
The following error is raised if you try to execute such a statement: ERROR 1399 (XAE07): XAER_RMFAIL: The command cannot be executed when global transaction is in the ACTIVE state Statements to which the preceding remark applies are listed at ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-schema.html
For example, to view information about instrumented InnoDB file objects seen by the Performance Schema when executing file I/O instrumentation, you might issue the following query: mysql> SELECT * FROM performance_schema.file_instances WHERE ...
https://dev.mysql.com/doc/refman/5.7/en/gis-class-multicurve.html
A MultiCurve is a geometry collection composed of Curve elements. A MultiCurve is simple if and only if all of its elements are simple; the only intersections between any two elements occur at points that are on the boundaries of both elements. A ...
https://dev.mysql.com/doc/refman/5.7/en/create-logfile-group.html
There can be only one log file group per NDB Cluster instance at any given time. The optional UNDO_BUFFER_SIZE parameter sets the size used by the UNDO buffer for the log file group; The default value for UNDO_BUFFER_SIZE is 8M (eight megabytes); ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-params-api.html
ConnectBackoffMaxTime: Specifies longest time in milliseconds (~100ms resolution) to allow between connection attempts to any given data node by this API node. Excludes time elapsed while connection attempts are ongoing, which in worst case can take ...ArbitrationDelay: When asked to arbitrate, arbitrator waits this many milliseconds before ... The listing in this section provides information about parameters used in the ...
https://dev.mysql.com/doc/refman/5.7/en/mysqld.html
System variables can be set at server startup, and many of them can be changed at runtime to effect dynamic server reconfiguration. You can monitor these status variables to access runtime performance characteristics. mysqld, also known as MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/sys-io-global-by-file-by-bytes.html
These views summarize global I/O consumers to display amount of I/O, grouped by file. By default, rows are sorted by descending total I/O (bytes read and written). The io_global_by_file_by_bytes and x$io_global_by_file_by_bytes views have these ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-autocommit-commit-rollback.html
By default, MySQL starts the session for each new connection with autocommit enabled, so MySQL does a commit after each SQL statement if that statement did not return an error. If a statement returns an error, the commit or rollback behavior depends ...If autocommit mode is enabled, each SQL statement forms a single transaction on its ...
https://dev.mysql.com/doc/refman/5.7/en/selinux-troubleshooting.html
$> systemctl start mysql.service Job for mysqld.service failed because the control process exited with error code. If you configure the MySQL Server to use a non-default port, such as port 3307, and do not update the policy to reflect the change, ...