PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/explain.html
(See Section 15.2.13, “SELECT Statement”.) The optimizer trace may sometimes provide information complementary to that of EXPLAIN. (When there are multiple loops, this figure shows the average time per loop.) Number of rows returned by the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-recovery.html
To achieve point-in-time recovery after restoring a backup, you can apply changes from the binary log that occurred after the backup was made. After restoring the base backup, do a point-in-time recovery from the binary log files using mysqlbinlog ...Recovery from Data Corruption or Disk Failure If your database becomes corrupted or disk failure occurs, you must perform the recovery using a ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-top.html
With color support enabled, the graph display shows OS user time in blue, OS system time in green, and idle time as blank. For measured load, blue is used for execution time, yellow for send time, red for time spent in send buffer full waits, and ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-waits-current-table.html
The TIMER_START and TIMER_END values indicate when event timing started and ended. If an event has not finished, TIMER_END is the current timer value and TIMER_WAIT is the time elapsed so far (TIMER_END − TIMER_START). If an event is produced from ...The table stores one row per thread showing the current status of the thread's most recent monitored wait event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/8.0/en/server-options.html
However, in most cases it is desirable to make sure that the server uses the same options each time it runs. These can be displayed at runtime using the SHOW VARIABLES statement. To restrict the maximum value to which a system variable can be set at ... When you start the mysqld server, you can specify program options using any of the methods described in Section 6.2.2, “Specifying Program ...
https://dev.mysql.com/doc/refman/8.0/en/show-events.html
row *************************** Db: myschema Name: e_daily Definer: jon@ghidora Time zone: SYSTEM Type: RECURRING Execute at: NULL Interval value: 1 Interval field: DAY Starts: 2018-08-08 11:06:34 Ends: NULL Status: ENABLED Originator: 1 ... SHOW ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-table-statistics.html
By default, rows are sorted by descending total wait time (tables with most contention first). total_latency The total wait time of timed I/O events for the table. fetch_latency The total wait time of timed read I/O events for the table. The ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-logging-configuration.html
pwd_id format is pwd_timestamp-seq, where: pwd_timestamp is a UTC value in YYYYMMDDThhmmss format indicating when the password was created. Sequence numbers start at 1 and increase for passwords that have the same pwd_timestamp value. For the ...
https://dev.mysql.com/doc/refman/8.0/en/events-metadata.html
Event Scheduler Time Representation Each session in MySQL has a session time zone (STZ). This is the session time_zone value that is initialized from the server's global time_zone value when the session begins but may be changed during the session.
https://dev.mysql.com/doc/refman/8.0/en/innodb-auto-increment-handling.html
InnoDB assigns new values for the AUTO_INCREMENT column one at a time as each row is processed. Tx2: INSERT INTO t1 (c2) VALUES ('xxx'); InnoDB cannot tell in advance how many rows are retrieved from the SELECT in the INSERT statement in Tx1, and it ... InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL statements that add rows to tables with AUTO_INCREMENT ...