MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 1101 to 1110 of 1120 total results

4.3.2 mysqld_safe — MySQL Server Startup Script

https://dev.mysql.com/doc/refman/5.7/en/mysqld-safe.html

Options unknown to mysqld_safe are passed to mysqld if they are specified on the command line, but ignored if they are specified in the [mysqld_safe] group of an option file. mysqld_safe is the recommended way to start a mysqld server on Unix.

4.6.8 mysqldumpslow — Summarize Slow Query Log Files

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

Normally, mysqldumpslow groups queries that are similar except for the particular values of number and string data values. The MySQL slow query log contains information about queries that take a long time to execute (see Section 5.4.5, “The Slow ...

22.6.2 Partitioning Limitations Relating to Storage Engines

https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-storage-engines.html

The maximum number of partitions that can be defined for an NDB table depends on the number of data nodes and node groups in the cluster, the version of the NDB Cluster software in use, and other factors. The following limitations apply to the use ...

22.2.1 RANGE Partitioning

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 ...

Displaying 1101 to 1110 of 1120 total results