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/error-log-configuration.html
In MySQL 8.0, error logging uses the MySQL component architecture described at Section 7.5, “MySQL Components”. By default, log_error_services has this value: mysql> SELECT @@GLOBAL.log_error_services; +----------------------------------------+ ...The error log subsystem consists of components that perform log event filtering and writing, as well as a system variable that configures which components to load and enable to achieve the desired logging ...
https://dev.mysql.com/doc/refman/8.0/en/hexadecimal-literals.html
In numeric contexts, MySQL treats a hexadecimal literal like a BIGINT UNSIGNED (64-bit unsigned integer). Converted to a number, it produces 0: mysql> SELECT CHARSET(X''), LENGTH(X''); +--------------+-------------+ | CHARSET(X'') | LENGTH(X'') | ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool-resize.html
$> mysqld --innodb-buffer-pool-size=8G --innodb-buffer-pool-instances=16 mysql> SELECT @@innodb_buffer_pool_size/1024/1024/1024; +------------------------------------------+ | @@innodb_buffer_pool_size/1024/1024/1024 | ... You can configure InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/invisible-columns.html
However, even if explicitly referenced, a column that is invisible in the existing table is visible in the new table: mysql> CREATE TABLE t1 (col1 INT, col2 INT INVISIBLE); mysql> CREATE TABLE t2 AS SELECT col1, col2 FROM t1; mysql> SHOW CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/replication-setup-replicas.html
On the source, released the read lock: mysql> UNLOCK TABLES; On the replica, edited the MySQL configuration. The database updates are automatically propagated to the replicas: $> mysql -h source < fulldb.dump 19.1.2.6.2 Setting Up Replication with ...Before you proceed, ensure that you have: Configured the source with the necessary configuration ...
https://dev.mysql.com/doc/refman/8.0/en/show-grants.html
} This statement displays the privileges and roles that are assigned to a MySQL user account or role, in the form of GRANT statements that must be executed to duplicate the privilege and role assignments. Note To display nonprivilege information for ... SHOW GRANTS [FOR user_or_role [USING role [, role] ...]] user_or_role: { user (see Section 8.2.4, “Specifying Account Names”) | role (see Section 8.2.5, “Specifying Role ...
https://dev.mysql.com/doc/refman/8.0/en/string-type-syntax.html
In some cases, MySQL may change a string column to a type different from that given in a CREATE TABLE or ALTER TABLE statement. For definitions of character string columns (CHAR, VARCHAR, and the TEXT types), MySQL interprets length specifications ... The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-mta.html
(The default is COMMIT_ORDER.) Writeset maintenance work in NDB is performed by the MySQL binary log injector thread as part of preparing and committing each epoch transaction to the binary log. NDB 8.0.33 and later supports the ...To use this ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-schema.html
For comprehensive Performance Schema documentation, see Chapter 29, MySQL Performance Schema. You can profile certain internal InnoDB operations using the MySQL Performance Schema feature. For example, to view information about instrumented InnoDB ... This section provides a brief introduction to InnoDB integration with Performance ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-multi-source.html
Not all MySQL servers taking part in multi-source replication must act as both source and replica, and a given NDB Cluster might use different SQL nodes for different replication channels. Such a case is shown here: Figure 25.18 NDB Cluster ... It ...