MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 451 to 460 of 463 total results

30.4.3.22 The processlist and x$processlist Views

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

The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. They provide more complete information than the SHOW PROCESSLIST statement and the INFORMATION_SCHEMA PROCESSLIST table, ...

30.4.3.28 The schema_table_lock_waits and x$schema_table_lock_waits Views

https://dev.mysql.com/doc/refman/9.7/en/sys-schema-table-lock-waits.html

These views display which sessions are blocked waiting on metadata locks, and what is blocking them. For additional information, see the description of the Performance Schema metadata_locks table at Section 29.12.13.3, “The metadata_locks ...

30.4.2.1 The sys_config Table

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

This table contains sys schema configuration options, one row per option. Configuration changes made by updating this table persist across client sessions and server restarts. The sys_config table has these columns: variable The configuration ...

10.11.2 Table Locking Issues

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

InnoDB tables use row-level locking so that multiple sessions and applications can read from and write to the same table simultaneously, without making each other wait or producing inconsistent results. For this storage engine, avoid using the LOCK ...

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

The thread pool consists of a number of thread groups, each of which manages a set of client connections. As connections are established, the thread pool assigns them to thread groups in round-robin fashion. The thread pool exposes system variables ...

13.2.5 Automatic Initialization and Updating for TIMESTAMP and DATETIME

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

TIMESTAMP and DATETIME columns can be automatically initialized and updated to the current date and time (that is, the current timestamp). For any TIMESTAMP or DATETIME column in a table, you can assign the current timestamp as the default value, ...

14.3 Type Conversion in Expression Evaluation

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

When an operator is used with operands of different types, type conversion occurs to make the operands compatible. For example, MySQL automatically converts strings to numbers as necessary, and vice versa. mysql> SELECT 1+'1'; -> 2 mysql> SELECT ...

15.2.17 UPDATE Statement

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

UPDATE is a DML statement that modifies rows in a table. An UPDATE statement can start with a WITH clause to define common table expressions accessible within the UPDATE. Single-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] table_reference SET ...

Displaying 451 to 460 of 463 total results