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/deallocate-prepare.html
Attempting to execute a prepared statement after deallocating it results in an error. {DEALLOCATE | DROP} PREPARE stmt_name To deallocate a prepared statement produced with PREPARE, use a DEALLOCATE PREPARE statement that refers to the prepared ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-ndb-comment-options.html
NDB_COLUMN can be used in a column comment to set the size of the blob parts table column used for storing parts of blob values by NDB to its maximum. Using any value other than 0 or 1 results in a syntax error. The effect of using ... NDB_COLUMN ...
https://dev.mysql.com/doc/refman/5.7/en/full-table.html
If a table-full error occurs, it may be that the disk is full or that the table has reached its maximum size. The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/replication-threads.html
If the replica stops before the SQL thread has executed all the fetched statements, the I/O thread has at least fetched everything so that a safe copy of the transactions is stored locally in the replica's relay logs, ready for execution the next ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-disk-data-objects.html
Important There can exist at most one log file group in the same NDB Cluster at any given time. You cannot add an index to a column that has been explicitly declared STORAGE DISK, without first changing its storage type to MEMORY; any attempt to do ... NDB Cluster Disk Data storage is implemented using a number of Disk Data ...
https://dev.mysql.com/doc/refman/5.7/en/index-hints.html
This provides more fine-grained control over optimizer selection of an execution plan for various phases of query processing. With statement-based binary logging, having different modes for the source and replicas might lead to replication errors.
https://dev.mysql.com/doc/refman/5.7/en/spatial-operator-functions.html
If any geometry argument is not a syntactically well-formed geometry, an ER_GIS_INVALID_DATA error occurs. An ER_WRONG_ARGUMENTS error occurs for ST_Buffer() with a negative distance for Point, MultiPoint, LineString, and MultiLineString values, and ... OpenGIS proposes a number of functions that can produce ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-installation.html
To verify that, connect to the server and execute this statement: mysql> SHOW GLOBAL VARIABLES LIKE 'mysql_firewall_mode'; +---------------------+-------+ | Variable_name | Value | +---------------------+-------+ | mysql_firewall_mode | ON | ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-windows-initial-start.html
Once the NDB Cluster executables and needed configuration files are in place, performing an initial start of the cluster is simply a matter of starting the NDB Cluster executables for all nodes in the cluster. This means that, if the management ...
https://dev.mysql.com/doc/refman/5.7/en/no-login-pluggable-authentication.html
Use cases for this plugin include: Accounts that must be able to execute stored programs and views with elevated privileges without exposing those privileges to ordinary users. With this plugin-loading method, the option must be given each time the ... The mysql_no_login server-side authentication plugin prevents all client connections to any account that uses ...