MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 1121 to 1130 of 1137 total results

https://dev.mysql.com/doc/refman/5.7/en/partitioning-range.html

For example, when executing a query such as EXPLAIN SELECT COUNT(*) FROM employees WHERE separated BETWEEN '2000-01-01' AND '2000-12-31' GROUP BY store_id;, MySQL can quickly determine that only partition p2 needs to be scanned because the remaining ... A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given ...

25.12.15.5 Object Wait Summary Table

https://dev.mysql.com/doc/refman/5.7/en/performance-schema-objects-summary-global-by-type-table.html

The objects_summary_global_by_type table has these grouping columns to indicate how the table aggregates events: OBJECT_TYPE, OBJECT_SCHEMA, and OBJECT_NAME. The Performance Schema maintains the objects_summary_global_by_type table for aggregating ...

25.12.5 Performance Schema Stage Event Tables

https://dev.mysql.com/doc/refman/5.7/en/performance-schema-stage-tables.html

The Performance Schema instruments stages, which are steps during the statement-execution process, such as parsing a statement, opening a table, or performing a filesort operation. Stages correspond to the thread states displayed by SHOW ...

Preface and Legal Notices

https://dev.mysql.com/doc/refman/5.7/en/preface.html

This is the Reference Manual for the MySQL Database System, version 5.7, through release 5.7.44. Differences between minor versions of MySQL 5.7 are noted in the present text with reference to release numbers (5.7.x). This manual is not intended ...

4.1 Overview of MySQL Programs

https://dev.mysql.com/doc/refman/5.7/en/programs-overview.html

my_print_defaults A utility that shows which options are present in option groups of option files. Later sections provide a more detailed description of each one, with the exception of NDB Cluster programs. Each program's description indicates its ...

16.4.1.10 Replication with Differing Table Definitions on Source and Replica

https://dev.mysql.com/doc/refman/5.7/en/replication-features-differing-tables.html

Source and target tables for replication do not have to be identical. A table on the source can have more or fewer columns than the replica's copy of the table. In addition, corresponding table columns on the source and the replica can use ...

16.1.3.5 Using GTIDs for Failover and Scaleout

https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-failover.html

As with the method using empty transactions, this method creates a server that is functionally a snapshot, but in time is able to become a source as its binary log history converges with that of the replication source server or the group. There are ...

16.3.7 Switching Sources During Failover

https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-switch.html

In a failover situation, all the servers in the group are typically executing the same events from the same binary log file, so changing the source of the events should not affect the structure or integrity of the database, provided that you ... You ...

3.3.4.2 Selecting Particular Rows

https://dev.mysql.com/doc/refman/5.7/en/selecting-rows.html

As shown in the preceding section, it is easy to retrieve an entire table. But typically you don't want to see the entire table, particularly when it becomes large. Instead, you're usually more interested in answering a particular question, in ...

5.1.3 Server Option, System Variable, and Status Variable Reference

https://dev.mysql.com/doc/refman/5.7/en/server-option-variable-reference.html

The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...

Displaying 1121 to 1130 of 1137 total results