MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 91 to 100 of 104 total results

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

The row with DIGEST = NULL is maintained because Performance Schema tables have a maximum size due to memory constraints. The Performance Schema maintains tables for collecting current and recent statement events, and aggregates that information in ...

25.7 Performance Schema Status Monitoring

https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-monitoring.html

Names for these variables have several forms: Performance_schema_xxx_classes_lost indicates how many instruments of type xxx could not be loaded. Performance_schema_xxx_instances_lost indicates how many instances of object type xxx could not be ...

25.16 Performance Schema Status Variables

https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-variables.html

Performance Schema status variables have the following meanings: Performance_schema_accounts_lost The number of times a row could not be added to the accounts table because it was full. Performance_schema_digest_lost The number of digest instances ...

6.2.2 Privileges Provided by MySQL

https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html

REFERENCES Creation of a foreign key constraint requires the REFERENCES privilege for the parent table. The privileges granted to a MySQL account determine which operations the account can perform. MySQL privileges differ in the contexts in which ...

16.1.6.2 Replication Source Options and Variables

https://dev.mysql.com/doc/refman/5.7/en/replication-options-source.html

This change introduces a version compatibility constraint because it increments the semisynchronous interface version: Servers for MySQL 5.7.2 and up do not work with semisynchronous replication plugins from older versions, nor do servers from older ... This section describes the server options and system variables that you can use on replication source ...

13.2.9.1 SELECT ... INTO Statement

https://dev.mysql.com/doc/refman/5.7/en/select-into.html

There are also constraints on the use of INTO within UNION statements; see Section 13.2.9.3, “UNION Clause”. INTO form of SELECT enables a query result to be stored in variables or written to a file: SELECT ... Column and line terminators can be ...

3.3.4.2 Selecting Particular Rows

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

Instead, you're usually more interested in answering a particular question, in which case you specify some constraints on the information you want. As shown in the preceding section, it is easy to retrieve an entire table. But typically you don't ...

5.1.10 Server SQL Modes

https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html

Strict mode does not affect whether foreign key constraints are checked. The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system variable. DBAs ...

Chapter 15 Alternative Storage Engines

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

To maintain data integrity, InnoDB also supports FOREIGN KEY referential-integrity constraints. Storage engines are MySQL components that handle the SQL operations for different table types. InnoDB is the default and most general-purpose storage ...

8.4.6 Limits on Table Size

https://dev.mysql.com/doc/refman/5.7/en/table-size-limit.html

The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. For up-to-date information operating system file size limits, refer to the documentation ...

Displaying 91 to 100 of 104 total results