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/myisamchk-memory.html
If this happens, run myisamchk with the --tmpdir=dir_name option to specify a directory located on a file system that has more space. This space is not needed if you do a repair with --quick; in this case, only the index file is re-created. This ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-config-starting.html
We do not recommend using more than two fragment replicas, since # two are sufficient to provide high availability, and we do not currently test # with greater values for this parameter. LockPagesInMainMemory=1 # On Linux and Solaris systems, ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-windows-service.html
This also makes it possible to control these processes from the command line with the appropriate SC START and SC STOP commands, or using the Windows graphical Services utility. To specify a service name other than ndb_mgmd, append it to the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-database-objects.html
A statement using a database name or table name longer than this limit fails with an appropriate error. Each BLOB or TEXT column contributes 256 + 8 = 264 bytes to this total; this includes JSON columns. In addition, the maximum offset for a ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-limits.html
In this section, we list limits found in NDB Cluster that either differ from limits found in, or that are not found in, standard MySQL. However, this memory can be made available for general re-use by performing OPTIMIZE TABLE. A DROP TABLE or ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-redo-log-reader.html
This utility remains under development, and its syntax and behavior are subject to change in future NDB Cluster releases. redo log files are located in the numbered directories under the data node's data directory (DataDir); the path under this ...
https://dev.mysql.com/doc/refman/5.7/en/outer-join-simplification.html
This results in a query with no outer joins at all: SELECT * FROM (T1 INNER JOIN T2 ON T2.A=T1.A), T3 WHERE T3.C > 0 AND T3.B=T2.B Sometimes the optimizer succeeds in replacing an embedded outer join operation, but cannot convert the embedding outer ... Table expressions in the FROM clause of a query are simplified in many ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-subpartitions.html
An exception to this is that SUBPARTITION BY KEY (unlike PARTITION BY KEY) does not currently support a default column, so the column used for this purpose must be specified, even if the table has an explicit primary key. This is a known issue which ... Subpartitioning—also known as composite partitioning—is the further division of each partition in a partitioned ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-objects-table.html
This table has a maximum size of 100 rows by default. (Tables in the INFORMATION_SCHEMA database are not instrumented regardless of the contents of setup_objects; the row for information_schema.% simply makes this default explicit.) When the ... The ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-startup-configuration.html
To configure all condition synchronization instruments as enabled and counted, use this option: --performance-schema-instrument='wait/synch/cond/%=COUNTED' To disable all instruments, use this option: --performance-schema-instrument='%=OFF' ... To ...