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-params-api.html
The listing in this section provides information about parameters used in the [mysqld] and [api] sections of a config.ini file for configuring NDB Cluster SQL nodes and API nodes. Note To add new SQL or API nodes to the configuration of a running ...For detailed descriptions and other additional information about each of these parameters, see Section 25.4.3.7, “Defining SQL and Other API Nodes in an NDB ...
https://dev.mysql.com/doc/refman/8.0/en/resource-groups.html
The server determines at startup how many virtual CPUs are available, and database administrators with appropriate privileges can associate these CPUs with resource groups and assign threads to groups. Resource group definitions are stored in the ...
https://dev.mysql.com/doc/refman/8.0/en/macos-installation-pkg.html
The package is located inside a disk image (.dmg) file that you first need to mount by double-clicking its icon in the Finder. To install MySQL using the package installer: Download the disk image (.dmg) file (the community version is available ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-indexes.html
If the table has an index for the columns in question, MySQL can quickly determine the position to seek to in the middle of the data file without having to look at all the data. Without an index, MySQL must begin with the first row and then read ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-status-variables.html
Performance_schema_metadata_lock_lost The number of metadata locks that could not be instrumented in the metadata_locks table. This can be nonzero if the value of performance_schema_max_metadata_locks is too small. Performance Schema status ...For ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-instrument-naming.html
Example names: wait/io/file/myisam/log wait/io/file/mysys/charset wait/lock/table/sql/handler wait/synch/cond/mysys/COND_alarm wait/synch/cond/sql/BINLOG::update_cond wait/synch/mutex/mysys/BITMAP_mutex wait/synch/mutex/sql/LOCK_delete ...Suffixes ...The elements of an instrument name from left to right provide a progression from more general to more ...
https://dev.mysql.com/doc/refman/8.0/en/drop-table.html
Be careful with this statement! For each table, it removes the table definition and all table data. If the table is partitioned, the statement removes the table definition, all its partitions, all data stored in those partitions, and all partition ...DROP TABLE causes an implicit commit, except when used with the TEMPORARY ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-generated-columns.html
CREATE TABLE t1 (c1 INT); ALTER TABLE t1 ADD COLUMN c2 INT GENERATED ALWAYS AS (c1 + 1) STORED; The data type and expression of generated columns can be modified. CREATE TABLE t1 (c1 INT, c2 INT GENERATED ALWAYS AS (c1 + 1) STORED); ALTER TABLE t1 ...CREATE TABLE t1 (c1 INT, c2 INT GENERATED ALWAYS AS (c1 + 1) STORED); ALTER TABLE t1 MODIFY COLUMN c2 TINYINT GENERATED ALWAYS AS (c1 + 5) STORED; Generated columns can be renamed or dropped, if no other column refers to ...
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 ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-requirements.html
Infrastructure Server Instance Configuration Server instances that you want to use for Group Replication must satisfy the following requirements. Moreover, InnoDB provides some additional functionality that enables better management and handling of ...Transactions are executed optimistically and then, at commit time, are checked for ...This enables Group Replication to ...