PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/security-plugins.html
(MySQL Enterprise Edition only) MySQL Enterprise Firewall, an application-level firewall that enables database administrators to permit or deny SQL statement execution based on matching against lists of accepted statement patterns. Data masking ...
https://dev.mysql.com/doc/refman/5.7/en/view-restrictions.html
That shortcoming can lead to problems backing up a database with mysqldump, which may fail due to insufficient privileges. To modify the definition, drop and create the view again with DROP VIEW and CREATE VIEW, or replace the definition with CREATE ... The maximum number of tables that can be referenced in the definition of a view is ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-generated-columns.html
For INSERT, REPLACE, and UPDATE, if a generated column is inserted into, replaced, or updated explicitly, the only permitted value is DEFAULT. Values of a generated column are computed from an expression included in the column definition. Generated ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-ndb-comment-options.html
NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB table. Table-level options for controlling read from any replica and partition balance can be ...
https://dev.mysql.com/doc/refman/5.7/en/explain-for-connection.html
To obtain the execution plan for an explainable statement executing in a named connection, use this statement: EXPLAIN [options] FOR CONNECTION connection_id; EXPLAIN FOR CONNECTION returns the EXPLAIN information that is currently being used to ...
https://dev.mysql.com/doc/refman/5.7/en/explain.html
Obtaining Execution Plan Information The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. In practice, the DESCRIBE keyword is more often used to ...
https://dev.mysql.com/doc/refman/5.7/en/gone-away.html
An INSERT or REPLACE statement that inserts a great many rows can also cause these sorts of errors. Either one of these statements sends a single request to the server irrespective of the number of rows to be inserted; thus, you can often avoid the ... This section also covers the related Lost connection to server during query ...
https://dev.mysql.com/doc/refman/5.7/en/json-function-reference.html
Table 12.22 JSON Functions Name Description Deprecated -> Return value from JSON column after evaluating path; equivalent to JSON_EXTRACT(). ->> Return value from JSON column after evaluating path and unquoting the result; equivalent to ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-perror.html
Added to the MySQL NDB Cluster distribution in NDB 7.6, it is intended as a drop-in replacement for perror --ndb. ndb_perror replaces perror --ndb, which is deprecated in NDB 7.6 and subject to removal in a future release of MySQL NDB Cluster.
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndbmtd.html
In other words, a data node running ndbd can be stopped, the binary replaced with ndbmtd, and then restarted without any loss of data. ndbmtd is a multithreaded version of ndbd, the process that is used to handle all the data in tables using the ...