Search Results
https://dev.mysql.com/doc/refman/8.4/en/alter-table-partition-operations.html
To verify that the rows were dropped, check the INFORMATION_SCHEMA.PARTITIONS table, using a query such as this one: SELECT PARTITION_NAME, TABLE_ROWS FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_NAME = 't1'; COALESCE PARTITION can be used with a ... Partitioning-related clauses for ALTER TABLE can be used with partitioned tables for repartitioning, to add, drop, discard, import, merge, and split partitions, and to perform partitioning ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-mgmd.html
Management clients can connect to the management server and check the cluster's status. ndb_mgmd does not check for the configuration directory (--configdir) or attempts to create one when --skip-config-cache is used. First, --reload forces the ...
https://dev.mysql.com/doc/refman/8.4/en/xml-functions.html
User variables are weakly checked; variables local to stored programs are strongly checked (see also Bug #26518): User variables (weak checking). Variables using the syntax $@variable_name (that is, user variables) are not checked. Such variables ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-parallel-load-syntax.html
validation performs the same checks as dryrun and also validates external files before loading. auto_enc: Checks if there is enough memory for string column encoding. Checks if there is enough memory on the MySQL node for dictionary-encoded columns ... MySQL 9.0.0 adds support for Lakehouse Incremental Load with the refresh_external_tables option, see: Section 4.3.13.2, “Refresh Data Using Incremental ...
https://dev.mysql.com/doc/refman/8.4/en/can-not-connect-to-server.html
You should also check that the TCP/IP port you are using has not been blocked by a firewall or port blocking service. You should check that there is a MySQL server running, that it has network connections enabled, and that the network port you ... A ...
https://dev.mysql.com/doc/refman/8.4/en/json-validation-functions.html
row *************************** Level: Error Code: 3819 Message: Check constraint 'geo_chk_1' is violated. As before, you can see this by attempting to insert the value into the geo table, then issuing SHOW WARNINGS afterwards: mysql> INSERT INTO ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-maintenance-schedule.html
It is a good idea to perform table checks on a regular basis rather than waiting for problems to occur. One way to check and repair MyISAM tables is with the CHECK TABLE and REPAIR TABLE statements. It is also a good idea to enable automatic MyISAM ...The -s option (short for --silent) causes myisamchk to run in silent mode, printing messages only when errors ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-repair.html
You can also use the CHECK TABLE and REPAIR TABLE statements to check and repair MyISAM tables. See Section 15.7.3.2, “CHECK TABLE Statement”, and Section 15.7.3.5, “REPAIR TABLE Statement”. Before you begin, you should change location to ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-table-info.html
To obtain a description of a MyISAM table or statistics about it, use the commands shown here. The output from these commands is explained later in this section. myisamchk -d tbl_name Runs myisamchk in “describe mode” to produce a description ...
https://dev.mysql.com/doc/refman/8.4/en/stored-programs-logging.html
Unless you implement replication privilege checks (see Section 19.3.3, “Replication Privilege Checks”), the applier thread has full privileges. MySQL does not check that a function declared DETERMINISTIC is free of statements that produce ...