Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-reference.html
The following table summarizes all available Performance Schema tables. For greater detail, see the individual table descriptions. Table 29.1 Performance Schema Tables Table Name Description accounts Connection statistics per client account ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/upgrade-mysql-clusterset.html
Navigate to the directory and issue this command: ./start.sh If the path to the new router has changed, you must update the start.sh shell script to reflect the path. On a Unix system, if you used the optional --directory bootstrap option, a ... To ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-boolean.html
| +----+-----------------------+-------------------------------------+ Note In implementing this feature, MySQL uses what is sometimes referred to as implied Boolean logic, in which + stands for AND - stands for NOT [no operator] implies OR Boolean ...In the following query, the + and - operators indicate that a word must be present or absent, respectively, for a match to ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-ndbd.html
ApiFailureHandlingTimeout: Maximum time for API node failure handling before escalating. RedoOverCommitCounter: When RedoOverCommitLimit has been exceeded this many times, transactions are aborted, and operations are handled as specified by ...Data ...Arbitration: How arbitration should be performed to avoid split-brain issues in event of node ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-component-functions.html
mask_canada_sin(str [, mask_char]) Masks a Canada Social Insurance Number (SIN) and returns the number with all meaningful digits replaced by 'X' characters. mask_iban(str [, mask_char]) Masks an International Bank Account Number (IBAN) and returns ...Nine digits grouped in pattern: xxx-xxx-xxx ('-' is any separator ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-releases.html
Support: An LTS series follows the Oracle Lifetime Support Policy, which includes 5 years of premier support and 3 years of extended support. They describe available options to perform in-place updates (that replace binaries with the latest ... The ...Behavior: These releases only contain necessary fixes to reduce the risks associated with changes in the database software's ...
https://dev.mysql.com/doc/ndbapi/en/ndb-event.html
Event::setDurability() Description This method sets an event's durability—that is, its lifetime and scope. The new version of the API also simplifies error detection and handling. These changes are realized in the NDB API by implementing a number ...Event Class Overview Event::addEventColumn() Event::addEventColumns() Event::addTableEvent() Event Constructor Event::EventDurability Event::EventReport Event::getDurability() Event::getEventColumn() Event::getName() Event::getNoOfEventColumns() Event::getObjectStatus() Event::getObjectVersion() Event::getObjectId() Event::getReport() Event::getTable() Event::getTableEvent() Event::getTableName() Event::mergeEvents() Event::setDurability() Event::setReport() Event::setName() Event::setTable() Event::TableEvent Event Class Overview Parent class NdbDictionary Child classes None Description This class represents a database event in an NDB ...
https://dev.mysql.com/doc/refman/8.4/en/docker-mysql-getting-started.html
For example: $> docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES 4cd4129b3211 container-registry.oracle.com/mysql/community-server:latest "/entrypoint.sh mysq…" 8 seconds ago Up 7 seconds (health: starting) 3306/tcp, 33060-33061/tcp ...Other platforms are not supported, and users using these MySQL Docker images on them are doing so at their own ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-transaction-isolation-levels.html
If the row matches (must be updated), MySQL reads the row again and this time InnoDB either locks it or waits for a lock on it. Isolation is the I in the acronym ACID; the isolation level is the setting that fine-tunes the balance between ...InnoDB ... Transaction isolation is one of the foundations of database ...
https://dev.mysql.com/doc/refman/8.4/en/order-by-optimization.html
This section describes when MySQL can use an index to satisfy an ORDER BY clause, the filesort operation used when an index cannot be used, and execution plan information available from the optimizer about ORDER BY. An ORDER BY with and without ...