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/cost-model.html
To generate execution plans, the optimizer uses a cost model that is based on estimates of the cost of various operations that occur during query execution. The optimizer has a set of compiled-in default “cost constants” available to it to make ...
https://dev.mysql.com/doc/refman/5.7/en/create-table.html
| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ... | [CONSTRAINT [symbol]] UNIQUE [INDEX | KEY] [index_name] [index_type] (key_part,...) [index_option] ... (Some valid select or union statement) CREATE TABLE creates ...
https://dev.mysql.com/doc/refman/5.7/en/encryption-functions.html
Caution Passwords or other sensitive values supplied as arguments to encryption functions are sent as cleartext to the MySQL server unless an SSL connection is used. To avoid these types of exposure, applications can encrypt sensitive values on the ...If you want to store these results, use a column with a VARBINARY or BLOB binary string data ...
https://dev.mysql.com/doc/refman/5.7/en/flow-control-functions.html
If expr2 and expr3 are both strings, the result is case-sensitive if either string is case-sensitive. The second syntax returns the result for the first condition that is true. If no comparison or condition is true, the result after ELSE is ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-natural-language.html
| +----+-------------------+------------------------------------------+ 2 rows in set (0.00 sec) By default, the search is performed in case-insensitive fashion. To perform a case-sensitive full-text search, use a binary collation for the indexed ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-stopwords.html
For example, lookups are case-insensitive if the collation is latin1_swedish_ci, whereas lookups are case-sensitive if the collation is latin1_general_cs or latin1_bin. The stopword list is loaded and searched for full-text queries using the server ...
https://dev.mysql.com/doc/refman/5.7/en/grant-tables.html
For access-checking purposes, comparisons of User, Proxied_user, Password, authentication_string, Db, and Table_name values are case-sensitive. Comparisons of Host, Proxied_host, Column_name, and Routine_name values are not case-sensitive. The ...
https://dev.mysql.com/doc/refman/5.7/en/identifiers.html
Section 9.2.3, “Identifier Case Sensitivity”, describes which types of identifiers are case-sensitive and under what conditions. Certain objects within MySQL, including database, table, index, column, alias, view, stored procedure, partition, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-security.html
Caution Consult this section before deploying the daemon_memcached plugin on a production server, or even on a test server if the MySQL instance contains sensitive data. Because memcached does not use an authentication mechanism by default, and the ...Do not allow memcached access to these servers from the Internet; only allow access from within a firewalled intranet, ideally from a subnet whose membership you can ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-functions-general-purpose.html
MySQL Server supports a keyring service that enables internal server components and plugins to store sensitive information securely for later retrieval. As of MySQL 5.7.13, MySQL Server includes an SQL interface for keyring key management, ...