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/mysqldump-stored-programs.html
To disable any of these options explicitly, use its skip form: --skip-events, --skip-routines, or --skip-triggers. The other options are disabled by default and must be specified explicitly to dump the corresponding objects.
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-objects-table.html
The value is one of 'EVENT' (Event Scheduler event), 'FUNCTION' (stored function), 'PROCEDURE' (stored procedure), 'TABLE' (base table), or 'TRIGGER' (trigger). The setup_objects table controls whether the Performance Schema monitors particular ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html
(For our purposes, a single query also includes a call to a stored program (stored routine, trigger, or event) and all subprograms called by that program.) This principle also applies to CURDATE(), CURTIME(), UTC_DATE(), UTC_TIME(), UTC_TIMESTAMP(), ... This section describes the functions that can be used to manipulate temporal ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-frequently-asked-questions.html
Warning When the network round-trip time (RTT) between any group members is 5 seconds or more you could encounter problems as the built-in failure detection mechanism could be incorrectly triggered. Otherwise, if the server is so slow that it ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html
Consequently, the case sensitivity of the underlying operating system plays a part in the case sensitivity of database, table, and trigger names. Note Although database, table, and trigger names are not case-sensitive on some platforms, you should ... In MySQL, databases correspond to directories within the data ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-prerequisites.html
Triggers must not have a missing or empty definer or an invalid creation context (indicated by the character_set_client, collation_connection, Database Collation attributes displayed by SHOW TRIGGERS or the INFORMATION_SCHEMA TRIGGERS table). Any ...
https://dev.mysql.com/doc/refman/8.0/en/alter-database.html
alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ALTER DATABASE enables you to change the overall characteristics of a database. If the database name is omitted, the statement applies to the default ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-system-variables.html
group_replication_clone_threshold specifies the transaction gap, as a number of transactions, between the existing member (donor) and the joining member (recipient) that triggers the use of a remote cloning operation for state transfer to the ...
https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html
If any of it is not valid, an SQL error is thrown without triggering the ON ERROR clause. The ON EMPTY clause is triggered when the source JSON document (expr) contains no data at the specified location (path). The functions in this section perform ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-params-ndbd.html
IndexStatTriggerPct: Threshold percent change in DML operations for index statistics updates. IndexStatTriggerScale: Scale down IndexStatTriggerPct by this amount, multiplied by base 2 logarithm of index size, for large index. MaxNoOfFiredTriggers: ... The listings in this section provide information about parameters used in the [ndbd] or [ndbd default] sections of a config.ini file for configuring NDB Cluster data ...