PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/signal.html
SIGNAL provides error information to a handler, to an outer portion of the application, or to the client. Also, it provides control over the error's characteristics (error number, SQLSTATE value, message). Without SIGNAL, it is necessary to resort ...
https://dev.mysql.com/doc/refman/8.0/en/silent-column-changes.html
In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE statement. These might be changes to a data type, to attributes associated with a data type, or to an index specification. All changes are ...
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”). The optimizer checks the SRID attribute for indexed columns to determine which spatial reference system (SRS) to ...
https://dev.mysql.com/doc/refman/8.0/en/sql-prepared-statements.html
Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is executed. Typically, database applications process large volumes of almost-identical statements, ...
https://dev.mysql.com/doc/refman/8.0/en/start-group-replication.html
START GROUP_REPLICATION [USER='user_name'] [, PASSWORD='user_pass'] [, DEFAULT_AUTH='plugin_name'] Starts group replication. This statement requires the GROUP_REPLICATION_ADMIN privilege (or the deprecated SUPER privilege). If super_read_only=ON is ...
https://dev.mysql.com/doc/refman/8.0/en/start-replica.html
START REPLICA [thread_types] [until_option] [connection_options] [channel_option] thread_types: [thread_type [, thread_type] ... ] thread_type: IO_THREAD | SQL_THREAD until_option: UNTIL { {SQL_BEFORE_GTIDS | SQL_AFTER_GTIDS} = gtid_set | ...
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 ...
https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary-by-file-io-type.html
These views summarize file I/O, grouped by host and event type. By default, rows are sorted by host and descending total I/O latency. The host_summary_by_file_io_type and x$host_summary_by_file_io_type views have these columns: host The host from ...
https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary-by-file-io.html
By default, rows are sorted by descending total file I/O latency. The host_summary_by_file_io and x$host_summary_by_file_io views have these columns: host The host from which the client connected. Rows for which the HOST column in the underlying ...
https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary-by-stages.html
By default, rows are sorted by host and descending total latency. The host_summary_by_stages and x$host_summary_by_stages views have these columns: host The host from which the client connected. Rows for which the HOST column in the underlying ...