PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.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/9.7/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/9.7/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/9.7/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/9.7/en/replication-threads-monitor-worker.html
The statistics are printed depending on the volume of events that the coordinator thread has assigned to applier worker threads, with a maximum frequency of once every 120 seconds. The message lists the following statistics for the relevant ... On a ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/en/srjsapi-mysql.html
The following SQL built-in functions can be called directly from the mysql namespace. These are described in the following list, along with their analogous SQL functions: rand() (MySQL RAND()): Returns a random floating-point value v in the range 0 ...
https://dev.mysql.com/doc/refman/9.7/en/telemetry-metrics-meter-metrics.html
uptime Uptime ASYNC COUNTER The number of seconds that the server has been up. row_lock_time Innodb_row_lock_time ASYNC COUNTER Time spent in acquiring row locks, in milliseconds row_lock_time_avg Innodb_row_lock_time_avg ASYNC GAUGE COUNTER The ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-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 component to write an audit record to its log file whenever an auditable event ...