Search Results
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 ...It ...
https://dev.mysql.com/doc/workbench/en/wb-modifying-layer.html
Choosing "Edit" allows you to edit the layer name and layer background color, and the "Properties Editor" offers additional edit options. When you select a layer on the EER Diagram canvas, its properties are displayed in the Properties palette. The ...In some circumstances, you may want to make a layer ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-foreign-keys-tab.html
The Foreign Keys subtab is organized in much the same fashion as the Indexes subtab and adding or editing a foreign key is similar to adding or editing an index. The following figure shows an example of the Foreign Keys tab. Figure 8.16 The Foreign ...
https://dev.mysql.com/doc/internals/en/transformations-all-any.html
ALL/ANY/SOME use the same algorithm (and the same method of Item_in_subselect) as scalar IN, but use a different function instead of =. ANY/SOME use the same function that was listed after the left expression. This subquery will return the maximum ...ALL uses an inverted function, and all subqueries passed as arguments to Item_func_not_all (Item_func_not_all is a special NOT function used in optimization, see ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbrecord.html
In the latter case, it can be used in conjunction with a bitmap to assist in access. You can also use NdbRecord in conjunction with the PartitionSpec structure to perform scans that take advantage of partition pruning, using ...Decription NdbRecord ...
https://dev.mysql.com/doc/internals/en/position.html
position() is called after each call to rnd_next() if the data needs to be ordered. You can do something like the following to store the position: my_store_ptr(ref, ref_length, current_position); The server uses ref to store data. Purpose Provide ...
https://dev.mysql.com/doc/internals/en/guided-tour-flow.html
The flow works like this: First, the client routines get an SQL statement from a user, allowing edit, performing initial checks, and so on. Then, via the vio routines, the somewhat-massaged statement goes off to the server. Next, the sql routines ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-overview-requirements.html
Where communication latencies between data nodes are expected to be higher than would be expected in a LAN environment (on the order of 100 µs), timeout parameters must be increased to ensure that any allowed periods of latency periods are well ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-change-process.html
To do this, you must specify the data node process using its process ID. This means that change process can be used to change the data node process running on one or more data nodes from the single-threaded data node daemon (ndbd) to the ... change ...
https://dev.mysql.com/doc/ndbapi/en/mgm-functions-management-server-handles.html
ndb_mgm_set_name() Description This function can be used to set a name for the management server handle, which is then reported in the Cluster log. ndb_mgm_set_ignore_sigpipe() Description The MGM API by default installs a signal handler that ...