PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/loadable-function-reference.html
The following table lists each function that is loadable at runtime and provides a short description of each one. For a table listing built-in functions and operators, see Section 14.1, “Built-In Function and Operator Reference” For general ...
https://dev.mysql.com/doc/refman/8.0/en/mrr-optimization.html
With the Disk-Sweep Multi-Range Read (MRR) optimization, MySQL tries to reduce the number of random disk access for range scans by first scanning the index only and collecting the keys for the relevant rows. Reading rows using a range scan on a ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-table-problems.html
The file format that MySQL uses to store data has been extensively tested, but there are always circumstances that may cause database tables to become corrupted. The following discussion describes how this can happen and how to handle it.
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog-hexdump.html
For more information about binary log format, see MySQL Internals: The Binary Log. In the example shown, '9d fc 5c 43' is the representation of '051024 17:24:13' in hexadecimal. Master ID: The server ID of the replication source server that created ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog-server-id.html
When invoked with the --read-from-remote-server option, mysqlbinlog connects to a MySQL server, specifies a server ID to identify itself, and requests binary log files from the server. You can use mysqlbinlog to request log files from a server in ...The server sends all files, but does not disconnect after sending the last ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-trace-testing.html
This feature is tested in mysql-test/suite/opt_trace and unittest/gunit/opt_trace-t. ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-tracing.html
The MySQL optimizer includes the capability to perform tracing; the interface is provided by a set of optimizer_trace_xxx system variables and the INFORMATION_SCHEMA.OPTIMIZER_TRACE table.
https://dev.mysql.com/doc/refman/8.0/en/optimizing-myisam.html
In MySQL, InnoDB is the default storage engine rather than MyISAM. The MyISAM storage engine performs best with read-mostly data or with low-concurrency operations, because table locks limit the ability to perform simultaneous updates.
https://dev.mysql.com/doc/refman/8.0/en/optimizing-spatial-analysis.html
The most typical operations are: Point queries that search for all objects that contain a given point Region queries that search for all objects that overlap a given region MySQL uses R-Trees with quadratic splitting for SPATIAL indexes on spatial ... For MyISAM and InnoDB tables, search operations in columns containing spatial data can be optimized using SPATIAL ...
https://dev.mysql.com/doc/refman/8.0/en/outer-join-simplification.html
Instead, MySQL converts the query to a query with no outer join operation if the WHERE condition is null-rejected. This results in a query with no outer joins at all: SELECT * FROM (T1 INNER JOIN T2 ON T2.A=T1.A), T3 WHERE T3.C > 0 AND T3.B=T2.B ...