Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-configurator-cli.html
The error log contains a record of mysqld startup and shutdown times. MySQL Configurator supports GUI (default) and CLI (by passing in --console) modes using the mysql_configurator.exe executable. Executing MySQL Configurator requires a Windows ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-25.html
When a new query shares query execution plan nodes with previously executed queries, the actual statistics collected from previously executed queries are used instead of estimated statistics, which improves query execution plans, cost estimations, ...For example, the following query can now be offloaded to MySQL HeatWave for execution: SELECT DISTINCT a FROM t1 ORDER BY c DESC; (Bug #32583856) Query plan statistics are now collected and stored in a statistics cache when a query is executed in MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-config-file.html
Configuring NDB Cluster requires working with two files: my.cnf: Specifies options for all NDB Cluster executables. This file, with which you should be familiar with from previous work with MySQL, must be accessible by each executable running in ...
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/workbench/en/wb-develop-object-management-inspector.html
The Schema Inspector and Table Inspector each include the ability to analyze and repair tables, and also view table metrics. Schema Inspector Use the Schema Inspector to browse general information from schema objects (shown in the figure that ...
https://dev.mysql.com/doc/internals/en/optimizer-or-relations.html
An ORed search has the form condition1 OR condition2, as in this example: WHERE column1 = 'x' OR column2 = 'y' Here the optimizer's decision is to use a sequential scan. There is also an option to use index merge under such circumstances. See ...
https://dev.mysql.com/doc/internals/en/optimizer-range-join-type.html
Such a change is particularly likely for < and > conditions and multiple-level secondary indexes. Some conditions can work with indexes, but over a (possibly wide) range of keys. The optimizer will use an index (range search) for column1 LIKE 'x%' ...
https://dev.mysql.com/doc/ndbapi/en/mgm-examples-event-logging-dual.html
This example shown in this section illustrates the handling of log events using the MGM API on multiple clusters in a single application. The source code for this program may be found in the NDB Cluster source tree, in the file ...
https://dev.mysql.com/doc/workbench/en/wb-windows-uninstalling.html
The method for uninstalling MySQL Workbench depends on how you installed MySQL Workbench. Removing MySQL Workbench After Installation Using the Installer Package To uninstall MySQL Workbench, do one of the following: From Start, select Settings and ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-reset.html
Otherwise, the command fails, as shown here: mcm> reset DataMemory mycluster; ERROR 3 (00MGR): Illegal syntax You also cannot revert all configuration attributes for a given process type or instance of a process using a single filter specification; ... reset [--sequential-restart] filter_specification_list cluster_name filter_specification_list: filter_specification[,filter_specification][,...] filter_specification: attribute_name[:process_specification][+process_specification]] process_specification: [process_name][:process_id] process_name: {ndb_mgmd|ndbd|ndbmtd|mysqld|ndbapi} This command resets an attribute to its default ...