Search Results
https://dev.mysql.com/doc/refman/8.4/en/check-table.html
option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED } CHECK TABLE checks a table or tables for errors. CHECK TABLE can also check views for problems, such as tables that are referenced in the view definition that no longer exist. To ...The last row has a Msg_type value of status and the Msg_text normally should be ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-check-constraints.html
CREATE TABLE permits the core features of table and column CHECK constraints, for all storage engines. CREATE TABLE permits the following CHECK constraint syntax, for both table constraints and column constraints: [CONSTRAINT [symbol]] CHECK (expr) ...If omitted, MySQL generates a name from the table name, a literal _chk_, and an ordinal number (1, 2, 3, ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-check-options.html
myisamchk supports the following options for table checking operations: --check, -c Command-Line Format --check Check the table for errors. --check-only-changed, -C Command-Line Format --check-only-changed Check only tables that have changed since ...This is the default operation if you specify no option that selects an operation type ...
https://dev.mysql.com/doc/refman/8.4/en/view-check-option.html
The WITH CHECK OPTION clause can be given for an updatable view to prevent inserts to rows for which the WHERE clause in the select_statement is not true. In a WITH CHECK OPTION clause for an updatable view, the LOCAL and CASCADED keywords ...It ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks.html
By default, MySQL replication (including Group Replication) does not carry out privilege checks when transactions that were already accepted by another server are applied on a replica or group member. You can create a user account with the ...The ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-check.html
To check a MyISAM table, use the following commands: myisamchk tbl_name This finds 99.99% of all errors. If you want to check a table, you should normally run myisamchk without options or with the -s (silent) option. It first checks all index ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks-gr.html
You can also use a PRIVILEGE_CHECKS_USER account to secure the two replication applier threads used by Group Replication. To secure one of these threads, stop Group Replication, then issue the CHANGE REPLICATION SOURCE TO statement with the ...The ...
https://dev.mysql.com/doc/internals/en/writing-platform-checks.html
If you modify MySQL source and want to add a new platform check, please read http://www.vtk.org/Wiki/CMake_HowToDoPlatformChecks first. For example, if you add this check to config.cmake: CHECK_FUNCTION_EXISTS(foo HAVE_FOO) Then you must also need ...In MySQL, most of the platform tests are implemented in configure.cmake and the template header file, ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/check-instance-configuration.html
Before creating a production deployment from server instances you need to check that MySQL on each instance is correctly configured. The dba.configureInstance() function does this as part of configuring the instance, but you can optionally use the ...The user which you use to connect to the instance must have suitable privileges, for example as configured at Configuring InnoDB Cluster Administrator Accounts ...
https://dev.mysql.com/doc/refman/8.4/en/checking-gpg-signature-windows.html
The Section 2.1.4.2, “Signature Checking Using GnuPG” section describes how to verify MySQL downloads using GPG. The two most common results look like the following figures; and although the "The data could not be verified." warning looks ...