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/replication-multi-source-configuration.html
Replicas in a multi-source replication topology require TABLE repositories for the replica's connection metadata repository and applier metadata repository, which are the default in MySQL 8.0. A multi-source replication topology requires at least ...
https://dev.mysql.com/doc/refman/8.0/en/resignal.html
For information about the diagnostics area, see Section 15.6.7.7, “The MySQL Diagnostics Area”. A condition area contains condition information items, such as the SQLSTATE value, MYSQL_ERRNO, or MESSAGE_TEXT. ERROR 1051 (42S02): Unknown table ...
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin.html
MySQL supports query rewrite plugins that can examine and possibly modify SQL statements received by the server before the server executes them. MySQL distributions include a postparse query rewrite plugin named Rewriter and scripts for installing ...These elements work together to provide statement-rewriting capability: A server-side plugin named Rewriter examines statements and may rewrite them, based on its in-memory cache of rewrite ...
https://dev.mysql.com/doc/refman/8.0/en/selecting-rows.html
As shown in the preceding section, it is easy to retrieve an entire table. But typically you don't want to see the entire table, particularly when it becomes large. Instead, you're usually more interested in answering a particular question, in ...
https://dev.mysql.com/doc/refman/8.0/en/show-engines.html
For information about MySQL storage engines, see Chapter 17, The InnoDB Storage Engine, and Chapter 18, Alternative Storage Engines. row *************************** Engine: FEDERATED Support: NO Comment: Federated MySQL storage engine Transactions: ... SHOW [STORAGE] ENGINES SHOW ENGINES displays status information about the server's storage ...
https://dev.mysql.com/doc/refman/8.0/en/show-index.html
These two statements are equivalent: SHOW INDEX FROM mytable FROM mydb; SHOW INDEX FROM mydb.mytable; The optional EXTENDED keyword causes the output to include information about hidden indexes that MySQL uses internally and are not accessible by ...
https://dev.mysql.com/doc/refman/8.0/en/show-variables.html
SHOW [GLOBAL | SESSION] VARIABLES [LIKE 'pattern' | WHERE expr] SHOW VARIABLES shows the values of MySQL system variables (see Section 7.1.8, “Server System Variables”). These are the values used to initialize the corresponding session ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-index-optimization.html
MySQL permits creation of SPATIAL indexes on NOT NULL geometry-valued columns (see Section 13.4.10, “Creating Spatial Indexes”). (Prior to MySQL 8.0, the optimizer performs comparisons of SPATIAL index values using Cartesian calculations; the ...The optimizer checks the SRID attribute for indexed columns to determine which spatial reference system (SRS) to use for comparisons, and uses calculations appropriate to the ...
https://dev.mysql.com/doc/refman/8.0/en/start-group-replication.html
In MySQL 8.0.21 and later, you can specify user credentials for distributed recovery on the START GROUP_REPLICATION statement using the USER, PASSWORD, and DEFAULT_AUTH options, as follows: USER: The replication user for distributed recovery. If you ... START GROUP_REPLICATION [USER='user_name'] [, PASSWORD='user_pass'] [, DEFAULT_AUTH='plugin_name'] Starts group ...
https://dev.mysql.com/doc/refman/8.0/en/structured-system-variables.html
The following example starts the server with three different key caches having sizes in a 3:1:1 ratio: $> mysqld --key_buffer_size=6M \ --hot_cache.key_buffer_size=2M \ --cold_cache.key_buffer_size=2M Structured variable values may be set and ... A ...