Search Results
https://dev.mysql.com/doc/refman/8.4/en/mathematical-functions.html
An implication of this is that ABS(-9223372036854775808) produces an error because the result cannot be stored in a signed BIGINT value. The minimum base is 2 and the maximum base is 36. mysql> SELECT COT(12); -> -1.5726734063977 mysql> SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/string-functions.html
mysql> SELECT CONCAT_WS(',', 'First name', 'Second name', 'Last Name'); -> 'First name,Second name,Last Name' mysql> SELECT CONCAT_WS(',', 'First name', NULL, 'Last Name'); -> 'First name,Last Name' CONCAT_WS() does not skip empty strings. If the ...
https://dev.mysql.com/doc/workbench/en/wb-preferences-ssh.html
Figure 3.17 Preferences: SSH Timeouts SSH Connect Timeout: [10] SSH connect timeout interval in seconds. SSH Read Write Timeout: [5] SSH read and write timeout interval in seconds. SSH Command Execution log: [104857600] The maximum file size that is ... The following figure shows the preference options that apply to SSH items, such as ...Use the following options ...
https://dev.mysql.com/doc/internals/en/authentication-method.html
For earlier servers it is always Secure Password Authentication or Old Password Authentication depending on the CLIENT_SECURE_CONNECTION flag. Client and server negotiate what types of authentication they support as part of the connection phase.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-config-send-buffers.html
This is a way to save memory when many nodes are in use, as long as the maximum amount of memory is never required by all transporters at the same time. To be backward-compatible with existing configurations, this parameter takes as its default ...
https://dev.mysql.com/doc/refman/8.4/en/full-disk.html
This section describes how MySQL responds to disk-full errors (such as “no space left on device”), and to quota-exceeded errors (such as “write failed” or “user block limit reached”). The thread is aborted the next time it checks the ...
Oracle Enterprise Manager for MySQL Database User's Guide :: 7.18 Localization Configuration Metrics
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-localization-category.html
Time Format The format to use for times, this variable is currently unused. Time Names This variable specifies the locale that controls the language used to display day and month names and abbreviations. Lists the Localization configuration metrics ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-cpudata.html
The cpudata table provides data about CPU usage during the last second.
https://dev.mysql.com/doc/refman/8.4/en/replica-sql-thread-states.html
Waiting until SOURCE_DELAY seconds after source executed event The SQL thread has read an event but is waiting for the replica delay to lapse. Making temporary file (append) before replaying LOAD DATA INFILE The thread is executing a LOAD DATA ...
https://dev.mysql.com/doc/refman/8.4/en/webauthn-pluggable-authentication.html
With this plugin-loading method, the option must be given each time the server starts. For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME = 'authentication_webauthn'; ... Note WebAuthn ...