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/mysql-cluster-ndbinfo-locks-per-fragment.html
This table also shows the total time spent waiting for locks successfully and unsuccessfully since fragment or table creation, or since the most recent restart. The values shown in all of the columns ex_req, ex_req_imm_ok, ex_wait_ok, ex_wait_fail, ... The locks_per_fragment table provides information about counts of lock claim requests, and the outcomes of these requests on a per-fragment basis, serving as a companion table to operations_per_fragment and ...
https://dev.mysql.com/doc/refman/8.0/en/extensions-to-ansi.html
The KEY_BLOCK_SIZE clause in the following comment is executed only by servers from MySQL 5.1.10 or higher: CREATE TABLE t1(a INT, KEY (a)) /*!50110 KEY_BLOCK_SIZE=1024 */; The following descriptions list MySQL extensions, organized by category. Be ... MySQL Server supports some extensions that you are not likely to find in other SQL ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-default-stopword-table.html
The INNODB_FT_DEFAULT_STOPWORD table holds a list of stopwords that are used by default when creating a FULLTEXT index on InnoDB tables. For related usage information and examples, see Section 17.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-clone-tables.html
If the clone plugin is loaded but disabled, the tables are not created. Note The Performance Schema tables described here are available as of MySQL 8.0.17. The following sections describe the Performance Schema tables associated with the clone ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-file-summary-tables.html
The Performance Schema maintains file I/O summary tables that aggregate information about I/O operations. Each file I/O summary table has one or more grouping columns to indicate how the table aggregates events. Event names refer to names of event ...Example file I/O event summary information: mysql> SELECT * FROM performance_schema.file_summary_by_event_name\G ...
https://dev.mysql.com/doc/refman/8.0/en/ndb-restore-to-different-version.html
Tables created in NDB 8.0 by default use the utf8mb4_ai_ci character set, which is not available in NDB 7.6 and earlier, and so cannot be read by an ndb_restore binary from one of these earlier versions. Due to changes in how the MySQL Server and ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-temporary-tablespace.html
Session Temporary Tablespaces Session temporary tablespaces store user-created temporary tables and internal temporary tables created by the optimizer when InnoDB is configured as the storage engine for on-disk internal temporary tables. InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-pruning.html
By limiting the search, it is possible to expend much less time and effort in finding matching rows than by scanning all partitions in the table. When the optimizer can make use of partition pruning in performing this query, execution of the query ... The optimization known as partition pruning is based on a relatively simple concept which can be described as “Do not scan partitions where there can be no matching ...
https://dev.mysql.com/doc/refman/8.0/en/getting-information.html
You can obtain the CREATE TABLE statement necessary to create an existing table using the SHOW CREATE TABLE statement. What if you forget the name of a database or table, or what the structure of a given table is (for example, what its columns are ...You have previously seen SHOW DATABASES, which lists the databases managed by the ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-usage.html
The allowlist is the set of rules that defines which statements are acceptable to the profile. For example: the profile can be placed in training mode to establish the allowlist; the allowlist can be used for restricting statement execution or ...