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/mysqldumpslow.html
The MySQL slow query log contains information about queries that take a long time to execute (see Section 7.4.5, “The Slow Query Log”). mysqldumpslow parses MySQL slow query log files and summarizes their contents. Normally, mysqldumpslow ...
https://dev.mysql.com/doc/refman/9.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 29.4.1, “Performance Schema ... The setup_objects table controls whether the Performance Schema monitors particular table and stored program ...
https://dev.mysql.com/doc/refman/9.7/en/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/doc/refman/9.7/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/9.7/en/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/doc/refman/9.7/en/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/doc/refman/9.7/en/audit-log-component-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/9.7/en/group-replication-responses-failure-expel.html
You can use the group_replication_member_expel_timeout system variable to allow additional time between the creation of a suspicion and the expulsion of the suspect member. A group member is then expelled when another member's suspicion of it (or ...A suspicion is created when one server does not receive messages from another server, as explained in Section 20.1.4.2, “Failure ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/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 ...