Search Results
https://dev.mysql.com/doc/internals/en/packet-ERR_Packet.html
This packet signals that an error occurred. It contains a SQL state value if CLIENT_PROTOCOL_41 is enabled. Payload Type Name Description int<1> header [ff] header of the ERR packet int<2> error_code error-code if capabilities & CLIENT_PROTOCOL_41 ...
https://dev.mysql.com/doc/refman/8.4/en/command-line-options.html
For example, the following command tells mysqladmin to ping the server 1024 times, sleeping 10 seconds between each ping: mysqladmin --count=1K --sleep=10 ping When specifying file names as option values, avoid the use of the ~ shell metacharacter.
https://dev.mysql.com/doc/refman/8.4/en/using-spatial-indexes.html
| +-----+---------------------------------------------------------------+ 20 rows in set (0.00 sec) Use EXPLAIN to check the way this query is executed: mysql> SET @poly = -> 'Polygon((30000 15000, 31000 15000, 31000 16000, 30000 16000, 30000 ...The ... The optimizer investigates whether available spatial indexes can be involved in the search for queries that use a function such as MBRContains() or MBRWithin() in the WHERE ...
https://dev.mysql.com/doc/refman/8.4/en/xa.html
In essence, this extends ACID properties “up a level” so that multiple ACID transactions can be executed in concert as components of a global operation that also has ACID properties. The process for executing a global transaction uses two-phase ... Support for XA transactions is available for the InnoDB storage ...
https://dev.mysql.com/doc/workbench/en/wb-model-editor.html
When the Model Editor is executed from the home screen, MySQL Workbench displays the MySQL Model tab. Figure 9.3 The MySQL Model Page The Description Editor and User Types List (with the User Types and History secondary tabs) are contained within ...The MySQL Model page has three main panels, as shown in the following ...
https://dev.mysql.com/doc/workbench/en/wb-scripting-shell.html
The Workbench Scripting Shell provides a means for entering and executing Python scripts. The shell can also be used to explore the current Workbench Generic RunTime (GRT) facilities. Through the use of the scripting shell, MySQL Workbench can ...
https://dev.mysql.com/doc/internals/en/predefined-option-sets.html
It might be handy to specify a predefined set of options and do some compiler flag adjustments by passing just a single option to cmake. Assuming that we want to include the embedded library and exclude the ARCHIVE storage engine from the build, ...
https://dev.mysql.com/doc/internals/en/replication.html
This is done by the client thread that executed the query that modified the database. Status of this section: up to date 2009-10-21 This chapter describes MySQL replication principles, rules, and code, as it is supposed to work in version 5.1. The ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-fetch-fields.html
Returns a list of tuples, one tuple per column Raises a MySQLInterfaceError exception for any MySQL error returned by the MySQL server. Syntax: field_info = ccnx.fetch_fields() Fetches column information for the active result set.
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-basic-connect.html
If it is unable to connect to the management or to the data nodes, it prints an appropriate error and exits. This example, which can also be found in storage/ndb/ndbapi-examples/ndbapi_basic/ndbapi_basic_connect.cpp, demonstrates the use of ...