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/monitor-alter-table-performance-schema.html
WORK_ESTIMATED is calculated using a formula that takes into account all of the work that ALTER TABLE performs, and may be revised during ALTER TABLE processing. Note InnoDB ALTER TABLE stage events do not currently account for the addition of ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer.html
If you are logged in to your My Oracle Support (MOS) account, the Commercial release includes all of the current and previous GA versions available in the Community release, but it excludes development-milestone versions. The Commercial release also ... MySQL Installer is a standalone application designed to ease the complexity of installing and configuring MySQL products that run on Microsoft ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-table-lock-waits.html
waiting_account The account associated with the session that is waiting for the lock. blocking_account The account associated with the thread that is blocking the waiting lock. These views display which sessions are blocked waiting on metadata ...
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 ...