Search Results
https://dev.mysql.com/doc/internals/en/transactions-life-cycle.html
In such situations there is little the server can do and the only option is to roll back transactions in all other participating engines, and send an error to the user. The remaining rare cases, when the server explicitly must commit a statement ...
https://dev.mysql.com/doc/ndbapi/en/mccj-overview-clusterj-object-models.html
It also stores parameters regarding how to connect to the cluster, including connection delays and timeouts. In addition, it enables the user to mark a transaction as being rollback-only, which makes it possible for a component that is not ... This ...
https://dev.mysql.com/doc/workbench/en/wb-model-reporting.html
The DBDoc - Model Reporting dialog is found by opening a model, selecting Model from the menu, and then DBDoc - Model Reporting. Note This functionality is only available in the MySQL Workbench Commercial Editions. Use the DBDoc- Model Reporting ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/parameter-binding.html
Parameter Type Syntax Example Allowed in CRUD operations Allowed in SQL strings Anonymous ? 'age > ?' no yes Named :<name> 'age > :age' yes no The following example shows how to use the bind() function before an execute() function. // ... Instead of ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/parameter-binding.html
Parameter Type Syntax Example Allowed in CRUD operations Allowed in SQL strings Anonymous ? 'age > ?' no yes Named :<name> 'age > :age' yes no The following example shows how to use the bind() function before an execute() function. # one bind() per ... Instead of using values directly in an expression string it is good practice to separate values from the expression ...
https://dev.mysql.com/doc/internals/en/com-query-response.html
ProtocolText::Resultset: A packet containing a Protocol::LengthEncodedInteger column_count column_count * Protocol::ColumnDefinition packets If the CLIENT_DEPRECATE_EOF client capability flag is not set, EOF_Packet One or more ...Image description ...
https://dev.mysql.com/doc/refman/8.4/en/string-type-syntax.html
The effective maximum length of a VARCHAR is subject to the maximum row size (65,535 bytes, which is shared among all columns) and the character set used. For example, utf8mb3 characters can require up to three bytes per character, so a VARCHAR ...
https://dev.mysql.com/doc/refman/8.4/en/range-optimization.html
On the right side of the IN() predicate, row constructors contain only runtime constants, which are either literals or local column references that are bound to constants during execution. The interval on the second line uses only one key part. The ... The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value ...
MySQL Enterprise Monitor 8.0 Release Notes :: Changes in MySQL Enterprise Monitor 8.0.0 (2018-04-19)
https://dev.mysql.com/doc/relnotes/mysql-monitor/8.0/en/news-8-0-0.html
The emailed links were incorrect for events generated by the SQL Statement Generates Warnings or Errors and Average Statement Execution Time Advisor advisors. (Bug #27731494) The Time Span and Graph From: labels did not display multibyte characters ... Important It is not possible to upgrade to MySQL Enterprise Monitor 8.0 from versions preceding MySQL Enterprise Monitor ...
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, ...