PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/floating-point-types.html
MySQL uses four bytes for single-precision values and eight bytes for double-precision values. For FLOAT, the SQL standard permits an optional specification of the precision (but not the range of the exponent) in bits following the keyword FLOAT in ... The FLOAT and DOUBLE types represent approximate numeric data ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-engines-table.html
This is particularly useful for checking whether a storage engine is supported, or to see what the default engine is. SUPPORT The server's level of support for the storage engine, as shown in the following table. You might also see DISABLED for a ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-virtual-table.html
CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL, `c` int(11) GENERATED ALWAYS AS (5) VIRTUAL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; However, metadata for such a column does appear in the INNODB_SYS_COLUMNS table. The ...The ...
https://dev.mysql.com/doc/refman/5.7/en/libmysqld.html
The main benefits are increased speed and more simple management for embedded applications. The API is identical for the embedded MySQL version and the client/server version. Table 27.2 MySQL Embedded Server Library Functions Function When to Call ... The embedded MySQL server library makes it possible to run a full-featured MySQL server inside a client ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-configuration-overview.html
Each of the node parameter tables lists the parameters for a given type (ndbd, ndb_mgmd, mysqld, computer, tcp, or shm). All tables include the data type for the parameter, option, or variable, as well as its default, mimimum, and maximum values as ...It is possible to update cluster configuration parameters marked as node online—that is, without shutting down the cluster—in this ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-disk-data.html
Disk data objects are subject to the following maximums and minimums: Maximum number of tablespaces: 232 (4294967296) Maximum number of data files per tablespace: 216 (65536) The minimum and maximum possible sizes of extents for tablespace data ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-redo-log-reader.html
Reads a redo log file, checking it for errors, printing its contents in a human-readable format, or both. ndb_redo_log_reader is intended for use primarily by NDB Cluster developers and Support personnel in debugging and diagnosing problems. The ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-partitioning-keys-unique-keys.html
The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must be part of every unique key that the table may have. For the same reason, you cannot later add a unique ...
https://dev.mysql.com/doc/refman/5.7/en/pattern-matching.html
MySQL provides standard SQL pattern matching as well as a form of pattern matching based on extended regular expressions similar to those used by Unix utilities such as vi, grep, and sed. When you test for a match for this type of pattern, use the ...SQL pattern matching enables you to use _ to match any single character and % to match an arbitrary number of characters (including zero ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-performance-timers-table.html
Note As of MySQL 5.7.21, the Performance Schema setup_timers table is deprecated and is removed in MySQL 8.0, as is the TICKS row in the performance_timers table. The performance_timers table has these columns: TIMER_NAME The name by which to refer ...The rows that do not contain NULL indicate which timers you can use in ...