PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/xa.html
The branches indicate whether they are able to do this, and these results are used for the second phase. In the second phase, the TM tells the RMs whether to commit or roll back. Support for XA transactions is available for the InnoDB storage ...
https://dev.mysql.com/doc/refman/9.7/en/aggregate-functions.html
InnoDB processes SELECT COUNT(*) statements by traversing the smallest available secondary index unless an index or optimizer hint directs the optimizer to use a different index. If a secondary index is not present, InnoDB processes SELECT COUNT(*) ... This section describes aggregate functions that operate on sets of ...
https://dev.mysql.com/doc/refman/9.7/en/alter-table-partition-operations.html
Partitioning-related clauses for ALTER TABLE can be used with partitioned tables for repartitioning, to add, drop, discard, import, merge, and split partitions, and to perform partitioning maintenance. Simply using a partition_options clause with ...
https://dev.mysql.com/doc/refman/9.7/en/analyze-table.html
The second statement updates the histograms for c1 and c3, leaving the c2 histogram unaffected. ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ... [WITH N BUCKETS] [{MANUAL | AUTO} UPDATE] ANALYZE ...
https://dev.mysql.com/doc/refman/9.7/en/ansi-diff-update.html
The second assignment in the following statement sets col2 to the current (updated) col1 value, not the original col1 value. If you access a column from the table to be updated in an expression, UPDATE uses the current value of the column. The ...
https://dev.mysql.com/doc/refman/9.7/en/bit-functions.html
Table 14.17 Bit Functions and Operators Name Description & Bitwise AND >> Right shift << Left shift ^ Bitwise XOR BIT_COUNT() Return the number of bits that are set | Bitwise OR ~ Bitwise inversion The following list describes available bit ...
https://dev.mysql.com/doc/refman/9.7/en/case.html
For the second syntax, each WHEN clause search_condition expression is evaluated until one is true, at which point its corresponding THEN clause statement_list executes. CASE case_value WHEN when_value THEN statement_list [WHEN when_value THEN ...
https://dev.mysql.com/doc/refman/9.7/en/channels-startup-options.html
--replica-net-timeout=N This value is set per channel, so that each channel waits for N seconds to check for a broken connection. This section describes startup options which are impacted by the addition of replication channels. The following ...
https://dev.mysql.com/doc/refman/9.7/en/charset-collation-effect.html
The second column shows the result of the SELECT using the German DIN-1 rule, which says that U-umlaut sorts with U. latin1_swedish_ci latin1_german1_ci latin1_german2_ci Muffler Muffler Müller MX Systems Müller Muffler Müller MX Systems MX ...
https://dev.mysql.com/doc/refman/9.7/en/charset-collation-information-schema.html
A lower_case_table_names setting of 1 or 2 causes the second query to return the same (nonempty) result as the first query. String columns in INFORMATION_SCHEMA tables have a collation of utf8mb3_general_ci, which is case-insensitive. However, for ...