Rechercher dans le manuel MySQL
Search Results
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.
https://dev.mysql.com/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/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/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 will consume 10 times the memory indicated ... The MySQL server is capable of maintaining statement digest ...
https://dev.mysql.com/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/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/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 ...
https://dev.mysql.com/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/faqs-replication.html
Must the slave be connected to the master all the time? A.13.2. Must the slave be connected to the master all the time? No, it does not. For example, you can set up a master/slave relationship over a dial-up link where the link is up only ... In the ...
https://dev.mysql.com/mysqlslap.html
Run all the load statements, then run all the queries in the query file with five clients (five times each): mysqlslap --concurrency=5 --iterations=5 --query=query.sql --create=create.sql --delimiter=";" mysqlslap supports the following options, ...
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-7.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.
