MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 691 to 700 of 708 total results

26.4.4.25 The statement_performance_analyzer() Procedure

https://dev.mysql.com/doc/refman/5.7/en/sys-statement-performance-analyzer.html

Creates a report of the statements running on the server. The views are calculated based on the overall and/or delta activity. This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system ...

8.4.3.1 How MySQL Opens and Closes Tables

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

When you execute a mysqladmin status command, you should see something like this: Uptime: 426 Running threads: 1 Questions: 11082 Reloads: 1 Open tables: 12 The Open tables value of 12 can be somewhat puzzling if you have fewer than 12 tables.

8.2.1.20 Avoiding Full Table Scans

https://dev.mysql.com/doc/refman/5.7/en/table-scan-avoidance.html

The output from EXPLAIN shows ALL in the type column when MySQL uses a full table scan to resolve a query. This usually happens under the following conditions: The table is so small that it is faster to perform a table scan than to bother with a ...

B.3.6.2 TEMPORARY Table Problems

https://dev.mysql.com/doc/refman/5.7/en/temporary-table-problems.html

Temporary tables created with CREATE TEMPORARY TABLE have the following limitations: TEMPORARY tables are supported only by the InnoDB, MEMORY, MyISAM, and MERGE storage engines. Use ALTER TABLE instead: ALTER TABLE old_name RENAME new_name; You ...

5.5.3.2 Thread Pool Installation

https://dev.mysql.com/doc/refman/5.7/en/thread-pool-installation.html

To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 5.5.2, “Obtaining Server Plugin Information”). This section describes how to install MySQL Enterprise Thread Pool. For ...

5.5.3.4 Thread Pool Tuning

https://dev.mysql.com/doc/refman/5.7/en/thread-pool-tuning.html

This section provides guidelines on setting thread pool system variables for best performance, measured using a metric such as transactions per second. Our experience in testing the thread pool indicates the following: If the primary storage engine ...

8.3.11 Indexed Lookups from TIMESTAMP Columns

https://dev.mysql.com/doc/refman/5.7/en/timestamp-lookups.html

(The example shown earlier illustrates how this can occur.) The query specifies a search value that is within the hour of entry into DST in the session time zone. In such cases, all index-using queries of the form shown match at most one index entry. Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and retrieved from TIMESTAMP columns are converted between the session time zone and ...

8.15.5 Tracing Memory Usage

https://dev.mysql.com/doc/refman/5.7/en/tracing-memory-usage.html

If this limit is reached, the current trace is not extended, which means the trace is incomplete; in this case the MISSING_BYTES_BEYOND_MAX_MEM_SIZE column shows the number of bytes missing from the trace. Each stored trace is a string, which is ...

4.2.5 Connection Transport Protocols

https://dev.mysql.com/doc/refman/5.7/en/transport-protocols.html

The following table shows the permissible values for --protocol and indicates the applicable platforms for each value. For programs that use the MySQL client library (for example, mysql and mysqldump), MySQL supports connections to the server based ...

23.3 Using Triggers

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

The following sections describe the syntax for creating and dropping triggers, show some examples of how to use them, and indicate how to obtain trigger metadata. A trigger is a named database object that is associated with a table, and that ...

Displaying 691 to 700 of 708 total results