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-statement-digests.html
The MySQL server is capable of maintaining statement digest information. The digesting process converts each SQL statement to normalized form (the statement digest) and computes a SHA-256 hash value (the digest hash value) from the normalized ...
https://dev.mysql.com/doc/refman/9.7/en/replication-options-replica.html
This section explains the server options and system variables that apply to replica servers and contains the following: Startup Options for Replica Servers System Variables Used on Replica Servers Specify the options either on the command line or ...
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/stop-group-replication.html
This statement requires the GROUP_REPLICATION_ADMIN privilege (or the deprecated SUPER privilege). As soon as you issue STOP GROUP_REPLICATION the member is set to super_read_only=ON, which ensures that no writes can be made to the member while ...
https://dev.mysql.com/doc/refman/9.7/en/sys-format-time.html
Note format_time() is deprecated, and subject to removal in a future MySQL version. Applications that use it should be migrated to use the built-in FORMAT_PICO_TIME() function instead. See Section 14.22, “Performance Schema Functions” Given a ...
https://dev.mysql.com/doc/refman/9.7/en/windows-restrictions.html
The following restrictions apply to use of MySQL on the Windows platform: Process memory On Windows 32-bit platforms, it is not possible by default to use more than 2GB of RAM within a single process, including MySQL. This is because the physical ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-events-table.html
The EVENTS table provides information about Event Manager events, which are discussed in Section 27.5, “Using the Event Scheduler”. The EVENTS table has these columns: EVENT_CATALOG The name of the catalog to which the event belongs.
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-logging-configuration.html
This section describes how to configure audit logging characteristics, such as the file to which the audit log component writes events, the format of written events, whether to enable log file compression and encryption, and space management. The ...
https://dev.mysql.com/doc/refman/9.7/en/controlling-query-plan-evaluation.html
The task of the query optimizer is to find an optimal plan for executing an SQL query. Because the difference in performance between “good” and “bad” plans can be orders of magnitude (that is, seconds versus hours or even days), most query ...
https://dev.mysql.com/doc/refman/9.7/en/events-privileges.html
To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system variable. The EVENT privilege governs the creation, modification, and deletion of events. For example, suppose that ...