Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-replication-dashboard-ui-ref.html
Source drill down contents: Node Status: graphs the source load in running connections, queries per second, and the average response time. Replication Configuration: displays all information related to the replication configuration: General Group ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-collections-basic-crud.html
Then, a find operation is executed to search for a specific document from the collection. Working with collections of documents is straightforward when using X DevAPI. The following example shows the basic usage of CRUD operations (see Section 4.3, ...
https://dev.mysql.com/doc/refman/8.4/en/json.html
A maximum of 3 JSON columns per NDB table is supported. MySQL parses any string used in a context that requires a JSON value, and produces an error if it is not valid as JSON. Positions for “at position N” in such error messages are 0-based, but ...The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-debugging-queries.html
Setting Secondary Engine Definition By default, SELECT queries are offloaded to MySQL HeatWave for execution and fall back to the DB System if that is not possible. To force a query to execute on MySQL HeatWave or fail if that is not possible, set ... This topic describes how to debug queries that fail to offload to MySQL HeatWave for ...
https://dev.mysql.com/doc/relnotes/connector-net/en/news-8-0-28.html
(Bug #105209, Bug #33470147) Microseconds specified in a time-span value were calculated incorrectly for prepared statements. (Bug #81586, Bug #23343947) Batch inserts that exceeded the max_allowed_packet value were not processed and skipping the ...
https://dev.mysql.com/doc/internals/en/autotools-plugin-macros.html
If a file named configure is detected in the directory, it will be executed as part of the configure build otherwise it is assumed that there is a Makefile to be built in that directory. If the plugin has been marked as MANDATORY, it will result in ... The following macros enable plugin support in the autotools configuration ...
https://dev.mysql.com/doc/refman/8.4/en/trigger-syntax.html
The statement following FOR EACH ROW defines the trigger body; that is, the statement to execute each time the trigger activates, which occurs once for each row affected by the triggering event. MySQL handles errors during trigger execution as ...It ... To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER ...
https://dev.mysql.com/doc/refman/8.4/en/check-table.html
A table is reported as needing a rebuild if it contains old temporal columns in pre-5.6.4 format (TIME, DATETIME, and TIMESTAMP columns without support for fractional seconds precision). If CHECK TABLE encounters errors in InnoDB tables or indexes, ...option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED } CHECK TABLE checks a table or tables for ...CHECK ...
https://dev.mysql.com/doc/x-devapi-userguide/en/collection-find.html
The execute() function triggers the actual execution of the find() operation. myColl.add({ name:'John', favorNums: [1, 3, 5, 7, 9] }).execute(); myColl.find("favorNums[0] = 1").execute(); //Returns the document just added } The wildcard tokens * and ... The find(SearchConditionStr) function is for searching documents in a collection, similar to the SELECT statement for an SQL ...
https://dev.mysql.com/doc/internals/en/event-classes-and-types.html
Internally, the server uses C++ classes to represent binary log events. Type codes are associated with subclasses because class instance contents are written to binary or relay logs or are sent over the network from master to slave. In those ...