Search Results
https://dev.mysql.com/doc/refman/8.4/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. But because only one session can write to a table at any one time, for best performance ... 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 ...
https://dev.mysql.com/doc/refman/8.4/en/cursor-restrictions.html
For example, if a client executes a query but is only interested in the first row, the remaining rows are not transferred. Initially, this is a MEMORY table, but is converted to a MyISAM table when its size exceeds the minimum value of the ...
https://dev.mysql.com/doc/refman/8.4/en/hash-joins.html
When the memory required for a hash join exceeds the amount available, MySQL handles this by using files on disk. It is possible to control whether hash joins are employed using one of the BNL and NO_BNL optimizer hints, or by setting ...
https://dev.mysql.com/doc/mysql-installer/en/mysql-installer-setup.html
Choosing a Setup Type Path Conflicts Check Requirements MySQL Installer Configuration Files When you download MySQL Installer for the first time, a setup wizard guides you through the initial installation of MySQL products. As the following figure ...MySQL Installer detects existing MySQL products installed on the host during its initial setup and adds them to the list of products to be ...
https://dev.mysql.com/doc/refman/8.4/en/nested-loop-joins.html
MySQL executes joins between tables using a nested-loop algorithm or variations on it. Nested-Loop Join Algorithm Nested-Loop Join Algorithm A simple nested-loop join (NLJ) algorithm reads rows from the first table in a loop one at a time, passing ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-routines-table.html
DATETIME_PRECISION For stored function temporal return values, the fractional seconds precision. CHARACTER_MAXIMUM_LENGTH For stored function string return values, the maximum length in characters. CHARACTER_OCTET_LENGTH For stored function string ... The ROUTINES table provides information about stored routines (stored procedures and stored ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-thread-group-state-table.html
OLDEST_QUEUED How long in milliseconds the oldest queued statement has been waiting for execution. There is at most one thread ready to start executing if the active threads become stalled or blocked. There can be a maximum of four connection ...
https://dev.mysql.com/doc/relnotes/connector-python/en/news-8-0-13.html
max_idle_time: maximum number of milliseconds a connection can be idle in the queue before being closed; integer >= 0 and defaults to 0 (infinite). queue_timeout: maximum number of milliseconds a request will wait for a connection to become ...This ...max_size: maximum number of connections available in the pool; positive integer and defaults to ...
https://dev.mysql.com/doc/relnotes/connector-cpp/en/news-8-0-20.html
If compression is required, compression algorithm negotiation occurs as for preferred mode, but if no common algorithm is available, the connection request terminates with an error. To avoid CPU inefficiency, data packets are not compressed even ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-learn-with-genai.html
The table used to train a model cannot exceed 10 GB in size, 100 million rows, or 1017 columns."} | ... Available as of MySQL 9.4.0, the NL2ML routine enables you to learn about MySQL HeatWave AutoML by leveraging Oracle Cloud Infrastructure ...