Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/sys-io-global-by-wait-by-latency.html
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 of the I/O event. avg_latency The average wait time per timed occurrence of the ...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/innodb-recovery.html
Topics include: Point-in-Time Recovery Recovery from Data Corruption or Disk Failure InnoDB Crash Recovery Tablespace Discovery During Crash Recovery To recover an InnoDB database to the present from the time at which the physical backup was made, ...If your database becomes corrupted or disk failure occurs, you must perform the recovery using a ...
https://dev.mysql.com/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/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 ...
https://dev.mysql.com/slow-query-log.html
The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least min_examined_row_limit rows to be examined. The slow query log can be used to find queries that take a long time to execute ...
https://dev.mysql.com/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 26.4.1, “Performance Schema ... The setup_objects table controls whether the Performance Schema monitors particular table and stored program ...
https://dev.mysql.com/mysqldumpslow.html
The MySQL slow query log contains information about queries that take a long time to execute (see Section 5.4.5, “The Slow Query Log”). mysqldumpslow parses MySQL slow query log files and summarizes their contents. Normally, mysqldumpslow ...
https://dev.mysql.com/replication-options-binary-log.html
To specify more than one database, use this option multiple times, once for each database; however, doing so does not cause cross-database statements such as UPDATE some_db.some_table SET foo='bar' to be logged while a different database (or no ...
https://dev.mysql.com/performance-schema-quick-start.html
The number of Performance Schema tables increases over time as implementation of additional instrumentation proceeds. row *************************** THREAD_ID: 0 EVENT_ID: 5523 END_EVENT_ID: 5523 EVENT_NAME: wait/synch/mutex/mysys/THR_LOCK::mutex ... This section briefly introduces the Performance Schema with examples that show how to use ...
https://dev.mysql.com/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.
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-fct-time-p-6.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.
