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/show-variables.html
These are the values used to initialize the corresponding session variables for new connections to MySQL. With a SESSION modifier, the statement displays the system variable values that are in effect for the current connection. SHOW [GLOBAL | ...
https://dev.mysql.com/doc/refman/9.7/en/string-functions-charset.html
For operations that convert to character data, the character set and collation of the strings that result from the operations are defined by the character_set_connection and collation_connection system variables that determine the default connection ... MySQL has many operators and functions that return a ...
https://dev.mysql.com/doc/refman/9.7/en/system-variable-privileges.html
In addition, you must connect to the server using an encrypted connection and supply an SSL certificate with the Subject value specified by the persist_only_admin_x509_subject system variable. For persist-restricted variables, RESET PERSIST does not ...(For information about dynamic variables, see Section 7.1.9.2, “Dynamic System Variables”.) For certain global system variables, SET can be used to persist their value to the mysqld-auto.cnf file in the data directory, to affect server operation for subsequent ...
https://dev.mysql.com/doc/refman/9.7/en/thread-pool-tuning.html
You may need to adjust the value from this starting point to suit a given workload; a reasonable upper bound for this value is the maximum number of concurrent connections expected; the value of the Max_used_connections status variable can serve as ... This section provides guidelines on determining the best configuration for thread pool performance, as measured using a metric such as transactions per ...
https://dev.mysql.com/doc/refman/9.7/en/time-zone-support.html
Each client that connects has its own session time zone setting, given by the session time_zone variable. For example: mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql The mysql command shown here assumes that you connect to the ...
https://dev.mysql.com/doc/refman/9.7/en/type-conversion.html
Implicit conversion of a numeric or temporal value to string produces a value that has a character set and collation determined by the character_set_connection and collation_connection system variables. For information about connection character ...
https://dev.mysql.com/doc/refman/9.7/en/using-explain.html
When EXPLAIN is used with FOR CONNECTION connection_id rather than an explainable statement, it displays the execution plan for the statement executing in the named connection. See Section 10.8.4, “Obtaining Execution Plan Information for a Named ... The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE ...
https://dev.mysql.com/doc/refman/9.7/en/windows-restrictions.html
Limited number of ports Windows systems have about 4,000 ports available for client connections, and after a connection on a port closes, it takes two to four minutes before the port can be reused. In situations where clients connect to and ... The ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-disabling.html
The audit_log.disable variable permits disabling audit logging for all connecting and connected sessions. The audit_log.disable variable can be set in a MySQL Server option file, in a command-line startup string, or at runtime using a SET ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-disabling.html
The audit_log_disable variable permits disabling audit logging for all connecting and connected sessions. Important The audit_log plugin is deprecated, and is being replaced by the audit_log component. Deprecation of the plugin means that you ...