Search Results
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbtransaction.html
The fact that the transaction did not abort does not necessarily mean that each operation was successful; you must check each operation individually for errors. In the case where a NoDataFound error is a possibility, you must check for it ...A ...
https://dev.mysql.com/doc/refman/8.4/en/pam-pluggable-authentication.html
The plugin uses the PAM service named in the authentication string to check the user credentials and returns 'Authentication succeeded, Username is user_name' or 'Authentication failed'. For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM ...
https://dev.mysql.com/doc/workbench/en/wb-data-modeling-menus.html
You may also select any or all of the following check boxes: Match Case Whole Word Use Regular Expression Search in Comments Search in SQL for Views, SPs etc. Validation (MySQL): Checks the validity of the model using MySQL standards. Check For ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/glossary.html
Performance monitoring involves checking whether queries that are slow or frequently run could be sped up or made less resource-intensive, by examining the EXPLAIN plan to check if the MySQL optimizer has chosen the most efficient ways to process ...
https://dev.mysql.com/doc/refman/8.4/en/change-replication-source-to.html
Values used for SOURCE_HOST and other CHANGE REPLICATION SOURCE TO options are checked for linefeed (\n or 0x0A) characters. You can check the current state of the replication applier thread and replication receiver thread using SHOW REPLICA STATUS.
https://dev.mysql.com/doc/refman/8.4/en/create-table-foreign-keys.html
MySQL requires indexes on foreign keys and referenced keys so that foreign key checks can be fast and not require a table scan. NDB supports deferred checks, and NO ACTION specifies a deferred check; when this is used, constraint checks are not ...
https://dev.mysql.com/doc/mysql-installer/en/mysql-installer-catalog-dashboard.html
To enable the Product Features page where you can customize features, click the related check box (disabled by default). When the Program Shortcut check box is selected, the product appears in the Start menu under the MySQL group. To select products ... This section describes the MySQL Installer product catalog, the dashboard, and other actions related to product selection and ...
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
ENGINE_ATTRIBUTE and SECONDARY_ENGINE_ATTRIBUTE values are not checked by the server, nor are they cleared when the table's storage engine is changed. Indexes, Foreign Keys, and CHECK Constraints Several keywords apply to creation of indexes, ...| ...
https://dev.mysql.com/doc/refman/8.4/en/innochecksum.html
This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored checksum, and reports mismatches, which indicate damaged pages. Because checksum mismatches cause InnoDB to deliberately ...It was originally developed to speed up verifying the integrity of tablespace files after power outages but can also be used after file ...
https://dev.mysql.com/doc/workbench/en/wb-getting-started-tutorial-create-connection.html
Figure 5.3 Getting Started Tutorial - Setup New Connection: MyFirstConnection The default connection values are for a typical local setup, so check them and enter the appropriate values. If you are unsure, click the Test Connection button to check ... This tutorial adds a new connection that can be either an initial connection or an additional ...