PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/audit-log-filter-definitions.html
For information about using JSON data in MySQL, see Section 13.5, “The JSON Data Type”. From MySQL 8.0.28, the AUDIT_ABORT_EXEMPT privilege is available to permit a user account’s queries to always be executed even if an abort item would block ...Filter definitions have this form, where actions indicates how filtering takes place: { "filter": actions } The following discussion describes permitted constructs in filter ...
https://dev.mysql.com/doc/refman/8.0/en/backup-strategy-example.html
Assume also that the MySQL server is under load at the time of the crash. You should include such options as necessary to enable client programs to connect to the MySQL server. For cases of operating system crashes or power failures, we can assume ...Assume that data is stored in the InnoDB storage engine, which has support for transactions and automatic crash ...
https://dev.mysql.com/doc/refman/8.0/en/constraint-foreign-key.html
MATCH options do not have any other effect in MySQL, which in effect enforces MATCH SIMPLE semantics full-time. MySQL supports ON UPDATE and ON DELETE foreign key references in CREATE TABLE and ALTER TABLE statements. SET DEFAULT is also supported ... Foreign keys let you cross-reference related data across tables, and foreign key constraints help keep this spread-out data ...
https://dev.mysql.com/doc/refman/8.0/en/create-logfile-group.html
There can be only one log file group per NDB Cluster instance at any given time. If ENGINE is not set, MySQL tries to use the engine specified by the default_storage_engine server system variable (formerly storage_engine). REDO_BUFFER_SIZE, ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-performance-message-fragmentation.html
From MySQL 8.0.16, by default, large messages are automatically split into fragments that are sent separately and reassembled by the recipients. In order for a replication group to use fragmentation, all group members must be at MySQL 8.0.16 or ...
https://dev.mysql.com/doc/refman/8.0/en/problems-with-null.html
For example, the following statements are completely different: mysql> INSERT INTO my_table (phone) VALUES (NULL); mysql> INSERT INTO my_table (phone) VALUES (''); Both statements insert a value into the phone column, but the first inserts a NULL ...
https://dev.mysql.com/doc/refman/8.0/en/replication-problems.html
Many users have lost time by not doing this soon enough after encountering problems. For example, the --skip-slave-start command line option, or from MySQL 8.0.24, the skip_slave_start system variable, prevents the replication threads from starting ... If you have followed the instructions but your replication setup is not working, the first thing to do is check the error log for ...
https://dev.mysql.com/doc/refman/8.0/en/test-pluggable-authentication.html
MySQL includes a test plugin that checks account credentials and logs success or failure to the server error log. To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the ...This ...
https://dev.mysql.com/doc/refman/8.0/en/using-spatial-indexes.html
The following query finds all objects that are in the given rectangle: mysql> SET @poly = -> 'Polygon((30000 15000, 31000 15000, 31000 16000, 30000 16000, 30000 15000))'; mysql> SELECT fid,ST_AsText(g) FROM geom WHERE -> ... The optimizer ...
https://dev.mysql.com/doc/refman/8.0/en/window-functions-usage.html
For example, if a table contains a TIMESTAMP column named ts, standard SQL permits PARTITION BY ts but not PARTITION BY HOUR(ts), whereas MySQL permits both. MySQL also supports nonaggregate functions that are used only as window functions. A MySQL ...However, whereas an aggregate operation groups query rows into a single result row, a window function produces a result for each query row: The row for which function evaluation occurs is called the current ...