MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 121 to 130 of 140 total results

19.1.6.3 Replica Server Options and Variables

https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html

This section explains the server options and system variables that apply to replica servers and contains the following: Startup Options for Replica Servers System Variables Used on Replica Servers Specify the options either on the command line or ...

19.2.1.1 Advantages and Disadvantages of Statement-Based and Row-Based Replication

https://dev.mysql.com/doc/refman/8.0/en/replication-sbr-rbr.html

For most users, the mixed replication format should provide the best combination of data integrity and performance. If, however, you want to take advantage of the features specific to the statement-based or row-based replication format when ...

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, ...

Displaying 121 to 130 of 140 total results