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/not-enough-file-handles.html
You can remove the # character to uncomment this line, and change the number 256 to set the number of file descriptors to be made available to mysqld. If you get ERROR 'file_name' not found (errno: 23), Can't open file: file_name (errno: 24), or ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-blob.html
See Section 10.4.2.2, “Optimizing for Character and String Types” for reasons why a binary VARCHAR column is sometimes preferable to an equivalent BLOB column. When storing a large blob containing textual data, consider compressing it first. Do ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-statistics.html
The column_statistics table has these characteristics: The table contains statistics for columns of all data types except geometry types (spatial data) and JSON. The value is one of int, uint (unsigned integer), double, decimal, datetime, or string ... The column_statistics data dictionary table stores histogram statistics about column values, for use by the optimizer in constructing query execution ...
https://dev.mysql.com/doc/refman/8.0/en/option-defaults-equals.html
(The & character tells the operating system to run MySQL in the background; it is ignored by MySQL itself.) Now suppose that you wish to log errors to a file named my-errors.err. Due to this behavior, problems can occasionally arise when no value is ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-exchange.html
Table nt contains no foreign key references, and no other table has any foreign keys that refer to nt. There are no rows in nt that lie outside the boundaries of the partition definition for p. For InnoDB tables, both tables must use the same row ...
https://dev.mysql.com/doc/refman/8.0/en/password-security-user.html
In this case, the client program solicits the password interactively: $> mysql -u francis -p db_name Enter password: ******** The * characters indicate where you enter your password. MySQL users should use the following guidelines to keep passwords ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-statements-current-table.html
See Section 29.10, “Performance Schema Statement Digests and Sampling”.) DIGEST The statement digest SHA-256 value as a string of 64 hexadecimal characters, or NULL if the statements_digest consumer is no. The table stores one row per thread ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-instrument-naming.html
An instrument name consists of a sequence of elements separated by '/' characters. Example names: wait/io/file/myisam/log wait/io/file/mysys/charset wait/lock/table/sql/handler wait/synch/cond/mysys/COND_alarm ...
https://dev.mysql.com/doc/refman/8.0/en/point-in-time-recovery-binlog.html
If your binary log contains \0 (null) characters, that output cannot be parsed by mysql unless you invoke it with the --binary-mode option. This section explains the general idea of using the binary log to perform a point-in-time-recovery. The next ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-expressions.html
If the value exceeds approximately 80 characters, unexpected results can occur. Suppose that we have this statement: INSERT INTO t SET i = 1/0; This is what happens for combinations of strict and ERROR_FOR_DIVISION_BY_ZERO modes. With precision ...