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/audit-log-restrictions.html
MySQL Enterprise Audit is subject to these general restrictions: Only SQL statements are logged. Changes made by no-SQL APIs, such as memcached, Node.JS, and the NDB API, are not logged. Only top-level statements are logged, not statements within ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-security.html
This can be changed by setting the audit_log_file system variable at server startup. By default, contents of audit log files produced by the audit log plugin are not encrypted and may contain sensitive information, such as the text of SQL ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log.html
To identify the relevant instruments, use this query: SELECT NAME FROM performance_schema.setup_instruments WHERE NAME LIKE '%/alog/%'; . Note MySQL Enterprise Audit is an extension included in MySQL Enterprise Edition, a commercial product. MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/backup-strategy-summary.html
If you have such safe media, this technique can also be good for disk load balancing (which results in a performance improvement). In case of an operating system crash or power failure, InnoDB itself does all the job of recovering data. But to make ...
https://dev.mysql.com/doc/refman/5.7/en/bit-value-literals.html
A leading 0b is case-sensitive and cannot be written as 0B. In numeric contexts, MySQL treats a bit literal like an integer. To ensure numeric treatment of a bit literal, use it in numeric context. For example, a bit literal assigned to a ...
https://dev.mysql.com/doc/refman/5.7/en/calculating-days.html
The following example shows how you can use the bit group functions to calculate the number of days per month a user has visited a Web page. CREATE TABLE t1 (year YEAR, month INT UNSIGNED, day INT UNSIGNED); INSERT INTO t1 ...
https://dev.mysql.com/doc/refman/5.7/en/cannot-create.html
If you get an error of the following type for some queries, it means that MySQL cannot create a temporary file for the result set in the temporary directory: Can't create/write to file '\\sqla3fe_0.ism'. The preceding error is a typical message for ...
https://dev.mysql.com/doc/refman/5.7/en/charset-charsets.html
There is one subsection for each group of related character sets. To list the available character sets and their default collations, use the SHOW CHARACTER SET statement or query the INFORMATION_SCHEMA CHARACTER_SETS table. To avoid choosing the ...
https://dev.mysql.com/doc/refman/5.7/en/charset-errors.html
This section describes how the MySQL server uses character sets for constructing error messages. For information about the language of error messages (rather than the character set), see Section 10.12, “Setting the Error Message Language”. For ...
https://dev.mysql.com/doc/refman/5.7/en/charset-introducer.html
A character string literal, hexadecimal literal, or bit-value literal may have an optional character set introducer and COLLATE clause, to designate it as a string that uses a particular character set and collation: [_charset_name] literal [COLLATE ...