Search Results
https://dev.mysql.com/doc/internals/en/preventing-use-of-optimizer-trace.html
If for some reason, as DBA of a MySQL Server, you wish to prevent all users from seeing traces of their queries, start the server with these options: --maximum-optimizer-trace-max-mem-size=0 --optimizer-trace-max-mem-size=0 This sets the maximum ...
https://dev.mysql.com/doc/internals/en/supporting-transactions.html
This section documents the methods that must be implemented to add support for transactions to a storage engine. Please note that transaction management can be complicated and involve methods such as row versioning and redo logs, which is beyond ...
https://dev.mysql.com/doc/workbench/en/wb-migration-wizard-object-selection.html
Objects discovered by the Reverse Engineer Source stage are made available here. Valid objects include Table, View, and Routine objects, with only the Table objects being selected by default (see the figure that follows). Use the Show Selection ...
https://dev.mysql.com/doc/workbench/en/wb-migration-overview.html
The Migration Wizard performs the following steps when migrating a database to MySQL: Connects to the source RDBMS and retrieves a list of available databases/schemas. Reverse engineers selected database/schemas into a internal representation ...
https://dev.mysql.com/doc/x-devapi-userguide/en/sql-crud-functions.html
The following SQL CRUD functions are available in X DevAPI. Table.insert() The Table.insert() method works like an INSERT statement in SQL. It is used to store data in a relational table in the database. The example assumes that the test schema ...
https://dev.mysql.com/doc/ndbapi/en/mgm-functions-error-handling.html
This section provides information about MGM API functions used for error handling. Each MGM API error is characterised by an error code and an error message. There may also be an error description that provides additional information about the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-autopilot-report-table.html
It contains data from the last execution of Advisor or Auto Parallel Load. Data is only available for the current session and is lost when the session terminates or when the server shuts down. When Advisor or Auto Parallel Load run, they send ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-boolean.html
MySQL can perform boolean full-text searches using the IN BOOLEAN MODE modifier. With this modifier, certain characters have special meaning at the beginning or end of words in the search string. In the following query, the + and - operators ...
https://dev.mysql.com/doc/refman/8.4/en/handler.html
HANDLER tbl_name OPEN [ [AS] alias] HANDLER tbl_name READ index_name { = | <= | >= | < | > } (value1,value2,...) [ WHERE where_condition ] [LIMIT ... ] HANDLER tbl_name READ index_name { FIRST | NEXT | PREV | LAST } [ WHERE where_condition ] [LIMIT ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-select-all.html
ndb_select_all prints all rows from an NDB table to stdout. Usage ndb_select_all -c connection_string tbl_name -d db_name [> file_name] Options that can be used with ndb_select_all are shown in the following table. --connect-retries Command-Line ...