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/mysql-cluster-programs-ndb-move-data.html
--exclude-missing-columns Command-Line Format --exclude-missing-columns Ignore extra columns in source or target table. Usage The program is invoked with the names of the source and target tables; either or both of these may be qualified optionally ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-spatial-analysis.html
For MyISAM and InnoDB tables, search operations in columns containing spatial data can be optimized using SPATIAL indexes. The most typical operations are: Point queries that search for all objects that contain a given point Region queries that ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-info.html
The Engine column contains the name of the storage engine used by all partitions of the table. The partitions column in the EXPLAIN output lists the partitions from which records would be matched by the query. The rows column of EXPLAIN output ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-exchange.html
The number, order, names, and types of columns and indexes of the partitioned table and the nonpartitioned table must match exactly. Table nt contains no foreign key references, and no other table has any foreign keys that refer to nt. There are no ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-applier-status-table.html
The replication_applier_status table has these columns: CHANNEL_NAME The replication channel which this row is displaying. The following table shows the correspondence between replication_applier_status columns and SHOW SLAVE STATUS columns. This ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-actors-table.html
If a row from that table matches, its ENABLED and HISTORY column values are used to set the INSTRUMENTED and HISTORY columns, respectively, of the threads table row for the thread. If there is no match, the INSTRUMENTED and HISTORY columns for the ... The setup_actors table contains information that determines whether to enable monitoring and historical event logging for new foreground server threads (threads associated with client ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-objects-table.html
For existing rows, only the ENABLED and TIMED columns can be modified, by users with the UPDATE privilege on the table. The setup_objects table has these columns: OBJECT_TYPE The type of object to instrument. The setup_objects table controls ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-digests.html
In this case, the difference in the second column name is lost and both statements are considered the same. The statement event tables (events_statements_current, events_statements_history, and events_statements_history_long) have columns for ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-variable-summary-tables.html
Each status variable summary table has one or more grouping columns to indicate how the table aggregates status values: status_by_account has USER, HOST, and VARIABLE_NAME columns to summarize status variables by account. status_by_host has HOST and ... 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-status-variable-tables.html
For example: SELECT EVENT_NAME, COUNT_STAR FROM performance_schema.events_statements_summary_global_by_event_name WHERE EVENT_NAME LIKE 'statement/sql/%'; The global_status and session_status tables have these columns: VARIABLE_NAME The status ...