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/symbolic-links.html
You might want to do this, for example, to move a database to a file system with more free space or increase the speed of your system by spreading your tables to different disks. For InnoDB tables, use the DATA DIRECTORY clause of the CREATE TABLE ... You can move databases or tables from the database directory to other locations and replace them with symbolic links to the new ...
https://dev.mysql.com/doc/refman/8.0/en/creating-spatial-columns.html
Columns with a spatial data type can have an SRID attribute, to explicitly indicate the spatial reference system (SRS) for values stored in the column. Spatial columns are supported for MyISAM, InnoDB, NDB, and ARCHIVE tables. See also the notes ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication.html
Normal (non-clustered) replication involves a source server and a replica server, the source being so named because operations and data to be replicated originate with it, and the replica being the recipient of these. We refer to the MySQL source ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-blob.html
Do not use this technique when the entire table is compressed by InnoDB or MyISAM. Since the performance requirements to retrieve and display a BLOB value might be very different from other data types, you could put the BLOB-specific table on a ...
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin-usage.html
The plugin determines whether to rewrite statements based on its in-memory cache of rewriting rules, which are loaded from the rewrite_rules table in the query_rewrite database. row *************************** id: 1 pattern: SELECT ? ... To enable ...Statements occurring within view definitions or stored programs are not subject to ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-servers.html
If you use the following log file options, their values must differ for each server: --general_log_file=file_name --log-bin[=file_name] --slow_query_log_file=file_name --log-error[=file_name] For further discussion of log file options, see Section ...In addition to using different data directories, several other options must have different values for each server instance: --port=port_num --port controls the port number for TCP/IP ...
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. If ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-applier-status-by-worker-table.html
For a single-threaded replica, data is shown for the replica's single applier thread. All error codes and messages displayed in the columns relating to errors correspond to error values listed in Server Error Message Reference. LAST_ERROR_NUMBER, ...
https://dev.mysql.com/doc/refman/8.0/en/derived-table-optimization.html
Thus, if an ER_UPDATE_TABLE_USED error occurs for a view reference that uses an expression equivalent to the subquery, adding ALGORITHM=TEMPTABLE to the view definition prevents merging and takes precedence over the derived_merge value. If such an ...The optimizer handles derived tables, view references, and common table expressions the same way: It avoids unnecessary materialization whenever possible, which enables pushing down conditions from the outer query to derived tables and produces more efficient execution ...
https://dev.mysql.com/doc/refman/8.0/en/stored-program-restrictions.html
This is because stored routine and trigger definitions are stored in tables in the mysql system database using InnoDB tables, which are not copied between Cluster nodes. If you refer to a temporary table multiple times in a stored function under ...