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/out-of-range-and-overflow.html
When an out-of-range value is assigned to an integer column, MySQL stores the value representing the corresponding endpoint of the column data type range. When a floating-point or fixed-point column is assigned a value that exceeds the range implied ...If no restrictive modes are enabled, MySQL clips the value to the appropriate endpoint of the column data type range and stores the resulting value ...
https://dev.mysql.com/doc/refman/9.7/en/pam-pluggable-authentication.html
Unquoted pam_service_name, pam_group_name, and mysql_user_name values can contain anything except equal sign, comma, or space. Assign /etc/group to the shadow group and enable the group read permission: chgrp shadow /etc/shadow chmod g+r /etc/shadow ... Note PAM pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/9.7/en/using-log-files.html
It is not a good sign if mysqld did die unexpectedly, but in this case, you should not investigate the Checking table... Note that before starting mysqld with the general query log enabled, you should check all your tables with myisamchk. If mysqld ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-pruning.html
In many cases, the equal sign can be replaced with another arithmetic comparison, including <, >, <=, >=, and <>. The optimization known as partition pruning is based on a relatively simple concept which can be described as “Do not scan ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-error-log-table.html
row *************************** LOGGED: 2020-08-06 09:25:02.936146 THREAD_ID: 0 PRIO: Warning ERROR_CODE: MY-010068 SUBSYSTEM: Server DATA: CA certificate /var/mysql/sslinfo/cacert.pem is self signed. Many Performance Schema tables other than ... Of ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-status-monitoring.html
INSTALL PLUGIN plugin_a; The server detects that the 40 instruments are already defined, so no new instruments are created, and previously assigned internal memory buffers are reused. The Performance_schema_mutex_classes_lost status variable is the ...Names for these variables have several forms: Performance_schema_xxx_classes_lost indicates how many instruments of type xxx could not be ...
https://dev.mysql.com/doc/refman/9.7/en/prepare.html
PREPARE stmt_name FROM preparable_stmt The PREPARE statement prepares a SQL statement and assigns it a name, stmt_name, by which to refer to the statement later. (In this case, an implicit CAST(? AS derived_type) is performed.) The derived type and ...The prepared statement is executed with EXECUTE and released with DEALLOCATE ...
https://dev.mysql.com/doc/refman/9.7/en/replication-encrypted-connections.html
To use an encrypted connection for the transfer of the binary log required during replication, both the source and the replica servers must support encrypted network connections. If either server does not support encrypted connections (because it ...
https://dev.mysql.com/doc/refman/9.7/en/tuning-trace-purging.html
This is done by setting the optimizer_trace_offset and optimizer_trace_limit system variables, like this: SET optimizer_trace_offset=offset, optimizer_trace_limit=limit; offset is a signed integer (default -1); limit is a positive integer (default ...Thus, if a statement contains substatements (such as invoking stored procedures, stored functions, or triggers), the topmost statement and substatements each generate one trace, but at the end of execution, the trace for only the last substatement is ...
https://dev.mysql.com/doc/refman/9.7/en/sys-schema-auto-increment-columns.html
For example, for a column with a bigint(20) unsigned column type, the data type is just bigint. This view indicates which tables have AUTO_INCREMENT columns and provides information about those columns, such as the current and maximum column values ...