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/connection-control-plugin-variables.html
connection_control_max_connection_delay Command-Line Format --connection-control-max-connection-delay=# Introduced 5.7.17 System Variable connection_control_max_connection_delay Scope Global Dynamic Yes Type Integer Default Value 2147483647 Minimum ...Connection Control Plugin Status Variables If the CONNECTION_CONTROL plugin is installed, it exposes this status variable: Connection_control_delay_generated The number of times the server added a delay to its response to a failed connection ...
https://dev.mysql.com/doc/refman/5.7/en/mathematical-functions.html
An implication of this is that ABS(-9223372036854775808) produces an error because the result cannot be stored in a signed BIGINT value. The minimum base is 2 and the maximum base is 36. mysql> SELECT COT(12); -> -1.5726734063977 mysql> SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/thread-commands.html
Fetch The thread is fetching the results from executing a prepared statement. Long Data The thread is retrieving long data in the result of executing a prepared statement. Set option The thread is setting or resetting a client statement execution ...
https://dev.mysql.com/doc/refman/5.7/en/show-grants.html
SHOW GRANTS [FOR user] This statement displays the privileges that are assigned to a MySQL user account, in the form of GRANT statements that must be executed to duplicate the privilege assignments. Note To display nonprivilege information for ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-optimizer-statistics.html
This section also provides information about estimating ANALYZE TABLE complexity, which may be useful when attempting to achieve a balance between accurate statistics and ANALYZE TABLE execution time. As a result, different estimates could be ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-elements.html
Version Tokens is based on a plugin library that implements these elements: A server-side plugin named version_tokens holds the list of version tokens associated with the server and subscribes to notifications for statement execution events. The ...
https://dev.mysql.com/doc/refman/5.7/en/string-collating.html
For a simple character set named MYSET, sorting rules are specified in the MYSET.xml configuration file using <map> array elements within <collation> elements. If the sorting rules for your language are too complex to be handled with simple arrays, ...
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/example-storage-engine.html
mysql> CREATE TABLE test (i INT) ENGINE = EXAMPLE; Query OK, 0 rows affected (0.78 sec) mysql> INSERT INTO test VALUES(1),(2),(3); ERROR 1031 (HY000): Table storage engine for 'test' doesn't ยป have this option mysql> SELECT * FROM test; Empty set ... The EXAMPLE storage engine is a stub engine that does ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-overview-requirements.html
NDB Cluster requires communication between data nodes and API nodes (including SQL nodes), as well as between data nodes and other data nodes, to execute queries and updates. In addition, to maintain consistency and service despite the silent ...