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/performance-schema-system-variable-tables.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”. The MySQL server ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-backup-configuration.html
Five configuration parameters are essential for backup: BackupDataBufferSize The amount of memory used to buffer data before it is written to disk. BackupLogBufferSize The amount of memory used to buffer log records before these are written to disk. BackupMemory The total memory allocated in a data node for ...
https://dev.mysql.com/doc/refman/5.7/en/case.html
For the second syntax, each WHEN clause search_condition expression is evaluated until one is true, at which point its corresponding THEN clause statement_list executes. When an equal when_value is found, the corresponding THEN clause statement_list ... CASE case_value WHEN when_value THEN statement_list [WHEN when_value THEN statement_list] ...
https://dev.mysql.com/doc/refman/5.7/en/show-procedure-code.html
The second column is Instruction, which contains an SQL statement (usually changed from the original source), or a directive which has meaning only to the stored-routine handler. SHOW PROCEDURE CODE proc_name This statement is a MySQL extension ...
https://dev.mysql.com/doc/refman/5.7/en/begin-end.html
END syntax is used for writing compound statements, which can appear within stored programs (stored procedures and functions, triggers, and events). A compound statement can contain multiple statements, enclosed by the BEGIN and END keywords.
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 ...
https://dev.mysql.com/doc/refman/5.7/en/gis-class-geometrycollection.html
A GeometryCollection is a geometry that is a collection of zero or more geometries of any class. All the elements in a geometry collection must be in the same spatial reference system (that is, in the same coordinate system). There are no other ...
https://dev.mysql.com/doc/refman/5.7/en/index-preloading.html
If there are enough blocks in a key cache to hold blocks of an entire index, or at least the blocks corresponding to its nonleaf nodes, it makes sense to preload the key cache with index blocks before starting to use it. Preloading enables you to ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-ndb-transid-mysql-connection-map-table.html
The ndb_transid_mysql_connection_map table provides a mapping between NDB transactions, NDB transaction coordinators, and MySQL Servers attached to an NDB Cluster as API nodes. This information is used when populating the server_operations and ...
https://dev.mysql.com/doc/refman/5.7/en/macos-installation-prefpane.html
The MySQL Installation Package includes a MySQL preference pane that enables you to start, stop, and control automated startup during boot of your MySQL installation. This preference pane is installed by default, and is listed under your system's ...