PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-limitations-transactions.html
A number of limitations exist in NDB Cluster with regard to the handling of transactions. The NDBCLUSTER storage engine supports only the READ COMMITTED transaction isolation level. To ensure that a given transaction reads only before or after ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbd-definition.html
Consider this table definition: CREATE TABLE example ( a INT NOT NULL, b INT NOT NULL, c INT NOT NULL, PRIMARY KEY(a), UNIQUE(b) ) ENGINE=NDBCLUSTER; For each record, there are 12 bytes of data plus 12 bytes overhead. The [ndbd] and [ndbd default] ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-select-all.html
ndb_select_all prints all rows from an NDB table to stdout. Usage ndb_select_all -c connection_string tbl_name -d db_name [> file_name] Options that can be used with ndb_select_all are shown in the following table. --connect-retries Command-Line ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-logging.html
Then use either of the following techniques to prevent it from being created again: Set the MYSQL_HISTFILE environment variable to /dev/null. Create .mysql_history as a symbolic link to /dev/null; this need be done only once: ln -s /dev/null ... The ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-shell-tutorial-javascript-documents-in-tables.html
In MySQL, a table may contain traditional relational data, JSON values, or both. You can combine traditional data with JSON documents by storing the documents in columns having a native JSON data type. Examples in this section use the city table in ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-shell-tutorial-python-documents-in-tables.html
In MySQL, a table may contain traditional relational data, JSON values, or both. You can combine traditional data with JSON documents by storing the documents in columns having a native JSON data type. Examples in this section use the city table in ...
https://dev.mysql.com/doc/refman/9.7/en/numeric-type-syntax.html
SERIAL is an alias for BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE. SERIAL DEFAULT VALUE in the definition of an integer column is an alias for NOT NULL AUTO_INCREMENT UNIQUE. SERIAL is an alias for BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE.
https://dev.mysql.com/doc/refman/9.7/en/optimizing-any-all-subqueries.html
If the selected expression is nullable, and processing of nulls is necessary, select an indication of whether the subquery contains any nulls. A <>ALL or =ANY predicate, when placed in the SELECT list of the outer query, must not contain any ...
https://dev.mysql.com/doc/refman/9.7/en/optimizing-innodb-queries.html
If an indexed column cannot contain any NULL values, declare it as NOT NULL when you create the table. The optimizer can better determine which index is most effective to use for a query, when it knows whether each column contains NULL values. To ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-linear-hash.html
MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm whereas regular hashing employs the modulus of the hashing function's value. We call this value V; it can be ...