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/spatial-types.html
The Open Geospatial Consortium publishes the OpenGIS® Implementation Standard for Geographic information - Simple feature access - Part 2: SQL option, a document that proposes several conceptual ways for extending an SQL RDBMS to support spatial ...
https://dev.mysql.com/doc/refman/8.0/en/string-functions-charset.html
This applies only to BIN_TO_UUID(), CAST(), CONV(), FORMAT(), HEX(), and SPACE(). MySQL has many operators and functions that return a string. This section answers the question: What is the character set and collation of such a string? For simple ...
https://dev.mysql.com/doc/refman/8.0/en/structured-system-variables.html
To refer to a component of a structured variable instance, you can use a compound name in instance_name.component_name format. A structured variable differs from a regular system variable in two respects: Its value is a structure with components ...
https://dev.mysql.com/doc/refman/8.0/en/subquery-restrictions.html
For statement-based or mixed-format replication, one implication of this indeterminism is that such a query can produce different results on the source and its replicas. In general, you cannot modify a table and select from the same table in a ...
https://dev.mysql.com/doc/refman/8.0/en/sys-metrics.html
This view summarizes MySQL server metrics to show variable names, values, types, and whether they are enabled. The metric type determines the source from which the name is taken: For global status variables: The VARIABLE_NAME column of the ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-thread-stack.html
Returns a JSON formatted stack of all statements, stages, and events within the Performance Schema for a given thread ID. The value should match the THREAD_ID column from some Performance Schema threads table row. row *************************** ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-trace-thread.html
Dumps all Performance Schema data for an instrumented thread to a .dot formatted graph file (for the DOT graph description language). Each result set returned from the procedure should be used for a complete graph. This procedure disables binary ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-usage.html
For additional information about the differences between non-x$ and x$ views, see Section 30.4.3, “sys Schema Views”. To examine sys schema object definitions, use the appropriate SHOW statement or INFORMATION_SCHEMA query. For example, to ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema.html
Stored functions that query Performance Schema configuration and provide formatting services. MySQL 8.0 includes the sys schema, a set of objects that helps DBAs and developers interpret data collected by the Performance Schema. sys schema objects ...
https://dev.mysql.com/doc/refman/8.0/en/system-variables-controlling-tracing.html
optimizer_trace_features: Enables or disables selected features of the MySQL Optimizer, using the syntax shown here: SET optimizer_trace_features=option=value[,option=value][,...] option: {greedy_search | range_optimizer | dynamic_range | ... The ...