Search Results
https://dev.mysql.com/doc/refman/8.4/en/string-types.html
The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. For information about storage requirements of the string data types, see Section 13.7, “Data Type Storage Requirements”. For descriptions of functions that ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-type-syntax.html
The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and YEAR. For example: CREATE TABLE t1 (t TIME(3), dt DATETIME(6), ts TIMESTAMP(0)); The fsp value, if given, must be in the range 0 to 6. Note The ...For the DATE and DATETIME range descriptions, “supported” means that although earlier values might work, there is no ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/formatting-returnedvalues-reference.html
To properly evaluate the data returned by the data collection, assign attributes to the returned values. To correct this, you must stop the agent, edit the type definition, rename the attribute, and restart the agent. Attributes are defined using ...
https://dev.mysql.com/doc/connectors/en/connector-net-ref-entityframework.html
BackoffAlgorithmErr1040 Backoff algorithm customized for the MySQL error code 1040 - Too many connections. BackoffAlgorithmErr1205 Backoff algorithm customized for the MySQL error code 1205 - Lock wait timeout exceeded; try restarting transaction.
https://dev.mysql.com/doc/connector-net/en/connector-net-ref-entityframework.html
BackoffAlgorithmErr1040 Backoff algorithm customized for the MySQL error code 1040 - Too many connections. BackoffAlgorithmErr1205 Backoff algorithm customized for the MySQL error code 1205 - Lock wait timeout exceeded; try restarting transaction.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-add-node.html
This section describes how to add NDB Cluster data nodes “online”—that is, without needing to shut down the cluster completely and restart it as part of the process. Important Currently, you must add new data nodes to an NDB Cluster as part ...In addition, it is not possible to change the number of fragment replicas (or the number of nodes per node group) ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-numeric.html
Information in the database is likely to be stored in a more compact format than in the text file, so accessing it involves fewer disk accesses. If you are using numeric data, it is faster in many cases to access information from a database (using a ... For unique IDs or other values that can be represented as either strings or numbers, prefer numeric columns to string ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-datadictionary-category.html
Lists the Data Dictionary configuration metrics and provides a brief description of each. Table 7.9 Data Dictionary Configuration Metrics NameDescriptionSchema Definition Cache Defines the number of schema definition objects that can be kept in the ...Stored Program Definition Cache Defines the number of stored program and event definition objects that can be kept in the dictionary object ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-load-progress.html
The time required to load a table into MySQL HeatWave depends on data size. You can monitor load progress by issuing the following query, which returns a percentage value indicating load progress. mysql> SELECT VARIABLE_VALUE FROM ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-unload-tables.html
To unload a table manually, specify the SECONDARY_UNLOAD clause in an ALTER TABLE statement: mysql> ALTER TABLE tbl_name SECONDARY_UNLOAD; The following example unloads the data_table_1 table. mysql> ALTER TABLE tbl_name SECONDARY_UNLOAD PARTITION ...Before You Begin Load structured data using Lakehouse Auto Parallel Load or ...Unload Tables Unloading a table from MySQL HeatWave may be necessary to replace an existing table, to ...