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/innodb-undo-logs.html
InnoDB supports a maximum of 128 rollback segments, 32 of which are allocated to the temporary tablespace. Note It is possible to encounter a concurrent transaction limit error before reaching the number of concurrent read-write transactions that ...
https://dev.mysql.com/doc/refman/5.7/en/create-trigger.html
CREATE [DEFINER = user] TRIGGER trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW [trigger_order] trigger_body trigger_time: { BEFORE | AFTER } trigger_event: { INSERT | UPDATE | DELETE } trigger_order: { FOLLOWS | PRECEDES } ...A ...
https://dev.mysql.com/doc/refman/5.7/en/can-not-connect-to-server.html
If you get the error message Can't connect to MySQL server on some_host, you can try the following things to find out what the problem is: Check whether the server is running on that host by executing telnet some_host 3306 and pressing the Enter key ...After any port is closed it remains in TIME_WAIT status for 120 ...The error (2003) Can't connect to MySQL server on ... A MySQL client on Unix can connect to the mysqld server in two different ways: By using a Unix socket file to ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-analyze-table-complexity.html
Using these parameters, an approximate formula for estimating ANALYZE TABLE complexity would be: The value of innodb_stats_persistent_sample_pages * number of indexed columns in a table * the number of partitions Typically, the greater the resulting ... ANALYZE TABLE complexity for InnoDB tables is dependent on: The number of pages sampled, as defined by ...
https://dev.mysql.com/doc/refman/5.7/en/sys-io-global-by-wait-by-latency.html
max_latency The maximum single wait time of timed occurrences of the I/O event. These views summarize global I/O consumers to display amount of I/O and time waiting for I/O, grouped by event. total_latency The total wait time of timed occurrences ...The io_global_by_wait_by_latency and x$io_global_by_wait_by_latency views have these columns: event_name The I/O event name, with the wait/io/file/ prefix ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-multi-versioning.html
This removal operation is called a purge, and it is quite fast, usually taking the same order of time as the SQL statement that did the deletion. Multi-Versioning and Secondary Indexes InnoDB multiversion concurrency control (MVCC) treats secondary ...It keeps information about old versions of changed rows to support transactional features such as concurrency and ...
https://dev.mysql.com/doc/refman/5.7/en/using-system-variables.html
To restrict the maximum value to which a system variable can be set at runtime with the SET statement, specify this maximum by using an option of the form --maximum-var_name=value at server startup. For example, to prevent the value of ...The ...
https://dev.mysql.com/doc/refman/5.7/en/events-overview.html
When you create an event, you are creating a named database object containing one or more SQL statements to be executed at one or more regular intervals, beginning and ending at a specific date and time. Whereas a trigger is a database object whose ...Scheduled tasks of this type are also sometimes known as “temporal triggers”, implying that these are objects that are triggered by the passage of ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-group-stats-table.html
This number is incremented when a statement starts executing, not when it finishes. QUERIES_QUEUED The number of statements received that were queued for execution. This does not count statements that the thread group was able to begin executing ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-object-filtering.html
The ENABLED column indicates whether matching objects are monitored, and TIMED indicates whether to collect timing information. Setting the TIMED column affects Performance Schema table contents as described in Section 25.4.1, “Performance Schema ... The setup_objects table controls whether the Performance Schema monitors particular table and stored program ...