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/innodb-memcached-txn.html
The numeric values specified for this option correspond to isolation levels such as REPEATABLE READ. This option is less appropriate when accessing the same tables through both memcached and SQL, because it blocks CREATE INDEX statements on the ...
https://dev.mysql.com/doc/refman/5.7/en/selinux-troubleshooting.html
This issue can occur if MySQL is configured to read from or write to a non-default directory or file. In this case, a “denial” message is logged to /var/log/audit/audit.log: $> grep "denied" /var/log/audit/audit.log type=AVC ... Troubleshooting ...
https://dev.mysql.com/doc/refman/5.7/en/set.html
A consequence of this is that SET member values should not themselves contain commas. For more information on this limit, see Limits Imposed by .frm File Structure. For example, you can retrieve numeric values from a SET column like this: mysql> ...
https://dev.mysql.com/doc/refman/5.7/en/assignment-operators.html
The value on the right hand side may be a literal value, another variable storing a value, or any legal expression that yields a scalar value, including the result of a query (provided that this value is a scalar value). This means you can use := in ... Table 12.6 Assignment Operators Name Description := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an UPDATE statement) := Assignment ...
https://dev.mysql.com/doc/refman/5.7/en/batch-mode.html
In the previous sections, you used mysql interactively to enter statements and view the results. If you want the script to continue even if some of the statements in it produce errors, you should use the --force command-line option. Why use a ...
https://dev.mysql.com/doc/refman/5.7/en/condition-filtering.html
In this case, the optimizer uses heuristics to estimate a filtering effect of 16.31% for the BETWEEN condition on employee.hire_date. This flag is enabled by default but can be disabled to suppress condition filtering (for example, if a particular ... In join processing, prefix rows are those rows passed from one table in a join to the ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-secondary-indexes.html
This technique also can be used to provide indexes that indirectly reference columns of other types that cannot be indexed directly, such as GEOMETRY columns. This means that any NDB table having one or more JSON columns must have a primary key, ...
https://dev.mysql.com/doc/refman/5.7/en/derived-tables.html
This does not work: SELECT AVG(SUM(column1)) FROM t1 GROUP BY column1; However, this query provides the desired information: SELECT AVG(sum_column1) FROM (SELECT SUM(column1) AS sum_column1 FROM t1 GROUP BY column1) AS t1; Notice that the column ...
https://dev.mysql.com/doc/refman/5.7/en/document-store.html
This chapter introduces an alternative way of working with MySQL as a document store, sometimes referred to as “using NoSQL”. If your intention is to use MySQL in a traditional (SQL) way, this chapter is probably not relevant to you. This ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-usage.html
Use the private key to encrypt data and the public key to decrypt it This requires that the members of the key pair be RSA keys. For some installations, this might result in unacceptable CPU usage if applications frequently generate excessively long ... To use MySQL Enterprise Encryption in applications, invoke the functions that are appropriate for the operations you wish to ...