Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-conversion.html
To convert a binary or nonbinary string column to use a particular character set, use ALTER TABLE. The following statement accomplishes this: ALTER TABLE t MODIFY col1 CHAR(50) CHARACTER SET utf8mb4; Conversion may be lossy if the column contains ...Suppose that a table t has a binary column named col1 defined as ...For successful conversion to occur, one of the following conditions must apply: If the column has a binary data type (BINARY, VARBINARY, BLOB), all the values that it contains must be encoded using a ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-import.html
db_name is the name of the database where the table into which to import the data is found; file_name is the name of the CSV file from which to read the data; this must include the path to this file if it is not in the current directory. The name of ... ndb_import imports CSV-formatted data, such as that produced by mysqldump --tab, directly into NDB using the NDB ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-info.html
Methods of obtaining such information include the following: Using the SHOW CREATE TABLE statement to view the partitioning clauses used in creating a partitioned table. Using the SHOW TABLE STATUS statement to determine whether a table is ... This ...
https://dev.mysql.com/doc/refman/8.4/en/replica-logs-status.html
The connection metadata repository is written to the slave_master_info table in the mysql system schema, and the applier metadata repository is written to the slave_relay_log_info table in the mysql system schema. A warning message is issued if ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/bugs.backup.html
Here is a list of limitations of MySQL Enterprise Backup: In some cases, backups of non-transactional tables such as MyISAM tables could contain additional uncommitted data. If autocommit is turned off, and both InnoDB tables and non-transactional ... Please refer to the MySQL Enterprise Backup 8.4 Release Notes for a list of fixed bugs for ...
https://dev.mysql.com/doc/refman/8.4/en/extensions-to-ansi.html
Use of CHANGE col_name, DROP col_name, or DROP INDEX, IGNORE or RENAME in ALTER TABLE statements. Use of multiple ADD, ALTER, DROP, or CHANGE clauses in an ALTER TABLE statement. Be warned that if you use them, your code is most likely not portable ... MySQL Server supports some extensions that you are not likely to find in other SQL ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/performance-advisors-ref.html
These features also require the use of the ROW_FORMAT=[DYNAMIC|COMPRESSED] in CREATE TABLE and ALTER TABLE statements. This advisor has no configurable thresholds and is used to populate the graphs and tables of the Database File I/O report. For ...
https://dev.mysql.com/doc/refman/8.4/en/symbolic-links-to-tables.html
For InnoDB tables, use the alternative technique explained in Section 17.6.1.2, “Creating Tables Externally” instead. The same is true for the ALTER TABLE, OPTIMIZE TABLE, and REPAIR TABLE statements. These table symlink operations are not ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-cluster-metric-mysqlserver-ddlstatementactivity-category.html
Table 8.3 DDL Statement Activity Metrics Target NameName of the OEM TargetAlter DB (Delta) The total number of ALTER DATABASE statements executed. Alter Table (Delta) The total number of ALTER TABLE statements executed. Alter Tablespace (Delta) The ...Alter DB Upgrade (Delta) The total number of ALTER DATABASE ... Lists the DDL ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-mysqlserver-ddlstatementactivity-category.html
Table 6.5 DDL Statement Activity Metrics NameDescriptionAlter DB (Delta) The total number of ALTER DATABASE statements executed. Alter Table (Delta) The total number of ALTER TABLE statements executed. Alter Tablespace (Delta) The total number of ...