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/mysql-upgrade.html
--max-allowed-packet=value Command-Line Format --max-allowed-packet=value Type Integer Default Value 25165824 Minimum Value 4096 Maximum Value 2147483648 The maximum size of the buffer for client/server communication. --net-buffer-length=value ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html
--max-allowed-packet=N Command-Line Format --max-allowed-packet=N Type Numeric Default Value 25165824 The maximum size of the buffer for client/server communication. mysqlpump Invocation Syntax mysqlpump Option Summary mysqlpump Option Descriptions ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-reference.html
max_relay_log_size: If nonzero, relay log is rotated automatically when its size exceeds this value. If zero, size at which rotation occurs is determined by value of max_binlog_size. replica_checkpoint_group: Maximum number of transactions processed ... The following two sections provide basic information about the MySQL command-line options and system variables applicable to replication and the binary ...
https://dev.mysql.com/doc/refman/8.0/en/where-optimization.html
Some examples of queries that are very fast: SELECT COUNT(*) FROM tbl_name; SELECT MIN(key_part1),MAX(key_part1) FROM tbl_name; SELECT MAX(key_part2) FROM tbl_name WHERE key_part1=constant; SELECT ... This section discusses optimizations that can ...
https://dev.mysql.com/doc/refman/8.0/en/adding-collation-choosing-id.html
To add a collation, you must choose an ID value that is not currently used. The range of IDs from 1024 to 2047 is reserved for user-defined collations. The collation ID that you choose appears in these contexts: The ID column of the Information ...
https://dev.mysql.com/doc/refman/8.0/en/all-subqueries.html
The expression is TRUE if table t2 contains (-5,0,+5) because 10 is greater than all three values in t2. The expression is FALSE if table t2 contains (12,6,NULL,-100) because there is a single value 12 in table t2 that is greater than 10. The ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-setting.html
When row-based binary logging is used, the binlog_row_event_max_size system variable and its corresponding startup option --binlog-row-event-max-size set a soft limit on the maximum size of row events. If an event cannot be split, the maximum size ... You can select the binary logging format explicitly by starting the MySQL server with ...
https://dev.mysql.com/doc/refman/8.0/en/example-maximum-column-group-row.html
Task: For each article, find the dealer or dealers with the most expensive price. Other possibilities for solving the problem are to use an uncorrelated subquery in the FROM clause, a LEFT JOIN, or a common table expression with a window function.
https://dev.mysql.com/doc/refman/8.0/en/group-replication-system-variables.html
group_replication_auto_increment_increment Command-Line Format --group-replication-auto-increment-increment=# System Variable group_replication_auto_increment_increment Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 7 ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-operations.html
ERROR 4092 (HY000): Column can't be added with ALGORITHM=INSTANT as after this max possible row size crosses max permissible row size. The maximum number of columns in the internal representation of the table cannot exceed 1022 after column addition ... Online support details, syntax examples, and usage notes for DDL operations are provided under the following topics in this ...