PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-setup.html
This build option generates two shared libraries in the MySQL plugin directory (plugin_dir) that are required to run the daemon_memcached plugin: libmemcached.so: the memcached daemon plugin to MySQL. Entries in the containers table provide a ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-server-locks.html
The transaction ID shown in the transid column is the identifier generated by the NDB API for the transaction requesting or holding the current lock. The mode column shows the lock mode, which is always one of S (shared lock) or X (exclusive lock).
https://dev.mysql.com/doc/refman/5.7/en/binary-varbinary.html
If strict SQL mode is not enabled and you assign a value to a BINARY or VARBINARY column that exceeds the column's maximum length, the value is truncated to fit and a warning is generated. For the latter types, the BINARY attribute does not cause ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-ndb-comment-options.html
NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB table. NDB_COLUMN can be used in a column comment to set the size of the blob parts table ...
https://dev.mysql.com/doc/refman/5.7/en/union.html
Selected columns listed in corresponding positions of each SELECT statement should have the same data type. For example, the first column selected by the first statement should have the same type as the first column selected by the other statements.
https://dev.mysql.com/doc/refman/5.7/en/replication-options-source.html
auto_increment_increment and auto_increment_offset affect AUTO_INCREMENT column behavior as follows: auto_increment_increment controls the interval between successive column values. The highest value present in the col column prior to the INSERT is ... This section describes the server options and system variables that you can use on replication source ...
https://dev.mysql.com/doc/refman/5.7/en/trigger-syntax.html
(Such a SET statement has no effect in an AFTER trigger because the row change has already occurred.) In a BEFORE trigger, the NEW value for an AUTO_INCREMENT column is 0, not the sequence number that is generated automatically when the new row ...
https://dev.mysql.com/doc/refman/5.7/en/data-size.html
You can get better performance for a table and minimize storage space by using the techniques listed here: Table Columns Row Format Indexes Joins Normalization Table Columns Use the most efficient (smallest) data types possible. MEDIUMINT is often a ... Design your tables to minimize their space on the ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-cjk.html
You can obtain this information for a column column_name in the table table_name using the following query: SELECT HEX(column_name) FROM table_name; 3F is the encoding for the ? character; this means that ? is the character actually stored in the ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-range.html
While the examples work as shown for purposes of the present discussion, you should keep in mind that tables are extremely likely in practice to have primary keys, unique keys, or both, and that allowable choices for partitioning columns depend on ... A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given ...