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-programs-ndb-show-tables.html
ndb_show_tables displays a list of all NDB database objects in the cluster. By default, this includes not only both user-created tables and NDB system tables, but NDB-specific indexes, internal triggers, and NDB Cluster Disk Data objects as well.
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-memory-summary-tables.html
Memory summary tables do not contain timing information because memory events are not timed. Example memory event summary information: mysql> SELECT * FROM performance_schema.memory_summary_global_by_event_name WHERE EVENT_NAME = ...Operation counts ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-stage-summary-tables.html
The Performance Schema maintains tables for collecting current and recent stage events, and aggregates that information in summary tables. Section 25.12.5, “Performance Schema Stage Event Tables” describes the events on which stage summaries ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-transaction-summary-tables.html
The Performance Schema maintains tables for collecting current and recent transaction events, and aggregates that information in summary tables. Section 25.12.7, “Performance Schema Transaction Tables” describes the events on which transaction ...Example transaction event summary information: mysql> SELECT * FROM performance_schema.events_transactions_summary_global_by_event_name LIMIT 1\G *************************** ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-storage-engines.html
(This is currently supported only by MyISAM.) In addition, ALTER TABLE ... CREATE TABLE and ALTER TABLE statements that would cause a user-partitioned NDB table not to meet either or both of the following two requirements are not permitted, and fail ... The following limitations apply to the use of storage engines with user-defined partitioning of ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-handling-nulls.html
DROP PARTITION, see Section 13.1.8, “ALTER TABLE Statement”.) NULL is also treated in this way for partitioning expressions that use SQL functions. If you insert a row into a table partitioned by RANGE such that the column value used to ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-overview.html
However, if no columns are listed in the PARTITION BY KEY or PARTITION BY LINEAR KEY clause of the CREATE TABLE or ALTER TABLE statement used to create or modify a user-partitioned NDB table, then the table is not required to have an explicit ...The ... This section provides a conceptual overview of partitioning in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/update.html
UPDATE is a DML statement that modifies rows in a table. Single-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] table_reference SET assignment_list [WHERE where_condition] [ORDER BY ...] [LIMIT row_count] value: {expr | DEFAULT} assignment: col_name = ...The SET clause indicates which columns to modify and the values they should be ...
https://dev.mysql.com/doc/refman/5.7/en/creating-tables.html
If you make a poor choice and it turns out later that you need a longer field, MySQL provides an ALTER TABLE statement. You want a table that contains a record for each of your pets. This can be called the pet table, and it should contain, as a bare ...For example, if more than one person in your family keeps pets, you might want to list each animal's ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-binary-log.html
For example, DDL statements such as CREATE TABLE and ALTER TABLE are always logged as statements, without regard to the logging format in effect, so the following statement-based rules for --binlog-do-db always apply in determining whether or not ...