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/group-replication-bootstrap.html
mysql> CREATE DATABASE test; mysql> USE test; mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 TEXT NOT NULL); mysql> INSERT INTO t1 VALUES (1, 'Luis'); Check the content of table t1 and the binary log. The process of starting a group for the first ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-usage.html
After the innodb_file_per_table option is configured, specify the ROW_FORMAT=COMPRESSED clause or KEY_BLOCK_SIZE clause, or both, in a CREATE TABLE or ALTER TABLE statement to create a compressed table in a file-per-table tablespace. The ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-temp-table-info.html
Create a simple InnoDB temporary table: mysql> CREATE TEMPORARY TABLE t1 (c1 INT PRIMARY KEY) ENGINE=INNODB; Query INNODB_TEMP_TABLE_INFO to view the temporary table metadata. mysql> CREATE TEMPORARY TABLE t1 (c1 INT PRIMARY KEY) ENGINE=INNODB; ...
https://dev.mysql.com/doc/refman/8.0/en/lock-order-tool.html
lock_order_debug_missing_key Command-Line Format --lock-order-debug-missing-key[={OFF|ON}] Introduced 8.0.17 System Variable lock_order_debug_missing_key Scope Global Dynamic No SET_VAR Hint Applies No Type Boolean Default Value OFF Whether the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-dict-obj-info.html
The dict_obj_info table provides information about NDB data dictionary (DICT) objects such as tables and indexes. (The dict_obj_types table can be queried for a list of all the types.) This information includes the object's type, state, parent ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-dictionary-tables.html
dictionary_tables contains the columns listed here: table_id The table' unique ID database_name Name of the database containing the table table_name Name of the table status The table status; one of New, Changed, Retrieved, Invalid, or Altered.
https://dev.mysql.com/doc/refman/8.0/en/optimize-character.html
If a table contains string columns such as name and address, but many queries do not retrieve those columns, consider splitting the string columns into a separate table and using join queries with a foreign key when necessary. When you use a ... For ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-file-summary-tables.html
The file I/O summary tables have these indexes: file_summary_by_event_name: Primary key on (EVENT_NAME) file_summary_by_instance: Primary key on (OBJECT_INSTANCE_BEGIN) Index on (FILE_NAME) Index on (EVENT_NAME) TRUNCATE TABLE is permitted for file ... The Performance Schema maintains file I/O summary tables that aggregate information about I/O ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-applier-configuration-table.html
REQUIRE_TABLE_PRIMARY_KEY_CHECK Whether the channel requires primary keys always, never, or according to the source's setting (CHANGE REPLICATION SOURCE TO option: REQUIRE_TABLE_PRIMARY_KEY_CHECK, CHANGE MASTER TO option: ... This table shows the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-socket-summary-tables.html
The socket summary tables have these indexes: socket_summary_by_event_name: Primary key on (EVENT_NAME) socket_summary_by_instance: Primary key on (OBJECT_INSTANCE_BEGIN) Index on (EVENT_NAME) TRUNCATE TABLE is permitted for socket summary tables.