PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/source-thread-states.html
If you see no Binlog Dump threads on a source, this means that replication is not running; that is, that no replicas are currently connected. The following list shows the most common states you may see in the State column for the Binlog Dump thread ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-type-overview.html
MySQL has spatial data types that correspond to OpenGIS classes. The basis for these types is described in Section 11.4.2, “The OpenGIS Geometry Model”. Some spatial data types hold single geometry values: GEOMETRY POINT LINESTRING POLYGON ...
https://dev.mysql.com/doc/refman/5.7/en/sql-compound-statements.html
END compound statement and other statements that can be used in the body of stored programs: Stored procedures and functions, triggers, and events. These objects are defined in terms of SQL code that is stored on the server for later invocation (see ...
https://dev.mysql.com/doc/refman/5.7/en/sql-replication-statements.html
Replication can be controlled through the SQL interface using the statements described in this section. Statements are split into a group which controls replication source servers, a group which controls replica servers, and a group which can be ...
https://dev.mysql.com/doc/refman/5.7/en/sql-statements.html
This chapter describes the syntax for the SQL statements supported by MySQL.
https://dev.mysql.com/doc/refman/5.7/en/statement-optimization.html
The tuning guidelines in this section help to speed up all kinds of MySQL applications. The core logic of a database application is performed through SQL statements, whether issued directly through an interpreter or submitted behind the scenes ...
https://dev.mysql.com/doc/refman/5.7/en/storage-engine-setting.html
If the desired engine is unavailable, this setting produces an error instead of a warning, and the table is not created or altered. When you create a new table, you can specify which storage engine to use by adding an ENGINE table option to the ...
https://dev.mysql.com/doc/refman/5.7/en/stored-program-variables.html
System variables and user-defined variables can be used in stored programs, just as they can be used outside stored-program context. In addition, stored programs can use DECLARE to define local variables, and stored routines (procedures and ...
https://dev.mysql.com/doc/refman/5.7/en/sys-extract-table-from-file-name.html
This function is useful when extracting file I/O information from the Performance Schema that includes file path names. Given a file path name, returns the path component that represents the table name. It provides a convenient way to display table ...
https://dev.mysql.com/doc/refman/5.7/en/sys-list-add.html
This function and list_drop() can be useful for manipulating the value of system variables such as sql_mode and optimizer_switch that take a comma-separated list of values. Adds a value to a comma-separated list of values and returns the result.