PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/log-destinations.html
MySQL Server provides flexible control over the destination of output written to the general query log and the slow query log, if those logs are enabled. Possible destinations for log entries are log files or the general_log and slow_log tables in ...Setting this variable does not in itself enable the logs; they must be enabled ...
https://dev.mysql.com/doc/refman/8.0/en/metadata-locking.html
MySQL uses metadata locking to manage concurrent access to database objects and to ensure data consistency. As of MySQL 8.0.13, for XA transactions in PREPARED state, metadata locks are maintained across client disconnects and server restarts, ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog-backup.html
By default, mysqlbinlog reads binary log files and displays their contents in text format. This enables you to examine events within the files more easily and to re-execute them (for example, by using the output as input to mysql). mysqlbinlog can ...This capability enables you to easily back up a binary log in its original ...
https://dev.mysql.com/doc/refman/8.0/en/out-of-memory.html
This causes it to use the mysql_use_result() C API function to retrieve the result set, which places less of a load on the client (but more on the server). Is it reasonable that it should return so many rows? If not, correct the query and try again.
https://dev.mysql.com/doc/refman/8.0/en/partitioning-info.html
From MySQL 8.0.16, when insertions, deletions, or updates are made to partitioned tables, the binary log records information about the partition and (if any) the subpartition in which the row event took place. The partition information is displayed ... This section discusses obtaining information about existing partitions, which can be done in a number of ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-key.html
Partitioning by key is similar to partitioning by hash, except that where hash partitioning employs a user-defined expression, the hashing function for key partitioning is supplied by the MySQL server. Note Tables using the NDB storage engine are ...NDB Cluster uses MD5() for this purpose; for tables using other storage engines, the server employs its own internal hashing ...
https://dev.mysql.com/doc/refman/8.0/en/pluggable-storage.html
MySQL Server uses a pluggable storage engine architecture that enables storage engines to be loaded into and unloaded from a running MySQL server. Plugging in a Storage Engine Before a storage engine can be used, the storage engine plugin shared ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-expressions.html
Prior to MySQL 8.0.31, for DECIMAL literals, in addition to the precision limit of 65 digits, there is a limit on how long the text of the literal can be. With the ERROR_FOR_DIVISION_BY_ZERO SQL mode enabled, MySQL handles division by zero ... With ...
https://dev.mysql.com/doc/refman/8.0/en/problems-with-float.html
Floating-point numbers sometimes cause confusion because they are approximate and not stored as exact values. For DECIMAL columns, MySQL performs operations with a precision of 65 decimal digits, which should solve most common inaccuracy problems.
https://dev.mysql.com/doc/refman/8.0/en/replication-binlog-encryption-encryption-keys.html
The binary log encryption keys used to encrypt the file passwords for the log files are 256-bit keys that are generated specifically for each MySQL server instance using MySQL Server's keyring service (see Section 8.4.4, “The MySQL Keyring”).