MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 831 to 840 of 847 total results

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

6.4.1.12 Test Pluggable Authentication

https://dev.mysql.com/doc/refman/5.7/en/test-pluggable-authentication.html

For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE '%test_plugin%'; +--------------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | +--------------------+---------------+ | ... MySQL ...

8.14.2 Thread Command Values

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

A thread can have any of the following Command values: Binlog Dump This is a thread on a replication source for sending binary log contents to a replica. Daemon This thread is internal to the server, not a thread that services a client connection.

5.5.3.1 Thread Pool Elements

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

To identify them, use this query: SELECT * FROM performance_schema.setup_instruments WHERE NAME LIKE '%thread_pool%'; For more information, see Chapter 25, MySQL Performance Schema. MySQL Enterprise Thread Pool comprises these elements: A plugin ...

5.5.3.2 Thread Pool Installation

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

This section describes how to install MySQL Enterprise Thread Pool. For general information about installing plugins, see Section 5.5.1, “Installing and Uninstalling Plugins”. To be usable by the server, the plugin library file must be located ...

5.5.3.3 Thread Pool Operation

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

When the thread group selects a queued statement for execution, it first looks in the high-priority queue, then in the low-priority queue. The thread pool consists of a number of thread groups, each of which manages a set of client connections. As ...

5.5.3.4 Thread Pool Tuning

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

Assuming that the TP_THREAD_GROUP_STATS table is enabled, you can use the following query to determine the fraction of executed statements that stalled: SELECT SUM(STALLED_QUERIES_EXECUTED) / SUM(QUERIES_EXECUTED) FROM ... This section provides ...

B.3.3.7 Time Zone Problems

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

If you have a problem with SELECT NOW() returning values in UTC and not your local time, you have to tell the server your current time zone. This should be done for the environment in which the server runs (for example, in mysqld_safe or ...

8.2.4.2 Optimizing UPDATE Statements

https://dev.mysql.com/doc/refman/5.7/en/update-optimization.html

An update statement is optimized like a SELECT query with the additional overhead of a write. The speed of the write depends on the amount of data being updated and the number of indexes that are updated. Another way to get fast updates is to delay ...

6.2.16 Setting Account Resource Limits

https://dev.mysql.com/doc/refman/5.7/en/user-resources.html

This older method of accounting may be selected by starting the server with the --old-style-user-limits option. One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero ...

Displaying 831 to 840 of 847 total results