PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-threads-table.html
PROCESSLIST_TIME The time in seconds that the thread has been in its current state. For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the replica host. If a thread ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/program-variables.html
For example, the first of the following lines is legal at program invocation time, but the second is not: $> mysql --max_allowed_packet=16M $> mysql --max_allowed_packet=16*1024*1024 Conversely, the second of the following lines is legal at runtime, ... Many MySQL programs have internal variables that can be set at runtime using the SET ...
https://dev.mysql.com/doc/refman/8.0/en/regexp.html
A - character between two other characters forms a range that matches all characters from the first character to the second. Each of the two statements in the following example starts from the second 2-byte position in the first argument. The second ...This section discusses the functions and operators available for regular expression matching and illustrates, with examples, some of the special characters and constructs that can be used for regular expression ...
https://dev.mysql.com/doc/refman/8.0/en/replica-logs-status.html
A replica server creates two replication metadata repositories, the connection metadata repository and the applier metadata repository. If binary log file position based replication is in use, when the replica restarts, it reads the two ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-safe-unsafe.html
Whenever the 50 most recent ER_BINLOG_UNSAFE_STATEMENT warnings have been generated more than 50 times in any 50-second period, warning suppression is enabled. When activated, this causes such warnings not to be written to the error log; instead, ...
https://dev.mysql.com/doc/refman/8.0/en/set.html
The second is similar, but not the same: It finds rows where set_col contains value anywhere, even as a substring of another set member. A SET is a string object that can have zero or more values, each of which must be chosen from a list of ...
https://dev.mysql.com/doc/refman/8.0/en/show-processlist.html
Time The time in seconds that the thread has been in its current state. For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the replica host. If a thread stays in a ...
https://dev.mysql.com/doc/refman/8.0/en/atomic-ddl.html
The change in behavior is demonstrated in this example, where the second CREATE USER statement returns an error but fails because it cannot succeed for all named users. An atomic DDL statement combines the data dictionary updates, storage engine ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-formats.html
For more complete descriptions of second-level hash items, see later in this section. Example: "query": "DELETE FROM t1" query_time The query execution time in microseconds (if the longlong data type is selected) or seconds (if the double data type ... The MySQL server calls the audit log plugin to write an audit record to its log file whenever an auditable event ...