MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 1221 to 1230 of 1233 total results

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

B.3.3.7 Time Zone Problems

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

This should be done for the environment in which the server runs (for example, in mysqld_safe or mysql.server). 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 ...

13.1.34 TRUNCATE TABLE Statement

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

This is true even for MyISAM and InnoDB, which normally do not reuse sequence values. Logically, TRUNCATE TABLE is similar to a DELETE statement that deletes all rows, or a sequence of DROP TABLE and CREATE TABLE statements. To achieve high ...

8.2.4.2 Optimizing UPDATE Statements

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

If you do this often, it is very important to use OPTIMIZE TABLE occasionally. 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 ...

13.8.4 USE Statement

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

This statement requires some privilege for the database or some object within it. USE db_name The USE statement tells MySQL to use the named database as the default (current) database for subsequent statements. The named database remains the ...

5.5.5 Version Tokens

https://dev.mysql.com/doc/refman/5.7/en/version-tokens.html

This is a signal to the application that it should seek a different server in the required state to receive the SQL statement. MySQL includes Version Tokens, a feature that enables creation of and synchronization around server tokens that ...

23.5.4 The View WITH CHECK OPTION Clause

https://dev.mysql.com/doc/refman/5.7/en/view-check-option.html

Before MySQL 5.7.6, WITH CHECK OPTION testing works like this: With LOCAL, the view WHERE clause is checked, but no underlying views are checked. The WITH CHECK OPTION clause can be given for an updatable view to prevent inserts to rows for which ...

2.3.4.3 Selecting a MySQL Server Type

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

It is necessary to enable this variable explicitly because some users have experienced problems with shutting down the MySQL server when named pipes were used. The following table shows the available servers for Windows in MySQL 5.7. Binary ...

2.3.4.9 Testing The MySQL Installation

https://dev.mysql.com/doc/refman/5.7/en/windows-testing.html

In this case, start mysqld with the skip_name_resolve system variable enabled and use only localhost and IP addresses in the Host column of the MySQL grant tables. (Be sure that an account exists that specifies an IP address or you may not be able ...

19.4.2.1 X Plugin Option and Variable Reference

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

This table provides an overview of the command options, system variables, and status variables provided by X Plugin.

Displaying 1221 to 1230 of 1233 total results