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/performance-schema-setup-instruments-table.html
This in turn causes those values to be ignored when calculating the sum, minimum, maximum, and average time values in summary tables. The setup_instruments table lists classes of instrumented objects for which events can be collected: mysql> SELECT ...| statement/sql/load | YES | YES | | statement/sql/grant | YES | YES | | statement/sql/check | YES | YES | | statement/sql/flush | YES | YES | ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-mutex-instances-table.html
The work performed while holding a mutex is said to be in a “critical section,” and multiple queries do execute this critical section in a serialized way (one at a time), which is a potential bottleneck. The mutex_instances table lists all the ...The mutex_instances table has these columns: NAME The instrument name associated with the ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management.html
If you (for example) wish to drop a partition and reorganize a table's remaining partitions, you must do so in two separate ALTER TABLE statements (one using DROP PARTITION and then a second one using REORGANIZE PARTITION). MySQL 5.7 provides a ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-cmpmem-table.html
RELOCATION_TIME The total time in microseconds used for relocating blocks of size PAGE_SIZE. RELOCATION_OPS The number of times a block of size PAGE_SIZE has been relocated. row *************************** page_size: 1024 buffer_pool_instance: 0 ...
https://dev.mysql.com/doc/refman/5.7/en/set-password.html
SET PASSWORD [FOR user] = password_option password_option: { 'auth_string' | PASSWORD('auth_string') } The SET PASSWORD statement assigns a password to a MySQL user account. = PASSWORD('auth_string') syntax is deprecated in MySQL 5.7 and is removed ...
https://dev.mysql.com/doc/refman/5.7/en/functions.html
Expressions can be used at several points in SQL statements, such as in the ORDER BY or HAVING clauses of SELECT statements, in the WHERE clause of a SELECT, DELETE, or UPDATE statement, or in SET statements. Expressions can be written using values ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-introduction.html
InnoDB is a general-purpose storage engine that balances high reliability and high performance. Unless you have configured a different default storage engine, issuing a CREATE TABLE statement without an ENGINE clause creates an InnoDB table. Key ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-disk-data.html
Disk data objects are subject to the following maximums and minimums: Maximum number of tablespaces: 232 (4294967296) Maximum number of data files per tablespace: 216 (65536) The minimum and maximum possible sizes of extents for tablespace data ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-compression-oltp.html
The rise of SSD storage devices, which are fast but relatively small and expensive, makes compression attractive also for OLTP workloads: high-traffic, interactive websites can reduce their storage requirements and their I/O operations per second ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-encrypted-file-plugin.html
Note The keyring_encrypted_file plugin is an extension included in MySQL Enterprise Edition, a commercial product. The keyring_encrypted_file keyring plugin stores keyring data in an encrypted, password-protected file local to the server host.