MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 111 to 120 of 121 total results

26.3.3 Exchanging Partitions and Subpartitions with Tables

https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-exchange.html

Table nt contains no foreign key references, and no other table has any foreign keys that refer to nt. There are no rows in nt that lie outside the boundaries of the partition definition for p. For InnoDB tables, both tables must use the same row ...

26.5 Partition Selection

https://dev.mysql.com/doc/refman/8.0/en/partitioning-selection.html

Explicit selection of partitions and subpartitions for rows matching a given WHERE condition is supported. Partition selection is similar to partition pruning, in that only specific partitions are checked for matches, but differs in two key ...

29.6 Performance Schema Instrument Naming Conventions

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 ... An ...

10.2.4 Optimizing Performance Schema Queries

https://dev.mysql.com/doc/refman/8.0/en/performance-schema-optimization.html

Applications that monitor databases may make frequent use of Performance Schema tables. To write queries for these tables most efficiently, take advantage of their indexes. For example, include a WHERE clause that restricts retrieved rows based on ...

29.1 Performance Schema Quick Start

https://dev.mysql.com/doc/refman/8.0/en/performance-schema-quick-start.html

row *************************** Table: setup_consumers Create Table: CREATE TABLE `setup_consumers` ( `NAME` varchar(64) NOT NULL, `ENABLED` enum('YES','NO') NOT NULL, PRIMARY KEY (`NAME`) ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 ... This ...

7.1.8 Server System Variables

https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html

The MySQL server maintains many system variables that affect its operation. Most system variables can be set at server startup using options on the command line or in an option file. Most of them can be changed dynamically at runtime using the SET ...

15.7.6.2 SET CHARACTER SET Statement

https://dev.mysql.com/doc/refman/8.0/en/set-character-set.html

SET {CHARACTER SET | CHARSET} {'charset_name' | DEFAULT} This statement maps all strings sent between the server and the current client with the given mapping. SET CHARACTER SET sets three session system variables: character_set_client and ...

15.7.7.9 SHOW CREATE PROCEDURE Statement

https://dev.mysql.com/doc/refman/8.0/en/show-create-procedure.html

row *************************** Function: hello sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION Create Function: CREATE DEFINER=`me`@`localhost` FUNCTION `hello`(s ...

15.7.7 SHOW Statements

https://dev.mysql.com/doc/refman/8.0/en/show.html

SHOW has many forms that provide information about databases, tables, columns, or status information about the server. The pattern is useful for restricting statement output to matching values. Several SHOW statements also accept a WHERE clause ...

13.3.1 String Data Type Syntax

https://dev.mysql.com/doc/refman/8.0/en/string-type-syntax.html

[NATIONAL] CHAR[(M)] [CHARACTER SET charset_name] [COLLATE collation_name] A fixed-length string that is always right-padded with spaces to the specified length when stored. TINYTEXT [CHARACTER SET charset_name] [COLLATE collation_name] A TEXT ...

Displaying 111 to 120 of 121 total results