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-config.html
mysql_config provides you with useful information for compiling your MySQL client and connecting it to MySQL. It is a shell script, so it is available only on Unix and Unix-like systems. --cflags C Compiler flags to find include files and critical ...Note pkg-config can be used as an alternative to mysql_config for obtaining information such as compiler flags or link libraries required to compile MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-enterprise-security.html
LDAP Authentications supports user name and password, SASL, and GSSAPI/Kerberos authentication methods to LDAP services. PAM enables a system to use a standard interface to access various kinds of authentication methods, such as Unix passwords or an ... MySQL Enterprise Edition provides plugins that implement security features using external services: MySQL Enterprise Edition includes an authentication plugin that enables MySQL Server to use LDAP (Lightweight Directory Access Protocol) to authenticate MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-indexes.html
Without an index, MySQL must begin with the first row and then read through the entire table to find the relevant rows. Most MySQL indexes (PRIMARY KEY, UNIQUE, INDEX, and FULLTEXT) are stored in B-trees. Characteristics specific to hash indexes (as ... Indexes are used to find rows with specific column values ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-documents-modify.html
You can use the modify() method to update one or more documents in a collection. The X DevAPI provides additional methods for use with the modify() method to: Set and unset fields within documents. Set and Unset Document Fields The modify() method ...mysql-js> db.countryinfo.modify("Code = 'SEA'").set( "demographics", {"LifeExpectancy": 78, "Population": 28}) After you modify a document, use the find() method to verify the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-documents-modify.html
You can use the modify() method to update one or more documents in a collection. The X DevAPI provides additional methods for use with the modify() method to: Set and unset fields within documents. Set and Unset Document Fields The modify() method ...mysql-py> db.countryinfo.modify("Code = 'SEA'").set( "demographics", {"LifeExpectancy": 78, "Population": 28}) After you modify a document, use the find() method to verify the ...
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-attributes.html
For example, a column specified as SMALLINT(3) has the usual SMALLINT range of -32768 to 32767, and values outside the range permitted by three digits are displayed in full using more than three digits. When used in conjunction with the optional ...
https://dev.mysql.com/doc/refman/8.0/en/numeric-types.html
These types include the exact numeric data types (INTEGER, SMALLINT, DECIMAL, and NUMERIC), as well as the approximate numeric data types (FLOAT, REAL, and DOUBLE PRECISION). The keyword INT is a synonym for INTEGER, and the keywords DEC and FIXED ...For information about storage requirements of the numeric data types, see Section 13.7, “Data Type Storage ...
https://dev.mysql.com/doc/refman/8.0/en/outer-join-simplification.html
This results in a query with no outer joins at all: SELECT * FROM (T1 INNER JOIN T2 ON T2.A=T1.A), T3 WHERE T3.C > 0 AND T3.B=T2.B Sometimes the optimizer succeeds in replacing an embedded outer join operation, but cannot convert the embedding outer ... Table expressions in the FROM clause of a query are simplified in many ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning.html
In MySQL 8.0, partitioning support is provided by the InnoDB and NDB storage engines. MySQL 8.0 Community binaries provided by Oracle include partitioning support provided by the InnoDB and NDB storage engines. See Section 26.1, “Overview of ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-examples.html
To begin, you should have a repeatable use case where performance is deemed “too slow” and needs optimization, and you should enable all instrumentation (no pre-filtering at all). Then truncate the history and summary tables to remove previously ... The Performance Schema is a tool to help a DBA do performance tuning by taking real measurements instead of “wild guesses.” This section demonstrates some ways to use the Performance Schema for this ...