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/innodb-memcached-porting-mysql.html
SELECT CAST(c2 as unsigned integer) FROM demo_test; # Since there could be numeric values of 0, can't disqualify them. SELECT AVG(cast(c2 as unsigned integer)) FROM demo_test WHERE c2 BETWEEN '0' and '9999999999'; # Views let you hide the complexity ... Consider these aspects of memcached applications when adapting an existing MySQL schema or application to use the daemon_memcached plugin: memcached keys cannot contain spaces or newlines, because these characters are used as separators in the ASCII ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-config-values.html
row *************************** Name: NodeId Node: 2 Type: unsigned Default: Minimum: 1 Maximum: 48 Required: Y Current: 2 *************************** 2. row *************************** Name: TotalSendBufferMemory Node: 2 Type: unsigned Default: 0 ... The config_values table, implemented in NDB 7.5.0, provides information about the current state of node configuration parameter ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-differing-tables.html
ALL_SIGNED,ALL_UNSIGNED Treat promoted integer types as signed if possible, otherwise as unsigned. Beginning with MySQL 5.7.2, you can control this behavior using ALL_SIGNED, ALL_UNSIGNED, or both. (Bug#15831300) ALL_SIGNED tells the replica to ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-config.html
Deprecated parameters are indicated in the XML output by the deprecated attribute, as shown here: <param name="NoOfDiskPagesToDiskAfterRestartACC" comment="DiskCheckpointSpeed" type="unsigned" default="20" min="1" max="4294967039" ... This tool ...
https://dev.mysql.com/doc/refman/5.7/en/numeric-type-attributes.html
An unsigned type can be used to permit only nonnegative numbers in a column or when you need a larger upper numeric range for the column. For example, if an INT column is UNSIGNED, the size of the column's range is the same but its endpoints shift ... MySQL supports an extension for optionally specifying the display width of integer data types in parentheses following the base keyword for the ...
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/ansi-diff-foreign-keys.html
row *************************** Table: shirt Create Table: CREATE TABLE `shirt` ( `id` smallint(5) unsigned NOT NULL auto_increment, `style` enum('t-shirt','polo','dress') NOT NULL, `color` enum('red','blue','orange','white','black') NOT NULL, ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-shm-definition.html
Group Version (or later) NDB 7.5.0 Type or units unsigned Default 35 Range 0 - 200 Restart Type Node Restart: Requires a rolling restart of the cluster. PortNumber Version (or later) NDB 7.5.0 Type or units unsigned Default [...] Range 0 - 64K ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-mgm-definition.html
Id Version (or later) NDB 7.5.0 Type or units unsigned Default [...] Range 1 - 255 Restart Type Initial System Restart: Requires a complete shutdown of the cluster, wiping and restoring the cluster file system from a backup, and then restarting the ... The [ndb_mgmd] section is used to configure the behavior of the management ...
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
The parser allows values up to the maximum unsigned integer value for the platform (4294967295 or 232−1 for a 32-bit system, 18446744073709551615 or 264−1 for a 64-bit system) but the actual maximum is a block size lower. Internally, the maximum ... The MySQL server maintains many system variables that affect its ...