Search Results
https://dev.mysql.com/doc/internals/en/logging-transactions-rules-for-non-committing-statements.html
The preliminary rules above, together with the principles for logging format, have been used to construct the following rules. CALL statements are unrolled (see ???TODO: add section about unrolling???), so that each statement executed by the stored ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-handling-errors.html
This program demonstrates handling errors and retrying failed transactions using the NDB API. The source code for this example can be found in storage/ndb/ndbapi-examples/ndbapi_retries/ndbapi_retries.cpp in the NDB Cluster source tree. In this ...
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
By default, MySQL retrieves cached values for those columns from the mysql.index_stats and mysql.table_stats dictionary tables when the columns are queried, which is more efficient than retrieving statistics directly from the storage engine. The ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-microsoft-access.html
Some external articles and tips that may be useful when using Access, ODBC and Connector/ODBC: Read How to Trap ODBC Login Error Messages in Access Optimizing Access ODBC Applications Optimizing for Client/Server Performance Tips for Converting ...
https://dev.mysql.com/doc/internals/en/binlog-formats.html
Queries can be logged in two ways: In statement format: the SQL query is written to the binlog in text. An SQL query that modifies the database will generate one or more events and append them to the binlog. Status of this subsection: Complete but ...
https://dev.mysql.com/doc/internals/en/prepared-stored-reexecution.html
Features of MySQL 4.1 and 5.0 put a new demand on the execution process: prepared statements and stored routines need to reuse the same parsed tree to execute a query many times. So far no easy mechanism that would allow query reexecution using the ...
https://dev.mysql.com/doc/internals/en/preface.html
Trademark Notice Oracle, Java, MySQL, and NetSuite are registered trademarks of Oracle and/or its affiliates. We do hope it illustrates how MySQL programmers work, and how MySQL Server works as a result. GOVERNMENT END USERS: Oracle programs ...We ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlslap.html
Run all the load statements, then run all the queries in the query file with five clients (five times each): mysqlslap --concurrency=5 --iterations=5 --query=query.sql --create=create.sql --delimiter=";" mysqlslap supports the following options, ...
https://dev.mysql.com/doc/workbench/en/wbcopytables.html
wbcopytables is a command-line utility included in MySQL Workbench that enables you to copy table data from a supported source database server to MySQL. It is used by the MySQL Workbench Migration Wizard to copy data after the schema is migrated ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-locking.html
X DevAPI supports MySQL locking through the lockShared() and lockExclusive() methods for the Collection.find() and Table.select() methods. Locking considerations When working with locking modes note the following: autocommit mode means that there ...This enables you to control row locking to ensure safe, transactional document updates on collections and to avoid concurrency problems, for example when using the modify() ...