PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/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/5.7/en/innodb-statistics-estimation.html
Values much larger than 8 (say, 100), can cause a significant slowdown in the time it takes to open a table or execute SHOW TABLE STATUS. Because the statistics are automatically recalculated at various times other than on execution of ANALYZE ...
https://dev.mysql.com/doc/refman/5.7/en/creating-ssl-rsa-files-using-mysql.html
They can be enabled at startup and inspected but not set at runtime. For files generated by the server, if the resulting CN values exceed 64 characters, the _suffix portion of the name is omitted. SSL files created by the server or by ...For some ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-index-cache-table.html
The same word can occur several times within the cache table, once for each combination of DOC_ID and POSITION values. The INNODB_FT_INDEX_CACHE table provides token information about newly inserted rows in a FULLTEXT index. Before querying it, set ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens.html
An SQL statement sent by the application to a server not in the required state produces an error. MySQL includes Version Tokens, a feature that enables creation of and synchronization around server tokens that applications can use to prevent ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/en/tutorial.html
mysql (sometimes referred to as the “terminal monitor” or just “monitor”) is an interactive program that enables you to connect to a MySQL server, run queries, and view the results. mysql may also be used in batch mode: you place your ...
https://dev.mysql.com/doc/refman/5.7/en/select.html
With two arguments, the first argument specifies the offset of the first row to return, and the second specifies the maximum number of rows to return. Use of an unqualified * with other items in the select list may produce a parse error. The ...
https://dev.mysql.com/doc/refman/5.7/en/selinux-troubleshooting.html
$> systemctl start mysql.service Job for mysqld.service failed because the control process exited with error code. If you configure the MySQL Server to use a non-default port, such as port 3307, and do not update the policy to reflect the change, ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-deploying-in-multi-primary-or-single-primary-mode.html
The following checks are made when Group Replication is deployed in multi-primary mode: If a transaction is executed under the SERIALIZABLE isolation level, then its commit fails when synchronizing itself with the group. If a transaction executes ...