MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 331 to 340 of 346 total results

https://dev.mysql.com/doc/refman/9.7/en/stored-programs-logging.html

The binary log contains information about SQL statements that modify database contents. This information is stored in the form of “events” that describe the modifications. (Binary log events differ from scheduled event stored objects.) The ...

15.2.15 Subqueries

https://dev.mysql.com/doc/refman/9.7/en/subqueries.html

All subquery forms and operations that the SQL standard requires are supported, as well as a few features that are MySQL-specific. Here is an example of a subquery: SELECT * FROM t1 WHERE column1 = (SELECT column1 FROM t2); In this example, SELECT * ...

2.9.3 Testing the Server

https://dev.mysql.com/doc/refman/9.7/en/testing-server.html

After the data directory is initialized and you have started the server, perform some simple tests to make sure that it works satisfactorily. This section assumes that your current location is the MySQL installation directory and that it has a bin ...

7.6.3.4 Thread Pool Tuning

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

This section provides guidelines on determining the best configuration for thread pool performance, as measured using a metric such as transactions per second. Of chief importance is the number of thread groups in the thread pool, which can be set ...

13.2.3 The TIME Type

https://dev.mysql.com/doc/refman/9.7/en/time.html

MySQL retrieves and displays TIME values in 'hh:mm:ss' format (or 'hhh:mm:ss' format for large hours values). The hours part may be so large because the TIME type can be used not only to represent a time of day (which must be less than 24 hours), ...

11.4 User-Defined Variables

https://dev.mysql.com/doc/refman/9.7/en/user-variables.html

You can store a value in a user-defined variable in one statement and refer to it later in another statement. This enables you to pass values from one statement to another. User variables are written as @var_name, where the variable name var_name ...

8.3.1 Configuring MySQL to Use Encrypted Connections

https://dev.mysql.com/doc/refman/9.7/en/using-encrypted-connections.html

Several configuration parameters are available to indicate whether to use encrypted connections, and to specify the appropriate certificate and key files. See Section 20.6.2, “Securing Group Communication Connections with Secure Socket Layer ...

2.5.9 Managing MySQL Server with systemd

https://dev.mysql.com/doc/refman/9.7/en/using-systemd.html

If you install MySQL from a source distribution on a platform that uses systemd, obtain systemd support for MySQL by configuring the distribution using the -DWITH_SYSTEMD=1 CMake option. The following discussion covers these topics: Overview of ...

13.3.5 The VECTOR Type

https://dev.mysql.com/doc/refman/9.7/en/vector.html

A VECTOR is a structure that can hold up to a specified number of entries N, defined as shown here: VECTOR(N) Each entry is a 4-byte (single-precision) floating-point value. To declare a VECTOR column of the default length, define it as VECTOR with ...

27.6.3 Updatable and Insertable Views

https://dev.mysql.com/doc/refman/9.7/en/view-updatability.html

Some views are updatable and references to them can be used to specify tables to be updated in data change statements. That is, you can use them in statements such as UPDATE, DELETE, or INSERT to update the contents of the underlying table. Derived ...

Displaying 331 to 340 of 346 total results