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/converting-tables-to-innodb.html
autocommit=1 is suitable for InnoDB tables when running a sequence of queries for generating reports or analyzing statistics. File-per-table tablespaces also support the Barracuda file format and associated features such as table compression, ... If ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-memory-per-fragment.html
Every row having one or more variable-sized, one or more dynamic columns (or both) has a variable-sized part. Each row in an NDB table has a fixed-size part, consisting of a row header, and one or more fixed-size columns. The total free space ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-modifiers.html
ROLLUP has a more complex effect when there are multiple GROUP BY columns. In this case, each time there is a change in value in any but the last grouping column, the query produces an extra super-aggregate summary row. These rows have the country ... The GROUP BY clause permits a WITH ROLLUP modifier that causes summary output to include extra rows that represent higher-level (that is, super-aggregate) summary ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-troubleshoot.html
These limits primarily apply if you intend to create an index on a value column to run report-generating queries on that column using SQL. loose-daemon_memcached_option='-vvv' If columns specified to hold memcached values are the wrong data type, ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-storage-engine.html
See Section 4.5.3, “mysqlcheck — A Table Maintenance Program”, Section 4.6.3, “myisamchk — MyISAM Table-Maintenance Utility”, and Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”. Also, the code in the ...
https://dev.mysql.com/doc/refman/5.7/en/merge-storage-engine.html
“Identical” means that all tables have identical column data types and index information. You cannot merge MyISAM tables in which the columns are listed in a different order, do not have exactly the same data types in corresponding columns, or ... The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as ...
https://dev.mysql.com/doc/refman/5.7/en/internal-temporary-tables.html
Note When using internal_tmp_disk_storage_engine=INNODB, queries that generate on-disk internal temporary tables that exceed InnoDB row or column limits return Row size too large or Too many columns errors. Evaluation of statements that contain an ... In some cases, the server creates internal temporary tables while processing ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-cluster-locks.html
The transaction ID (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; this is always one of S (indicating a shared lock) or X (an exclusive ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-limits.html
A table can contain a maximum of 1017 columns (raised in MySQL 5.6.9 from the earlier limit of 1000). For example, you might hit this limit with a column prefix index of more than 255 characters on a TEXT or VARCHAR column, assuming a utf8mb3 ...
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 ...