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/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 ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-tables.html
Typically, this means from the time the server gets the first packet from the client to the time the server has finished sending the response. This may be helpful for purposes such as identifying clients that are misconfigured or using a version of ...Statement events occur at a high level of the event ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-monitoring.html
INSTALL PLUGIN plugin_b; The server has room for 200-190 = 10 instruments (in this case, mutex classes), and sees that the plugin contains 20 new instruments. The default value is chosen to be sufficient to load all the plugins provided in the MySQL ...Names for these variables have several forms: Performance_schema_xxx_classes_lost indicates how many instruments of type xxx could not be ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-system-variable-tables.html
An application that wants only global values should use this table. An application that wants all system variable values for its own session should use this table. An application that wants to know the session variable values for specific sessions ... Note The value of the show_compatibility_56 system variable affects the information available from the tables described ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-wait-summary-tables.html
In this way, aggregations at higher levels are available directly without the need for user-defined views that sum lower-level columns. This table is also truncated by truncation of the table_io_waits_summary_by_table table. This table contains ...