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/mysql-cluster-information-schema-tables.html
The FILES table provides information about NDB Cluster Disk Data files (see Section 25.6.11.1, “NDB Cluster Disk Data Objects”). Additional statistical and other data about NDB Cluster transactions, operations, threads, blocks, and other aspects ...The ndb_transid_mysql_connection_map table provides a mapping between transactions, transaction coordinators, and API ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-directory.html
The result is that MyISAM data and index files are created in the table's database directory. If a DATA DIRECTORY or INDEX DIRECTORY table option is used in a CREATE TABLE statement on the source server, the table option is also used on the replica. This can cause problems if no corresponding directory exists in the replica host file system or if it exists but is not accessible to the replica MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/selinux.html
mysqld_db_t is the type associated with the MySQL data directory and its files. SELinux policy modules use SELinux contexts to define rules for how processes, files, ports, and other system objects interact with each other. An SELinux context (the ... Security-Enhanced Linux (SELinux) is a mandatory access control (MAC) system that implements access rights by applying a security label referred to as an SELinux context to each system ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-wait-tables.html
The Performance Schema instruments waits, which are events that take time. Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within transaction events. These tables store wait events: ...For additional information about configuring event collection, see Section 29.3, “Performance Schema Startup Configuration”, and Section 29.4, “Performance Schema Runtime ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-functions-legacy.html
MySQL Enterprise Encryption functions have these general characteristics: For arguments of the wrong type or an incorrect number of arguments, each function returns an error. For successful decryption, the key string must correspond to the public or ... In releases before MySQL 8.0.30, MySQL Enterprise Encryption's functions are based on the openssl_udf shared ...This occurs, for example, if a function does not support a specified ...
https://dev.mysql.com/doc/refman/8.0/en/lock-tables.html
(An exception to this policy can occur for small values of the max_write_lock_count system variable; see Section 10.11.4, “Metadata Locking”.) If the LOCK TABLES statement must wait due to locks held by other sessions on any of the tables, it ...
https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-functions.html
(This technique is inapplicable if NULL must be permitted as a valid name value.) Use ANY_VALUE() to refer to address: SELECT name, ANY_VALUE(address), MAX(age) FROM t GROUP BY name; In this case, MySQL ignores the nondeterminism of address values ...The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ONLY_FULL_GROUP_BY SQL ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-shutdowns.html
With this setting, the contents of the InnoDB redo log buffer are written out to the log file at each transaction commit and the log file is flushed to disk. However, the replica notices the network outage only after receiving no data from the ...
https://dev.mysql.com/doc/refman/8.0/en/declare-handler.html
statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ... It can take the following forms: mysql_error_code: ...The handler_action value indicates what action the handler takes after execution of the handler statement: CONTINUE: Execution of the current program ...
https://dev.mysql.com/doc/refman/8.0/en/example-auto-increment.html
Use the smallest integer data type for the AUTO_INCREMENT column that is large enough to hold the maximum sequence value you require. When the column reaches the upper limit of the data type, the next attempt to generate a sequence number fails. To ...You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is ...