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/audit-log-legacy-filtering.html
Legacy Event Filtering by Account Legacy Event Filtering by Status Legacy Event Filtering by Account To filter audited events based on the originating account, set one (not both) of the following system variables at server startup or runtime. Note ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary.html
statement_latency The total wait time of timed statements for the host. statement_avg_latency The average wait time per timed statement for the host. file_io_latency The total wait time of timed file I/O events for the host. These views summarize ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary.html
statement_latency The total wait time of timed statements for the user. statement_avg_latency The average wait time per timed statement for the user. file_io_latency The total wait time of timed file I/O events for the user. These views summarize ...
https://dev.mysql.com/doc/refman/5.7/en/problems-with-null.html
For example, the following statements are completely different: mysql> INSERT INTO my_table (phone) VALUES (NULL); mysql> INSERT INTO my_table (phone) VALUES (''); Both statements insert a value into the phone column, but the first inserts a NULL ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-query-profiling.html
Performance Schema displays event timer information in picoseconds (trillionths of a second) to normalize timing data to a standard unit. In the following example, TIMER_WAIT values are divided by 1000000000000 to show data in units of seconds. The ... The following example demonstrates how to use Performance Schema statement events and stage events to retrieve data comparable to profiling information provided by SHOW PROFILES and SHOW PROFILE ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking.html
Example 2: A credit card processor company provides a set of services using sensitive data, such as: Processing a large number of financial transactions per second. Note MySQL Enterprise Data Masking and De-Identification is an extension included ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-logging.html
The mysql client can do these types of logging for statements executed interactively: On Unix, mysql writes the statements to a history file. How Logging Occurs Controlling the History File syslog Logging Characteristics How Logging Occurs For each ...By default, this file is named .mysql_history in your home ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-performance-timers-table.html
The rows that do not contain NULL indicate which timers you can use in setup_timers. Note As of MySQL 5.7.21, the Performance Schema setup_timers table is deprecated and is removed in MySQL 8.0, as is the TICKS row in the performance_timers table.
https://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html
For nontransactional tables, an error occurs, but if this happens for the second or subsequent row of a multiple-row statement, any rows preceding the error have already been inserted. The exception is that, for TIMESTAMP and DATETIME columns, you ... Data type specifications can have explicit or implicit default ...
https://dev.mysql.com/doc/refman/5.7/en/charset-cp932.html
Why is cp932 needed? In MySQL, the sjis character set corresponds to the Shift_JIS character set defined by IANA, which supports JIS X0201 and JIS X0208 characters. (See http://www.iana.org/assignments/character-sets.) However, the meaning of ...