PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/show-plugins.html
SHOW PLUGINS output has these columns: Name The name used to refer to the plugin in statements such as INSTALL PLUGIN and UNINSTALL PLUGIN. This is the name used to refer to the plugin file in statements such as INSTALL PLUGIN and UNINSTALL PLUGIN.
https://dev.mysql.com/doc/refman/8.0/en/source-installation.html
Building MySQL from the source code enables you to customize build parameters, compiler optimizations, and installation location. Before you proceed with an installation from source, check whether Oracle produces a precompiled binary distribution ...For a list of systems on which MySQL is known to run, see ...
https://dev.mysql.com/doc/refman/8.0/en/source-thread-states.html
Master has sent all binlog to slave; waiting for more updates From MySQL 8.0.26: Source has sent all binlog to replica; waiting for more updates The thread has read all remaining updates from the binary logs and sent them to the replica. In MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/storage-engine-setting.html
You can set the default storage engine for the current session by setting the default_storage_engine variable: SET default_storage_engine=NDBCLUSTER; The storage engine for TEMPORARY tables created with CREATE TEMPORARY TABLE can be set separately ... When you create a new table, you can specify which storage engine to use by adding an ENGINE table option to the CREATE TABLE statement: -- ENGINE=INNODB not needed unless you have set a different -- default storage ...
https://dev.mysql.com/doc/refman/8.0/en/stored-programs-defining.html
The delimiter is changed to // to enable the entire definition to be passed to the server as a single statement, and then restored to ; before invoking the procedure. The following is an example of a function that takes a parameter, performs an ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-auto-increment-columns.html
This view indicates which tables have AUTO_INCREMENT columns and provides information about those columns, such as the current and maximum column values and the usage ratio (ratio of used to possible values). By default, rows are sorted by ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema.html
MySQL 8.0 includes the sys schema, a set of objects that helps DBAs and developers interpret data collected by the Performance Schema. sys schema objects can be used for typical tuning and diagnosis use cases. Objects in this schema include: Views ...For new installations, the sys schema is installed by default during data directory initialization if you use mysqld with the --initialize or --initialize-insecure ...
https://dev.mysql.com/doc/refman/8.0/en/uninstall-component.html
A component provides services that are available to the server and other components; see Section 7.5, “MySQL Components”. If any error occurs, the statement fails and has no effect. A loader service handles component unloading, which includes ...
https://dev.mysql.com/doc/refman/8.0/en/union.html
query_expression_body UNION [ALL | DISTINCT] query_block [UNION [ALL | DISTINCT] query_expression_body] [...] query_expression_body: See Section 15.2.14, “Set Operations with UNION, INTERSECT, and EXCEPT” UNION combines the result from multiple ...STRAIGHT_JOIN now permits a USING clause, similar to other inner ...
https://dev.mysql.com/doc/refman/8.0/en/verifying-md5-checksum.html
Each operating system and setup offers its own version of tools for checking the MD5 checksum. Typically the command is named md5sum, or it may be named md5, and some operating systems do not ship it at all. If you have OpenSSL installed, you can ...