Search Results
https://dev.mysql.com/doc/workbench/en/wb-create-new-table.html
Create a new table by double-clicking the Add Table icon in the Physical Schemas panel, as the next figure shows. This action opens the table editor docked at the bottom of the application. You can undock or dock this editor in exactly the same way ...
https://dev.mysql.com/doc/internals/en/general-trace-structure.html
A trace follows closely the actual execution path: there is a join-preparation object, a join-optimization object, a join-execution object, for each JOIN. Query transformations (IN->EXISTS, outer join to inner join...), simplifications (elimination ...
https://dev.mysql.com/doc/internals/en/logging-transactions.html
It is not always possible to log correctly in statement format when both transactional and nontransactional tables are used in the same transaction. Statements that do an implicit commit (that is, most but not all DDL, and some utility commands) are ...
https://dev.mysql.com/doc/x-devapi-userguide/en/setting-the-current-schema.html
A default schema for a session can be specified using the schema attribute in the URI-like connection string or key-value pairs when opening a connection session. The Session class getDefaultSchema() method returns the default schema for the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-load-progress.html
The time required to load a table into MySQL HeatWave depends on data size. You can monitor load progress by issuing the following query, which returns a percentage value indicating load progress. mysql> SELECT VARIABLE_VALUE FROM ...
https://dev.mysql.com/doc/refman/8.4/en/merge-table-problems.html
The following are known problems with MERGE tables: MERGE child tables are locked through the parent table. If the parent is a temporary table, it is not locked, and thus the child tables are also not locked; this means that parallel use of the ...
https://dev.mysql.com/doc/refman/8.4/en/mrr-optimization.html
Reading rows using a range scan on a secondary index can result in many random disk accesses to the base table when the table is large and not stored in the storage engine's cache. With the Disk-Sweep Multi-Range Read (MRR) optimization, MySQL ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-installation-source-unix-macos.html
To build Connector/ODBC from source on macOS, follow the same instructions given for Section 5.4.5, “Building Connector/ODBC from a Source Distribution on Unix”. Notice that iODBC is the default ODBC library used when building Connector/ODBC on ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-installation-source-unix-macos.html
To build Connector/ODBC from source on macOS, follow the same instructions given for Section 4.5, “Building Connector/ODBC from a Source Distribution on Unix”. Notice that iODBC is the default ODBC library used when building Connector/ODBC on ...
https://dev.mysql.com/doc/internals/en/optimizer-trace-system-variable.html
The optimizer_trace system variable has these on/off switches: enabled: allows to enable/disable tracing one_line: if on, the trace will have no whitespace; it's unreadable for humans but readable for JSON parsers (they ignore whitespace); the only ...