PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-formats.html
Only this format supports the optional query time and size statistics, which are available from MySQL 8.0.30. The following statement displays the possible names: SELECT REPLACE(EVENT_NAME, 'statement/sql/', '') AS name FROM ... The MySQL server ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-replication.html
Because the daemon_memcached plugin supports the MySQL binary log, source server through the memcached interface can be replicated for backup, balancing intensive read workloads, and high availability. The following sections show how to use the ...
https://dev.mysql.com/doc/refman/8.0/en/sql-prepared-statements.html
Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is executed. Other language interfaces can provide support for prepared statements that use the binary ...Typically, database applications process large volumes of almost-identical statements, with only changes to literal or variable values in clauses such as WHERE for queries and deletes, SET for updates, and VALUES for ...
https://dev.mysql.com/doc/refman/8.0/en/connecting-disconnecting.html
To connect to the server, you usually need to provide a MySQL user name when you invoke mysql and, most likely, a password. Once you know the proper parameters, you should be able to connect like this: $> mysql -h host -u user -p Enter password: ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-modifiers.html
In this case, each time there is a change in value in any but the last grouping column, the query produces an extra super-aggregate summary row. The NULL values do appear as NULL on the client side and can be tested as such using any MySQL client ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlock-example.html
If client A attempts to update a row in Birds at the same time, this will lead to a deadlock: mysql> UPDATE Birds SET value=40 WHERE name='Buzzard'; ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction InnoDB rolls ...The Information Schema contains the number of deadlocks: mysql> SELECT `count` FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE NAME="lock_deadlocks"; +-------+ | count | +-------+ | 1 | +-------+ 1 row in set (0.00 sec) The InnoDB status contains the following information about the deadlock and ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-convenience-functions.html
If any argument has a longitude or latitude that is out of range, an error occurs: If a longitude value is not in the range (−180, 180], an ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE error occurs (ER_LONGITUDE_OUT_OF_RANGE prior to MySQL 8.0.12). If ... The functions in this section provide convenience operations on geometry ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-okv-plugin.html
Note The keyring_okv plugin is an extension included in MySQL Enterprise Edition, a commercial product. The plugin works with these KMIP-compatible products: Oracle Key Vault Gemalto SafeNet KeySecure Appliance Townsend Alliance Key Manager Entrust ...The Key Management Interoperability Protocol (KMIP) enables communication of cryptographic keys between a key management server and its ...
https://dev.mysql.com/doc/refman/8.0/en/analyze-table.html
MySQL 8.0.31 and later also supports setting the histogram of a single column to a user-defined JSON value. This issue is resolved in MySQL 8.0.24 (and later), where ANALYZE TABLE no longer causes subsequent operations to wait. MySQL uses the stored ...ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ...
https://dev.mysql.com/doc/refman/8.0/en/storage-engines.html
Storage engines are MySQL components that handle the SQL operations for different table types. (The CREATE TABLE statement in MySQL 8.0 creates InnoDB tables by default.) MySQL Server uses a pluggable storage engine architecture that enables ...