PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-by-modifiers.html
The GROUP BY clause permits a WITH ROLLUP modifier that causes summary output to include extra rows that represent higher-level (that is, super-aggregate) summary operations. In this case, each time there is a change in value in any but the last ...
https://dev.mysql.com/doc/refman/8.0/en/gone-away.html
More information on setting the packet size is given in Section B.3.2.8, “Packet Too Large”. You can also get these errors if you send a query to the server that is incorrect or too large. If mysqld receives a packet that is too large or out of ...You may also need to increase the maximum packet size on the client ... This ...
https://dev.mysql.com/doc/refman/8.0/en/unix-signal-response.html
On Unix and Unix-like systems, a process can be the recipient of signals sent to it by the root system account or the system account that owns the process. Some command interpreters associate certain key sequences with signals, such as Control+C to ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-system-tablespace.html
For example: [mysqld] innodb_data_home_dir= innodb_data_file_path=/dev/hdd1:3Graw;/dev/hdd2:2Graw The partition must be at least as large as the size that you specify. The size and number of system tablespace data files is defined by the ... The ...
https://dev.mysql.com/doc/refman/8.0/en/password-management.html
Password failure tracking, to enable temporary account locking after too many consecutive incorrect-password login failures. To expire an account password manually, use the ALTER USER statement: ALTER USER 'jeffrey'@'localhost' PASSWORD EXPIRE; This ... MySQL supports these password-management capabilities: Password expiration, to require passwords to be changed ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool.html
The plugin implements a thread pool that increases server performance by efficiently managing statement execution threads for large numbers of client connections. The thread pool addresses several problems of the model that uses one thread per ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-ndb-comment-options.html
NDB_COLUMN can be used in a column comment to set the size of the blob parts table column used for storing parts of blob values by NDB to its maximum. Beginning with NDB 8.0.30, a column comment can also be used to control the inline size of a blob ... NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-files-table.html
(Bug #92796, Bug #28800252) Prior to NDB 8.0.13, the FILES table contained a row for each of these files on each data node the file belonged to, as well as the size of its undo buffer. That is, the larger EXTENT_SIZE becomes, the less accurate the ...This means, for example, that the name of a data file created with ALTER TABLESPACE ts ADD DATAFILE 'data_2.dat' INITIAL SIZE 256M is shown as ...
https://dev.mysql.com/doc/refman/8.0/en/enum.html
For example, this CREATE TABLE statement does not work because the CONCAT function cannot be used to construct an enumeration value: CREATE TABLE sizes ( size ENUM('small', CONCAT('med','ium'), 'large') ); You also cannot employ a user variable as ...This means that you can use the following SELECT statement to find rows into which invalid ENUM values were assigned: mysql> SELECT * FROM tbl_name WHERE enum_col=0; The index of the NULL value is ...
https://dev.mysql.com/doc/refman/8.0/en/order-by-optimization.html
This enables users to set sort_buffer_size to larger values to speed up larger sorts, without concern for excessive memory use for small sorts. (This benefit may not occur for multiple concurrent sorts on Windows, which has a weak multithreaded ...