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-programs-ndb-index-stat.html
--query=# Command-Line Format --query=# Type Numeric Default Value 0 Minimum Value 0 Maximum Value MAX_INT Perform random range queries on first key attribute (must be int unsigned). ndb_index_stat provides per-fragment statistical information ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-queries.html
Follow these guidelines for InnoDB indexes: Because each InnoDB table has a primary key (whether you request one or not), specify a set of primary key columns for each table, columns that are used in the most important and time-critical queries. Do ... To tune queries for InnoDB tables, create an appropriate set of indexes on each ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-status-variable-summary-tables.html
The Performance Schema makes status variable information available in the tables described in Section 29.12.15, “Performance Schema Status Variable Tables”. It also makes aggregated status variable information available in summary tables, ...
https://dev.mysql.com/doc/refman/8.0/en/sys-table-exists.html
Tests whether a given table exists as a regular table, a TEMPORARY table, or a view. If both a temporary and a permanent table exist with the given name, TEMPORARY is returned. Parameters in_db VARCHAR(64): The name of the database in which to ...
https://dev.mysql.com/doc/refman/8.0/en/data-size.html
Many languages can be written primarily using single-byte utf8mb3or utf8mb4 characters, so a fixed storage length often wastes space. For InnoDB tables, the primary key columns are duplicated in each secondary index entry, so a short primary key ...
https://dev.mysql.com/doc/refman/8.0/en/handler.html
To employ the HANDLER interface to refer to a table's PRIMARY KEY, use the quoted identifier `PRIMARY`: HANDLER tbl_name READ `PRIMARY` ... (See Section 17.20, “InnoDB memcached Plugin” for an alternative way to adapt applications that use the ... HANDLER tbl_name OPEN [ [AS] alias] HANDLER tbl_name READ index_name { = | <= | >= | < | > } (value1,value2,...) [ WHERE where_condition ] [LIMIT ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-background.html
All these properties are key to creating a system which ensures that data is consistently replicated across the group of servers. The most common way to create a fault-tolerant system is to resort to making components redundant, in other words the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-waits-current-table.html
The events_waits_current table has these indexes: Primary key on (THREAD_ID, EVENT_ID) TRUNCATE TABLE is permitted for the events_waits_current table. The table stores one row per thread showing the current status of the thread's most recent ...
https://dev.mysql.com/doc/refman/8.0/en/adding-character-set.html
This section discusses the procedure for adding a character set to MySQL. The proper procedure depends on whether the character set is simple or complex: If the character set does not need special string collating routines for sorting and does not ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-component-function-reference.html
Table 8.46 MySQL Enterprise Data Masking and De-Identification Component Functions Name Description Introduced gen_blocklist() Perform dictionary term replacement 8.0.33 gen_dictionary() Return random term from dictionary 8.0.33 gen_range() ...