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/signal.html
This warning does not terminate the procedure, so execution continues and p() then signals an error. The following statements cause that error because the named condition is associated with a MySQL error number: DECLARE no_such_table CONDITION FOR ...SIGNAL provides error information to a handler, to an outer portion of the application, or to the ...To retrieve information from the ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-reference.html
Timeout values are nonnegative integers representing the time in seconds to wait to acquire locks before timing out with an error. mysql> SELECT version_tokens_lock_exclusive('lock1', 'lock2', 10); ...(It is not an error to delete nonexisting ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statement-analysis.html
max_latency The maximum single wait time of timed occurrences of the statement. err_count The total number of errors produced by occurrences of the statement. total_latency The total wait time of timed occurrences of the statement. avg_latency The ...The statement_analysis and x$statement_analysis views have these columns: query The normalized statement ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-innodb-mutex-waits-performance-schema.html
MAX_TIMER_WAIT The maximum wait time of the summarized timed wait events. Because waits are timed in picoseconds (trillionths of a second) by default, wait times are divided by 1000000000 to show wait times in milliseconds. A mutex is a ...The ...
https://dev.mysql.com/doc/refman/5.7/en/replication-threads-monitor-worker.html
The message lists the following statistics for the relevant replication channel, or the default replication channel (which is not named): Seconds elapsed The difference in seconds between the current time and the last time this information was ...A ... On a multithreaded replica, the Performance Schema tables replication_applier_status_by_coordinator and replication_applier_status_by_worker show status information for the replica's coordinator thread and applier worker threads ...
https://dev.mysql.com/doc/refman/5.7/en/entering-queries.html
(Do you see the error in the statement? The string 'Smith is missing the second single quotation mark.) At this point, what do you do? The simplest thing is to cancel the query. We'll get to others later.) When you issue a query, mysql sends it to ... Make sure that you are connected to the server, as discussed in the previous ...
https://dev.mysql.com/doc/refman/5.7/en/handler-scope.html
A specific handler is for a MySQL error code, SQLSTATE value, or condition name. For example, there might be a specific MySQL error code handler in an outer block, and a general SQLWARNING handler in an inner block. Or there might be handlers for a ... A stored program may include handlers to be invoked when certain conditions occur within the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-logs-event-buffer.html
BUFFERED_EPOCHS_OVER_THRESHOLD: Whether the number of buffered epochs has exceeded the configured threshold. The report is generated every second until the number of buffered epochs goes below the threshold, which can be adjusted by setting the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-select-count.html
--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving up. --connect-retry-delay Command-Line Format --connect-retry-delay=# Type ...
https://dev.mysql.com/doc/refman/5.7/en/enum.html
An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation time. The index value of the empty string error value is 0. Value Index NULL NULL '' 0 ...