PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-metrics-table.html
row *************************** NAME: dml_inserts SUBSYSTEM: dml COUNT: 3 MAX_COUNT: 3 MIN_COUNT: NULL AVG_COUNT: 0.046153846153846156 COUNT_RESET: 3 MAX_COUNT_RESET: 3 MIN_COUNT_RESET: NULL AVG_COUNT_RESET: NULL TIME_ENABLED: 2014-12-04 14:18:28 ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-fulltext-index.html
If you want to create your own FTS_DOC_ID column, the column must be defined as BIGINT UNSIGNED NOT NULL and named FTS_DOC_ID (all uppercase), as in the following example: Note The FTS_DOC_ID column does not need to be defined as an AUTO_INCREMENT ... Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-key.html
Unlike the case with other partitioning types, columns used for partitioning by KEY are not restricted to integer or NULL values. This is a known issue in MySQL 5.7 which is addressed in MySQL 8.0, where this permissive behavior is deprecated, and ... 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 ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-expressions.html
If a numeric expression contains any strings, they are converted to double-precision floating-point values and the expression is approximate. For inserts of strings into numeric columns, conversion from string to number is handled as follows if the ... With precision math, exact-value numbers are used as given whenever ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-example-data.html
Note The information in this section applies to NDB Cluster running on both Unix and Windows platforms. Working with database tables and data in NDB Cluster is not much different from doing so in standard MySQL. There are two key points to keep in ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-what-is-new-7-5.html
This setting overrides --ndb-nodeid, which means that it also overrides both the --ndb-connectstring option and the NDB_CONNECTSTRING environment variable. Attempting to use any of these parameters in an NDB Cluster configuration file now results in ... Major changes and new features in NDB Cluster 7.5 which are likely to be of interest are shown in the following list: ndbinfo ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-types.html
MySQL's other partitioning types, however, require a partitioning expression that yields an integer value or NULL. However, you can use other date and time functions that return an integer or NULL, such as WEEKDAY(), DAYOFYEAR(), or MONTH(). This ...
https://dev.mysql.com/doc/refman/5.7/en/gtid-functions.html
It is important to keep in mind that all of these functions take string representations of GTID sets as arguments. The union of two GTID sets is simply their representations as strings, joined together with an interposed comma. The GTID sets used ...
https://dev.mysql.com/doc/refman/5.7/en/bit-functions.html
binary: Any kind of binary string argument, including a hexadecimal literal, bit literal, or NULL literal. nonliteral_binary: An argument that is a binary string value other than a hexadecimal literal, bit literal, or NULL literal. mysql> SELECT 5 & ... Table 12.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 functions and operators: | Bitwise ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbd-definition.html
Data Memory, Index Memory, and String Memory DataMemory and IndexMemory are [ndbd] parameters specifying the size of memory segments used to store the actual records and their indexes. StringMemory Version (or later) NDB 7.5.0 Type or units % or ...