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/performance-schema-replication-group-member-stats-table.html
The replication_group_member_stats table has these columns: CHANNEL_NAME Name of the Group Replication channel VIEW_ID Current view identifier for this group. This has a different value for each member in the group. This also serves as a key because ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-group-members-table.html
This table shows network and status information for replication group members. The replication_group_members table has these columns: CHANNEL_NAME Name of the Group Replication channel. The network addresses shown are the addresses used to connect ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-user-variable-tables.html
The Performance Schema provides a user_variables_by_thread table that exposes user-defined variables. The user_variables_by_thread table has these columns: THREAD_ID The thread identifier of the session in which the variable is defined. The ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-tables-with-full-table-scans.html
These views display which tables are being accessed with full table scans. The schema_tables_with_full_table_scans and x$schema_tables_with_full_table_scans views have these columns: object_schema The schema name. rows_full_scanned The total number ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-internals.html
The cache_policies table, config_options table, and containers table are created by the innodb_memcached_config.sql configuration script in the innodb_memcache database. The containers table contains a default entry for the test.demo_test table, ...
https://dev.mysql.com/doc/refman/8.0/en/set-operations.html
Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using DISTINCT and ALL Set Operations with ORDER BY and LIMIT Limitations of Set Operations SQL set operations combine the results of multiple ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-syntax-warnings.html
SQL Compression Syntax Warnings and Errors for File-Per-Table Tablespaces When innodb_strict_mode is enabled (the default), specifying ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE in CREATE TABLE or ALTER TABLE statements produces the following error if ... This section describes syntax warnings and errors that you may encounter when using the table compression feature with file-per-table tablespaces and general ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-migration.html
To move databases in a binary format from Unix to Windows or from Windows to Unix, create all databases and tables using lowercase names. In addition, MySQL Enterprise Backup can create compressed backup files, and back up subsets of tables. This ...MySQL Enterprise Backup The MySQL Enterprise Backup product lets you back up a running MySQL database with minimal disruption to operations while producing a consistent snapshot of the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-check-constraints-table.html
As of MySQL 8.0.16, CREATE TABLE permits the core features of table and column CHECK constraints, and the CHECK_CONSTRAINTS table provides information about these constraints. The CHECK_CONSTRAINTS table has these columns: CONSTRAINT_CATALOG The ...
https://dev.mysql.com/doc/refman/8.0/en/full-table.html
If a table-full error occurs, it may be that the disk is full or that the table has reached its maximum size. The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL ...