PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-introduction.html
MySQL uses the default collation for this character set (utf8_general_ci) for all searches, sorts, comparisons, and other string operations on such columns. Other terms that are sometimes used for this information are data dictionary and system ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-fulltext-index.html
To support proximity search, position information for each word is also stored, as a byte offset. The number of threads that perform this work is configurable using the innodb_ft_sort_pll_degree variable. The index defined on the opening_lines table ... Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-transaction-isolation-levels.html
This means that if you issue several plain (nonlocking) SELECT statements within the same transaction, these SELECT statements are consistent also with respect to each other. For locking reads (SELECT with FOR UPDATE or LOCK IN SHARE MODE), UPDATE, ... Transaction isolation is one of the foundations of database ...
https://dev.mysql.com/doc/refman/5.7/en/encrypted-connection-protocols-ciphers.html
In this case, you cannot establish MySQL connections that use TLSv1 or TLSv1.1, even though MySQL is configured to permit them, because the host system does not permit them. Workarounds for this issue include: Change the system-wide host ... MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-usage.html
This section describes how to configure MySQL Enterprise Firewall using SQL statements. By default, this variable is enabled when the firewall is installed. This section describes how the firewall accomplishes the task of accepting or rejecting ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-nodes-groups.html
This section discusses the manner in which NDB Cluster divides and duplicates data for storage. A number of concepts central to an understanding of this topic are discussed in the next few paragraphs. An ndbd or ndbmtd process, which stores one or ...While it is also possible to host multiple data node processes on a single computer, such a configuration is not usually ...
https://dev.mysql.com/doc/refman/5.7/en/pluggable-authentication.html
Because this is insecure, you might want to use --skip-grant-tables in conjunction with enabling the skip_networking system variable to prevent remote clients from connecting. This plugin is used in conjunction with server-side plugins that require ... When a client connects to the MySQL server, the server uses the user name provided by the client and the client host to select the appropriate account row from the mysql.user system ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html
To use this capability to initialize a MySQL installation, if you previously invoked mysql_install_db manually, invoke mysqld with the --initialize or --initialize-insecure option, depending on whether you want the server to generate a random ...A ...
https://dev.mysql.com/doc/refman/5.7/en/password-management.html
Password Expiration Policy To expire an account password manually, use the ALTER USER statement: ALTER USER 'jeffrey'@'localhost' PASSWORD EXPIRE; This operation marks the password expired in the corresponding mysql.user system table row. MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-routines-table.html
If the routine is a stored procedure, this value is empty. If the routine is a stored procedure, this value is NULL. If the routine is a stored procedure, this value is NULL. If the routine is a stored procedure, this value is NULL. If the routine ... The ROUTINES table provides information about stored routines (stored procedures and stored ...