Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-thread_concurrency.html
In situations where it is helpful to minimize context switching between threads, InnoDB can use a number of techniques to limit the number of concurrently executing operating system threads (and thus the number of requests that are processed at any ...Threads waiting for locks are not counted in the number of concurrently executing ...
https://dev.mysql.com/doc/internals/en/ensuring-compatibility-of-future-binary-log-versions.html
However, as indicated earlier, v1-format files can be recognized from the initial event in the file, by a type code of START_EVENT_V3 and an event length less than 75. The v4 format description event is designed so that it can handle future format ...
https://dev.mysql.com/doc/workbench/en/wb-preferences-ssh.html
Figure 3.17 Preferences: SSH Timeouts SSH Connect Timeout: [10] SSH connect timeout interval in seconds. SSH Read Write Timeout: [5] SSH read and write timeout interval in seconds. SSH Command Execution log: [104857600] The maximum file size that is ... The following figure shows the preference options that apply to SSH items, such as ...Use the following options ...
https://dev.mysql.com/doc/workbench/en/wb-migration-overview.html
Provides an opportunity to review the changes, for editing and correcting errors in the migrated objects. If there are errors, you can return to the previous step and correct them, and retry the target creation. The Migration Wizard performs the ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-interface-usage.html
To prepare and execute a statement, an application follows these steps: Create a prepared statement handler with mysql_stmt_init(). You can repeat the mysql_stmt_execute() to re-execute the statement by changing parameter values in the respective ...To prepare the statement on the server, call mysql_stmt_prepare() and pass it a string containing the SQL ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-transactions.html
The resulting read is as consistent as a committed read by primary key, returning the last committed value at the time the row is read. A duplicate key or similar error causes the entire transaction to be rolled back. Important When executing a LOAD ... A number of limitations exist in NDB Cluster with regard to the handling of ...
https://dev.mysql.com/doc/internals/en/memory-allocation-mysql-server.html
Things that are needed a longer time should be alllocated with my_malloc() or through another MEMROOT. The basic logic to use: All things that are used only for the duration of a query are allocated in THD::mem_root through sql_alloc() or ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-3-0.html
This fix leverages the JDBC 4 DatabaseMetaData methods to return parameter information only from the procedure or function of interest, so that statements are executed without errors. (Bug #19531305, Bug #73774) Setting a very large value for query ...It was due to an integer overflow, which is now avoided by changing the timeout value's data type from Integer to ...
https://dev.mysql.com/doc/workbench/en/wb-catalog-palette.html
The Catalog Tree palette shows all the schemas that are present in the Physical Schemas section of the MySQL Model page. Expand the view of the objects contained in a specific schema by clicking the > button to the left of the schema name. This ...
https://dev.mysql.com/doc/x-devapi-userguide/en/database-connection-example.html
The code that is needed to connect to a MySQL document store looks a lot like the traditional MySQL connection code, but now applications can establish logical sessions to MySQL server instances running the X Plugin. Sessions are produced by the ...