MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 121 to 130 of 138 total results

19.4.10.1 Installing Semisynchronous Replication

https://dev.mysql.com/doc/refman/8.0/en/replication-semisync-installation.html

Semisynchronous replication is implemented using plugins, which must be installed on the source and on the replicas to make semisynchronous replication available on the instances. There are different plugins for a source and for a replica. After a ...

7.6.4.2 Using the Rewriter Query Rewrite Plugin

https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin-usage.html

To enable or disable the plugin, enable or disable the rewriter_enabled system variable. By default, the Rewriter plugin is enabled when you install it (see Section 7.6.4.1, “Installing or Uninstalling the Rewriter Query Rewrite Plugin”). To ...

7.7 MySQL Server Loadable Functions

https://dev.mysql.com/doc/refman/8.0/en/server-loadable-functions.html

MySQL supports loadable functions, that is, functions that are not built in but can be loaded at runtime (either during startup or later) to extend server capabilities, or unloaded to remove capabilities. For a table describing the available ...

7.6 MySQL Server Plugins

https://dev.mysql.com/doc/refman/8.0/en/server-plugins.html

MySQL supports an plugin API that enables creation of server plugins. Plugins can be loaded at server startup, or loaded and unloaded at runtime without restarting the server. The plugins supported by this interface include, but are not limited to, ...

15.7.7.2 SHOW BINLOG EVENTS Statement

https://dev.mysql.com/doc/refman/8.0/en/show-binlog-events.html

SHOW BINLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] Shows the events in the binary log. If you do not specify 'log_name', the first binary log is displayed. The LIMIT clause has the same syntax as for the SELECT statement.

15.7.7.14 SHOW DATABASES Statement

https://dev.mysql.com/doc/refman/8.0/en/show-databases.html

SHOW {DATABASES | SCHEMAS} [LIKE 'pattern' | WHERE expr] SHOW DATABASES lists the databases on the MySQL server host. The LIKE clause, if present, indicates which database names to match. The WHERE clause can be given to select rows using more ...

15.7.7.21 SHOW GRANTS Statement

https://dev.mysql.com/doc/refman/8.0/en/show-grants.html

SHOW GRANTS [FOR user_or_role [USING role [, role] ...]] user_or_role: { user (see Section 8.2.4, “Specifying Account Names”) | role (see Section 8.2.5, “Specifying Role Names”. } This statement displays the privileges and roles that are ...

15.7.7.30 SHOW PROFILE Statement

https://dev.mysql.com/doc/refman/8.0/en/show-profile.html

Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future MySQL release. Use the Performance Schema instead; see Section 29.19.1, “Query Profiling Using Performance Schema”. To control profiling, ...

15.7.7.42 SHOW WARNINGS Statement

https://dev.mysql.com/doc/refman/8.0/en/show-warnings.html

SHOW WARNINGS [LIMIT [offset,] row_count] SHOW COUNT(*) WARNINGS SHOW WARNINGS is a diagnostic statement that displays information about the conditions (errors, warnings, and notes) resulting from executing a statement in the current session.

5.3.4.4 Sorting Rows

https://dev.mysql.com/doc/refman/8.0/en/sorting-rows.html

You may have noticed in the preceding examples that the result rows are displayed in no particular order. It is often easier to examine query output when the rows are sorted in some meaningful way. This means that the order is undefined for columns ...

Displaying 121 to 130 of 138 total results