Search Results
https://dev.mysql.com/doc/refman/8.4/en/spatial-reference-systems.html
It has the name (SRS_NAME) WGS 84 and the ID (SRS_ID) 4326, which is the ID used by the European Petroleum Survey Group (EPSG). A spatial reference system (SRS) for spatial data is a coordinate-based system for geographic locations. There are ...
https://dev.mysql.com/doc/refman/8.4/en/storage-engines.html
Merge: Enables a MySQL DBA or developer to logically group a series of identical MyISAM tables and reference them as one object. Storage engines are MySQL components that handle the SQL operations for different table types. InnoDB is the default ...
https://dev.mysql.com/doc/refman/8.4/en/subqueries.html
A subquery can contain many of the keywords or clauses that an ordinary SELECT can contain: DISTINCT, GROUP BY, ORDER BY, LIMIT, joins, index hints, UNION constructs, comments, functions, and so on. All subquery forms and operations that the SQL ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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 ...
MySQL 8.4 Reference Manual :: 30.4.3.4 The host_summary_by_stages and x$host_summary_by_stages Views
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/sys-host-summary-by-statement-latency.html
The host_summary_by_statement_latency and x$host_summary_by_statement_latency views have these columns: host The host from which the client connected. Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to ...
https://dev.mysql.com/doc/refman/8.4/en/sys-host-summary-by-statement-type.html
These views summarize information about statements executed, grouped by host and statement type. By default, rows are sorted by host and descending total latency. The host_summary_by_statement_type and x$host_summary_by_statement_type views have ...
https://dev.mysql.com/doc/refman/8.4/en/sys-host-summary.html
These views summarize statement activity, file I/O, and connections, grouped by host. The host_summary and x$host_summary views have these columns: host The host from which the client connected. Rows for which the HOST column in the underlying ...