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/version-tokens-reference.html
The following functions permit the server's list of version tokens to be created, changed, removed, and inspected. If a token does not exist, it is created with the given value. The following discussion serves as a reference to these Version Tokens ...
https://dev.mysql.com/doc/refman/5.7/en/workbench.html
MySQL Workbench provides five main areas of functionality: SQL Development: Enables you to create and manage connections to database servers. Data Modeling: Enables you to create models of your database schema graphically, reverse and forward ...
https://dev.mysql.com/doc/refman/5.7/en/x-plugin-status-variables.html
If the bind has failed, or if the skip_networking option has been used, the value shows UNDEFINED. Mysqlx_errors_unknown_message_type The number of unknown message types that have been received. Mysqlx_notice_other_sent The number of other types of ...
https://dev.mysql.com/doc/refman/5.7/en/generated-column-index-optimizations.html
For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as the expression f1 + 1. The column is also indexed and the optimizer can take that index into account during execution plan ...This ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-disk-data.html
Extents require sufficient DiskPageBufferMemory; you must reserve enough for this parameter to account for all memory used by all extents (number of extents times size of extents). Disk data objects are subject to the following maximums and ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-connection-attribute-tables.html
These Performance Schema tables expose attribute information: session_account_connect_attrs: Connection attributes for the current session, and other sessions associated with the session account session_connect_attrs: Connection attributes for all ... Connection attributes are key-value pairs that application programs can pass to the server at connect ...
https://dev.mysql.com/doc/refman/5.7/en/ssl-libraries.html
(yaSSL accepts these options but silently ignores them.) Accounts that authenticate using the sha256_password plugin can use RSA key files for secure password exchange over unencrypted connections. See Section 6.3.3.1, “Creating SSL and RSA ...
https://dev.mysql.com/doc/refman/5.7/en/aggregate-functions.html
For a faster count, create a counter table and let your application update it according to the inserts and deletes it does. This section describes aggregate functions that operate on sets of values. They are often used with a GROUP BY clause to ...
https://dev.mysql.com/doc/refman/5.7/en/alter-function.html
However, you cannot change the parameters or body of a stored function using this statement; to make such changes, you must drop and re-create the function using DROP FUNCTION and CREATE FUNCTION. (That privilege is granted automatically to the ...
https://dev.mysql.com/doc/refman/5.7/en/alter-procedure.html
However, you cannot change the parameters or body of a stored procedure using this statement; to make such changes, you must drop and re-create the procedure using DROP PROCEDURE and CREATE PROCEDURE. By default, that privilege is granted ... ALTER ...