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/kerberos-pluggable-authentication.html
Note Kerberos pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition supports an authentication method that enables users to authenticate to MySQL Server using Kerberos, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbd-definition.html
This can be used to help guarantee the cluster's real-time characteristics. The three-heartbeat criteria for this determination are the same as described for HeartbeatIntervalDbDb. The determination that a data node is dead is done globally; in ...
https://dev.mysql.com/doc/refman/8.0/en/creating-tables.html
Use a CREATE TABLE statement to specify the layout of your table: mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20), species VARCHAR(20), sex CHAR(1), birth DATE, death DATE); VARCHAR is a good choice for the name, owner, and species ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations.html
This means that the speed of these operations is affected by such factors as file system type and characteristics, disk speed, swap space, file handling efficiency of the operating system, and MySQL server options and variables that relate to file ... This section discusses current restrictions and limitations on MySQL partitioning ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table.html
You can also change characteristics such as the storage engine used for the table or the table comment. Use of table options with ALTER TABLE provides a convenient way of altering single table characteristics. To change the default table character ... ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-effect.html
latin1_swedish_ci latin1_german1_ci latin1_german2_ci Muffler Muffler Müller MX Systems Müller Muffler Müller MX Systems MX Systems MySQL MySQL MySQL The character that causes the different sort orders in this example is ü (German ...The first ...
https://dev.mysql.com/doc/refman/8.0/en/charset-repertoire.html
The repertoire of a character set is the collection of characters in the set. String expressions have a repertoire attribute, which can have two values: ASCII: The expression can contain only ASCII characters; that is, characters in the Unicode ...
https://dev.mysql.com/doc/refman/8.0/en/create-procedure.html
The COLLATE attribute can be used if preceded by a CHARACTER SET specification. The COMMENT characteristic is a MySQL extension, and may be used to describe the stored routine. The LANGUAGE characteristic indicates the language in which the routine ...By default, a stored routine is associated with the default ...
https://dev.mysql.com/doc/refman/8.0/en/explain.html
In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query execution plan (that is, an explanation of how MySQL would execute a query). There is no need to enclose the ... {EXPLAIN | DESCRIBE | DESC} tbl_name [col_name | wild] {EXPLAIN | DESCRIBE | DESC} [explain_type] {explainable_stmt | FOR CONNECTION connection_id} {EXPLAIN | DESCRIBE | DESC} ANALYZE [explain_type] select_stmt explain_type: { FORMAT = format_name } format_name: { TRADITIONAL | JSON | TREE } explainable_stmt: { select_stmt | TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/locking-service.html
The locking interface has these characteristics: Locks have three attributes: Lock namespace, lock name, and lock mode: Locks are identified by the combination of namespace and lock name. Namespace and lock names must be non-NULL, nonempty, and have ... MySQL distributions provide a locking interface that is accessible at two levels: At the SQL level, as a set of loadable functions that each map onto calls to the service ...