PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/password-security-user.html
For example: $> mysql -u francis -pfrank db_name Warning This is convenient but insecure. Also, on some systems this overwriting strategy is ineffective and the password remains visible to ps. In this case, the client program solicits the password ... MySQL users should use the following guidelines to keep passwords ...
https://dev.mysql.com/doc/refman/5.7/en/range-optimization.html
To work around this limitation, you can use a UNION with identical SELECT statements, except that you put each spatial predicate in a different SELECT. This means that the interval can be produced only for conditions in the following form: key_part1 ... The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-partitioning.html
A sample of this layout is shown in Figure 16.2, “Replicating Databases to Separate Replicas”. Figure 16.2 Replicating Databases to Separate Replicas You can achieve this separation by configuring the source and replicas as normal, and then ...
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-tuning.html
This section provides guidelines on setting thread pool system variables for best performance, measured using a metric such as transactions per second. This is done by means of a timeout that can be tuned using the thread_pool_stall_limit system ...
https://dev.mysql.com/doc/refman/5.7/en/regexp.html
This section does not contain all the details that can be found in Henry Spencer's regex(7) manual page. Table 12.14 Regular Expression Functions and Operators Name Description NOT REGEXP Negation of REGEXP REGEXP Whether string matches regular ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-workflow.html
If you select this option, you are responsible for securing the Data folder and its related files manually after the server configuration finishes. This does not apply to files and directories for specific products, such as the MySQL server data ...
https://dev.mysql.com/doc/refman/5.7/en/comparison-operators.html
The following relational comparison operators can be used to compare not only scalar operands, but row operands: = > < >= <= <> != The descriptions for those operators later in this section detail how they work with row operands. Some of the ...
https://dev.mysql.com/doc/refman/5.7/en/general-thread-states.html
After create This occurs when the thread creates a table (including internal temporary tables), at the end of the function that creates the table. This state is used even if the table could not be created due to some error. This state occurs after ... The following list describes thread State values that are associated with general query processing and not more specialized activities such as ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-index-cache-table.html
FIRST_DOC_ID The first document ID in which this word appears in the FULLTEXT index. LAST_DOC_ID The last document ID in which this word appears in the FULLTEXT index. DOC_COUNT The number of rows in which this word appears in the FULLTEXT index.
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-index-table-table.html
The INNODB_FT_INDEX_TABLE table provides information about the inverted index used to process text searches against the FULLTEXT index of an InnoDB table. FIRST_DOC_ID The first document ID in which this word appears in the FULLTEXT index. Before ...