Search Results
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/refman/8.4/en/partitioning-types.html
However, it is not difficult in MySQL to create partitioning schemes based on DATE, TIME, or DATETIME columns, or based on expressions making use of such columns. When partitioning by KEY or LINEAR KEY, you can use a DATE, TIME, or DATETIME column ... This section discusses the types of partitioning which are available in MySQL ...
https://dev.mysql.com/doc/internals/en/innodb-overview.html
The chart below shows the three parts of a physical record. Name Size Field Start Offsets (F*1) or (F*2) bytes Extra Bytes 6 bytes Field Contents depends on content Legend: The letter 'F' stands for 'Number Of Fields'. The meaning of the parts is ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-incremental-load.html
| | | | Warning: Executing the generated script may alter column definitions and secondary engine flags in the schema | | | | Using SQL_MODE: ...If a subsequent call to Auto Parallel Load includes tables that are not yet loaded, then Auto Parallel ... Available as of MySQL 9.0.0, Lakehouse Incremental Load allows you to refresh the data in an external ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-sles-repo.html
For example, to enable the Innovation track on SLES 15: $> sudo zypper modifyrepo -e mysql-innovation-community $> sudo zypper modifyrepo -e mysql-tools-innovation-community You should only enable a subrepository for one release series at any time.
https://dev.mysql.com/doc/internals/en/optimizer-features-to-trace.html
Some features in the optimizer can be invoked many times during statement optimization and execution, and thus can make the trace grow beyond reason. They are: Greedy search: with a N-table join, this could explore factorial(N) plans Range ...
https://dev.mysql.com/doc/workbench/en/wb-preferences-others.html
Timeouts Migration Connection Timeout: [60] Maximum time to wait before a connection is aborted. Others Allow more than one instance of MySQL Workbench to run By default, only one instance of MySQL Workbench can be running at the same time. For ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-basic-delete.html
It performs the deletion using a single NdbOperation within a transaction, and handles errors using NdbError. You can verify afterwards that the row was deleted by running the read example (Section 2.5.1.3, “NDB API Basic Reading Example”), or ... This example shows deleting a row from a table already created and populated previously (see Section 2.5.1.2, “NDB API Basic Insertion ...
https://dev.mysql.com/doc/connectors/en/connector-j-config-failover.html
This, however, may lead to unexpected results: for example, if the driver is connected to the primary host with read/write access mode and it fails-over to a secondary host in read-only mode, further attempts to issue data-changing queries will ...A ...A connection using failover support works just like a standard connection: the client does not experience any disruptions in the failover ...
https://dev.mysql.com/doc/connector-j/en/connector-j-config-failover.html
This, however, may lead to unexpected results: for example, if the driver is connected to the primary host with read/write access mode and it fails-over to a secondary host in read-only mode, further attempts to issue data-changing queries will ...A ...A connection using failover support works just like a standard connection: the client does not experience any disruptions in the failover ...