PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-threads-table.html
The threads table contains a row for each server thread. Each row contains information about a thread and indicates whether monitoring and historical event logging are enabled for it: mysql> SELECT * FROM performance_schema.threads\G ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-transaction-tables.html
Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within transaction events. These tables store transaction events: events_transactions_current: The current transaction event for each ...
https://dev.mysql.com/doc/refman/9.7/en/replication-threads-monitor-worker.html
On a multithreaded replica, the Performance Schema tables replication_applier_status_by_coordinator and replication_applier_status_by_worker show status information for the replica's coordinator thread and applier worker threads respectively. For a ...
https://dev.mysql.com/doc/refman/9.7/en/select-optimization.html
Queries, in the form of SELECT statements, perform all the lookup operations in the database. Tuning these statements is a top priority, whether to achieve sub-second response times for dynamic web pages, or to chop hours off the time to generate ...
https://dev.mysql.com/doc/refman/9.7/en/sql-mode.html
The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system variable. DBAs can set the global SQL mode to match site server operating requirements, ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-session-info.html
For general information about stored routines in MySQL, see Section 27.2, “Using Stored Routines”. The MLE component provides a number of loadable functions for working with MLE user sessions. These functions are listed and described here: ...
https://dev.mysql.com/doc/refman/9.7/en/sys-metrics.html
This view summarizes MySQL server metrics to show variable names, values, types, and whether they are enabled. The metric type determines the source from which the name is taken: For global status variables: The VARIABLE_NAME column of the ...
https://dev.mysql.com/doc/refman/9.7/en/sys-statements-with-sorting.html
The statements_with_sorting and x$statements_with_sorting views have these columns: query The normalized statement string. db The default database for the statement, or NULL if there is none. total_latency The total wait time of timed occurrences of ...
https://dev.mysql.com/doc/refman/9.7/en/sys-statements-with-temp-tables.html
These views list normalized statements that have used temporary tables. By default, rows are sorted by descending number of on-disk temporary tables used and descending number of in-memory temporary tables used. The statements_with_temp_tables and ...
https://dev.mysql.com/doc/refman/9.7/en/thread-pool-tuning.html
This section provides guidelines on determining the best configuration for thread pool performance, as measured using a metric such as transactions per second. Of chief importance is the number of thread groups in the thread pool, which can be set ...