PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/sys-schema-table-statistics-with-buffer.html
By default, rows are sorted by descending total wait time (tables with most contention first). fetch_latency The total wait time of timed read I/O events for the table. insert_latency The total wait time of timed insert I/O events for the table.
https://dev.mysql.com/doc/refman/9.7/en/sys-statement-analysis.html
total_latency The total wait time of timed occurrences of the statement. max_latency The maximum single wait time of timed occurrences of the statement. avg_latency The average wait time per timed occurrence of the statement. lock_latency The total ...The statement_analysis and x$statement_analysis views have these columns: query The normalized statement ...
https://dev.mysql.com/doc/refman/9.7/en/backup-types.html
These provide logical copies of the file system at a given point in time, without requiring a physical copy of the entire file system. (For example, the implementation may use copy-on-write techniques so that only parts of the file system modified ... This section describes the characteristics of different types of ...
https://dev.mysql.com/doc/refman/9.7/en/information-functions.html
It may be used to time how quickly MySQL processes the expression. The intended use is from within the mysql client, which reports query execution times: mysql> SELECT BENCHMARK(1000000,AES_ENCRYPT('hello','goodbye')); ...The result value is 0, or ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-error-log-table.html
LOGGED corresponds to the time field of error events, although with certain potential differences: time values in the error log are displayed according to the log_timestamps system variable setting; see Early-Startup Logging Output Format. The ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-events-statements-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 statement event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-statement-digests.html
For example, table columns that show wait times, lock times, or index use may highlight types of queries that are inefficient. A typical number of statements in this table is 10 per session, so each session consumes 10 times the memory indicated by ... The MySQL server is capable of maintaining statement digest ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-wait-summary-tables.html
row *************************** EVENT_NAME: wait/synch/mutex/sql/BINARY_LOG::LOCK_index COUNT_STAR: 8 SUM_TIMER_WAIT: 2119302 MIN_TIMER_WAIT: 196092 AVG_TIMER_WAIT: 264912 MAX_TIMER_WAIT: 569421 ... row *************************** EVENT_NAME: ...
https://dev.mysql.com/doc/refman/9.7/en/storage-requirements.html
InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage ...
https://dev.mysql.com/doc/refman/9.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. Scheduled tasks of this type are also ...