PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-is-thread-instrumented.html
Returns YES or NO to indicate whether Performance Schema instrumentation for a given connection ID is enabled, UNKNOWN if the ID is unknown, or NULL if the ID is NULL. This is a value of the type given in the PROCESSLIST_ID column of the ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-installation.html
This section describes how to install or uninstall MySQL Enterprise Data Masking and De-Identification, which is implemented as a plugin library file containing a plugin and several loadable functions. For general information about installing or ...
https://dev.mysql.com/doc/refman/5.7/en/entering-queries.html
Enter a semicolon to complete the statement, and mysql executes it: mysql> SELECT USER() -> ; +---------------+ | USER() | +---------------+ | jon@localhost | +---------------+ The '> and "> prompts occur during string collection (another way of ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlcheck.html
--debug[=debug_options], -# [debug_options] Command-Line Format --debug[=debug_options] Type String Default Value d:t:o Write a debugging log. --default-character-set=charset_name Command-Line Format --default-character-set=charset_name Type String ... The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes ...
https://dev.mysql.com/doc/refman/5.7/en/charset-binary-set.html
The binary character set is the character set for binary strings, which are sequences of bytes. For the binary character set, the concepts of lettercase and accent equivalence do not apply: For single-byte characters stored as binary strings, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-tuning.html
When to Use Compression In general, compression works best on tables that include a reasonable number of character string columns and where the data is read far more often than it is written. Recall that compression works by identifying repeated ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-tips.html
Suppose that an indexed string column c1 is compared to a numeric value using WHERE c1 = 2222. For such comparisons, the string value is converted to a number and the operands are compared numerically (see Section 12.3, “Type Conversion in ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-commands.html
If you provide an argument to the help command, mysql uses it as a search string to access server-side help from the contents of the MySQL Reference Manual. delimiter str, \d str Change the string that mysql interprets as the separator between SQL ... mysql sends each SQL statement that you issue to the server to be ...
https://dev.mysql.com/doc/refman/5.7/en/windows-pluggable-authentication.html
Authentication string syntax for the Windows authentication plugin follows these rules: The string consists of one or more user mappings separated by commas. Thus, these statements are equivalent: CREATE USER sql_admin IDENTIFIED WITH ... Note ...
https://dev.mysql.com/doc/refman/5.7/en/index-btree-hash.html
The index also can be used for LIKE comparisons if the argument to LIKE is a constant string that does not start with a wildcard character. LIKE '%string%' and string is longer than three characters, MySQL uses the Turbo Boyer-Moore algorithm to ...