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/comparison-operators.html
The following relational comparison operators can be used to compare not only scalar operands, but row operands: = > < >= <= <> != The descriptions for those operators later in this section detail how they work with row operands. For additional ...
https://dev.mysql.com/doc/refman/5.7/en/create-logfile-group.html
The optional UNDO_BUFFER_SIZE parameter sets the size used by the UNDO buffer for the log file group; The default value for UNDO_BUFFER_SIZE is 8M (eight megabytes); this value cannot exceed the amount of system memory available. This includes any ...For rules covering the naming of log file groups, see Section 9.2, “Schema Object ... CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] [UNDO_BUFFER_SIZE [=] undo_buffer_size] [REDO_BUFFER_SIZE [=] redo_buffer_size] [NODEGROUP [=] nodegroup_id] [WAIT] [COMMENT [=] 'string'] ENGINE [=] engine_name This statement ...
https://dev.mysql.com/doc/refman/5.7/en/gis-polygon-property-functions.html
For arguments of dimension 0 or 1, the result is 0. The result is the sum of the area values of all components for a geometry collection. ST_Centroid({poly|mpoly}) Returns the mathematical centroid for the Polygon or MultiPolygon argument as a Point. This function processes geometry collections by computing the centroid point for components of highest dimension in the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-config-send-buffers.html
This parameter can be set for all types of NDB Cluster nodes—that is, it can be set in the [ndbd], [mgm], and [api] (or [mysql]) sections of the config.ini file. It represents the total amount of memory (in bytes) to be allocated by each node for ...Configuration of the unified send buffer can accomplished by setting the following parameters: ... The NDB kernel ...
https://dev.mysql.com/doc/refman/5.7/en/condition-handling.html
Handlers can be defined for general conditions such as warnings or exceptions, or for specific conditions such as a particular error code. For information about how the server chooses handlers when a condition occurs, see Section 13.6.7.6, “Scope ... Conditions may arise during stored program execution that require special handling, such as exiting the current program block or continuing ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-like.html
LIKE to create an empty table based on the definition of another table, including any column attributes and indexes defined in the original table: CREATE TABLE new_tbl LIKE orig_tbl; The copy is created using the same version of the table storage ...
https://dev.mysql.com/doc/refman/5.7/en/drop-view.html
To avoid this failure scenario, use IF EXISTS syntax in DROP VIEW statements to prevent an error from occurring for views that do not exist. The IF EXISTS clause prevents an error from occurring for views that don't exist. When this clause is given, ...If any views named in the argument list do not exist, the statement returns an error indicating by name which nonexisting views it was unable to drop, but also drops all views in the list that do ...
https://dev.mysql.com/doc/refman/5.7/en/estimating-performance.html
In most cases, you can estimate query performance by counting disk seeks. For small tables, you can usually find a row in one disk seek (because the index is probably cached). For bigger tables, you can estimate that, using B-tree indexes, you need ...In MySQL, an index block is usually 1,024 bytes and the data pointer is usually four ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-variables-table.html
Note The value of the show_compatibility_56 system variable affects the information available from the tables described here. For details, see the description of that variable in Section 5.1.7, “Server System Variables”. Note Information ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-error-handling.html
A lock wait timeout causes InnoDB to roll back the current statement (the statement that was waiting for the lock and encountered the timeout). Both deadlocks and lock wait timeouts are normal on busy servers and it is necessary for applications to ...InnoDB sometimes rolls back only the statement that failed, other times it rolls back the entire ...