MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 421 to 430 of 431 total results

https://dev.mysql.com/doc/refman/9.7/en/sys-sys-config.html

First, modify the value in the table itself: mysql> UPDATE sys.sys_config SET value = 'OFF' WHERE variable = 'debug'; Second, to also ensure that procedure invocations within the current session use the changed value from the table, set the ... This ...

10.11.2 Table Locking Issues

https://dev.mysql.com/doc/refman/9.7/en/table-locking.html

In this case, the second SELECT statement in the preceding scenario would execute before the UPDATE statement, and would not wait for the first SELECT to finish. InnoDB tables use row-level locking so that multiple sessions and applications can ...

15.2.16 TABLE Statement

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

TABLE is a DML statement which returns rows and columns of the named table. Given the existence of a table named t, the following two statements produce identical output: TABLE t; SELECT * FROM t; You can order and limit the number of rows produced ...

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.3 Thread Pool Operation

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

For each thread group, a maximum of one statement per 10ms (100 per second) is moved from the low-priority queue to the high-priority queue. The thread pool consists of a number of thread groups, each of which manages a set of client connections.

13.2.5 Automatic Initialization and Updating for TIMESTAMP and DATETIME

https://dev.mysql.com/doc/refman/9.7/en/timestamp-initialization.html

If a TIMESTAMP or DATETIME column definition includes an explicit fractional seconds precision value anywhere, the same value must be used throughout the column definition. TIMESTAMP and DATETIME columns can be automatically initialized and updated ...

14.3 Type Conversion in Expression Evaluation

https://dev.mysql.com/doc/refman/9.7/en/type-conversion.html

If the two values have the same JSON type, a second level of comparison occurs using type-specific rules. When an operator is used with operands of different types, type conversion occurs to make the operands compatible. For example, MySQL ...

15.2.17 UPDATE Statement

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

For example, the following statement sets col1 to one more than its current value: UPDATE t1 SET col1 = col1 + 1; The second assignment in the following statement sets col2 to the current (updated) col1 value, not the original col1 value. UPDATE is ...

2.1.2 Which MySQL Version and Distribution to Install

https://dev.mysql.com/doc/refman/9.7/en/which-version.html

When preparing to install MySQL, decide which version and distribution format (binary or source) to use. First, decide whether to install from an LTS series like MySQL 9.7, or install from an Innovation series like MySQL 26.7. Both tracks include ...

22.5.5 Connection Compression with X Plugin

https://dev.mysql.com/doc/refman/9.7/en/x-plugin-connection-compression.html

X Plugin supports compression of messages sent over X Protocol connections. Connections can be compressed if the server and the client agree on a mutually supported compression algorithm. Enabling compression reduces the number of bytes sent over ...

Displaying 421 to 430 of 431 total results