PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-is-consumer-enabled.html
Returns YES or NO to indicate whether a given Performance Schema consumer is enabled, or NULL if the argument is NULL. (Prior to MySQL 5.7.28, the function returns NULL if the argument is not a valid consumer name.) This function accounts for the ...If the argument is not a valid consumer name, an error ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-thread-id.html
Returns the Performance Schema thread ID assigned to a given connection ID, or the thread ID for the current connection if the connection ID is NULL. Parameters in_connection_id BIGINT UNSIGNED: The ID of the connection for which to return the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-wait-classes-global-by-avg-latency.html
These views summarize wait class average latencies, grouped by event class. An event class is determined by stripping from the event name everything after the first three components. The wait_classes_global_by_avg_latency and ...
https://dev.mysql.com/doc/refman/5.7/en/sys-wait-classes-global-by-latency.html
These views summarize wait class total latencies, grouped by event class. An event class is determined by stripping from the event name everything after the first three components. The wait_classes_global_by_latency and ...
https://dev.mysql.com/doc/refman/5.7/en/system-optimization.html
Some system-level factors can affect performance in a major way: If you have enough RAM, you could remove all swap devices. Just remember to take down the server (or lock and flush the relevant tables) before you run myisamchk. Some operating ...
https://dev.mysql.com/doc/refman/5.7/en/thread-pool.html
As more clients connect to the server and execute statements, overall performance degrades. The thread pool plugin provides an alternative thread-handling model designed to reduce overhead and improve performance. The plugin implements a thread pool ... Note MySQL Enterprise Thread Pool is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens.html
Version token lists are established per server (for example, to specify the server assignment or operational state). The following sections describe the elements of Version Tokens, discuss how to install and use it, and provide reference information ... MySQL includes Version Tokens, a feature that enables creation of and synchronization around server tokens that applications can use to prevent accessing incorrect or out-of-date ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-ndb-transid-mysql-connection-map-table.html
This information is used when populating the server_operations and server_transactions tables of the ndbinfo NDB Cluster information database. It is implemented as an INFORMATION_SCHEMA plugin; you can verify that it is supported by checking the ...
https://dev.mysql.com/doc/refman/5.7/en/rewriting-subqueries.html
Sometimes there are other ways to test membership in a set of values than by using a subquery. Today, MySQL Server and many other modern database systems offer a wide range of outer join types. MySQL Server supports multiple-table DELETE statements ...Also, on some occasions, it is not only possible to rewrite a query without a subquery, but it can be more efficient to make use of some of these techniques rather than to use ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-plugin-installation.html
Also, for general information about installing plugins, see Section 5.5.1, “Installing and Uninstalling Plugins”. keyring_encrypted_file: Stores keyring data in an encrypted, password-protected file local to the server host. keyring_okv: A KMIP ... Keyring service consumers require that a keyring plugin be ...