MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 341 to 350 of 353 total results

19.1.6.1 Replication and Binary Logging Option and Variable Reference

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

The following two sections provide basic information about the MySQL command-line options and system variables applicable to replication and the binary log. Replication Options and Variables The command-line options and system variables in the ...

19.3.3.2 Privilege Checks For Group Replication Channels

https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks-gr.html

From MySQL 8.0.19, as well as securing asynchronous and semi-synchronous replication, you may choose to use a PRIVILEGE_CHECKS_USER account to secure the two replication applier threads used by Group Replication. The group_replication_applier ...

19.5.4 Troubleshooting Replication

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

If you have followed the instructions but your replication setup is not working, the first thing to do is check the error log for messages. Many users have lost time by not doing this soon enough after encountering problems. If you cannot tell from ...

19.2.5.4 Replication Channel Based Filters

https://dev.mysql.com/doc/refman/8.0/en/replication-rules-channel-based-filters.html

This section explains how to work with replication filters when multiple replication channels exist, for example in a multi-source replication topology. Before MySQL 8.0, all replication filters were global, so filters were applied to all ...

7.6.4.3 Rewriter Query Rewrite Plugin Reference

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

Users communicate with the plugin by modifying the set of rules stored in this table. The plugin communicates information to users by setting the table's message column. Note The rules table is loaded into the plugin by the flush_rewrite_rules ...

5.3.4.3 Selecting Particular Columns

https://dev.mysql.com/doc/refman/8.0/en/selecting-columns.html

If you do not want to see entire rows from your table, just name the columns in which you are interested, separated by commas.

15.7.7.22 SHOW INDEX Statement

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

SHOW [EXTENDED] {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index information. This statement requires some privilege for any column in the table. row *************************** Table: ...

14.16.2 Argument Handling by Spatial Functions

https://dev.mysql.com/doc/refman/8.0/en/spatial-function-argument-handling.html

Spatial values, or geometries, have the properties described in Section 13.4.2.2, “Geometry Class”. Specific functions or groups of functions may have additional or different argument-handling characteristics, as discussed in the sections where ...

10.2.2.2 Optimizing Subqueries with Materialization

https://dev.mysql.com/doc/refman/8.0/en/subquery-materialization.html

The optimizer uses materialization to enable more efficient subquery processing. Materialization speeds up query execution by generating a subquery result as a temporary table, normally in memory. The first time MySQL needs the subquery result, it ...

10.4.3.1 How MySQL Opens and Closes Tables

https://dev.mysql.com/doc/refman/8.0/en/table-cache.html

When you execute a mysqladmin status command, you should see something like this: Uptime: 426 Running threads: 1 Questions: 11082 Reloads: 1 Open tables: 12 The Open tables value of 12 can be somewhat puzzling if you have fewer than 12 tables.

Displaying 341 to 350 of 353 total results