Search Results
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-dbsystem-create.html
The number is a compact representation of the subnet mask; for example, /24 is equivalent to 255.255.255.0, where 24 is the number of bits in the binary representation of 255.255.255.0 (11111111.11111111.11111111.00000000). Creating a DB System 3.3 ...
https://dev.mysql.com/doc/connector-j/en/connector-j-server-authentication.html
Server authentication via server certificate verification is enabled when the Connector/J connection property sslMode is set to VERIFY_CA or VERIFY_IDENTITY. If sslMode is not set, server authentication via server certificate verification is ...
https://dev.mysql.com/doc/refman/8.4/en/adding-collation.html
Some of these can be added to MySQL without recompiling: Simple collations for 8-bit character sets. Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of MySQL. The MySQL 8.4 server ...
https://dev.mysql.com/doc/refman/8.4/en/alter-logfile-group.html
(Bug #13116514, Bug #16104705, Bug #62858) On 32-bit systems, the maximum supported value for INITIAL_SIZE is 4294967296 (4 GB). ALTER LOGFILE GROUP logfile_group ADD UNDOFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This ...
https://dev.mysql.com/doc/refman/8.4/en/alter-tablespace.html
On 32-bit systems, the maximum supported value for INITIAL_SIZE is 4294967296 (4 GB). It can be used to add a new data file to, or to drop a data file from an NDB tablespace. It can also be used to rename an NDB Cluster Disk Data tablespace, rename ...
https://dev.mysql.com/doc/refman/8.4/en/backup-policy.html
A full backup (a snapshot of the data at a point in time) can be done in MySQL with several tools. For example, MySQL Enterprise Backup can perform a physical backup of an entire instance, with optimizations to minimize overhead and avoid disruption ...
https://dev.mysql.com/doc/refman/8.4/en/calculating-days.html
The following example shows how you can use the bit group functions to calculate the number of days per month a user has visited a Web page. CREATE TABLE t1 (year YEAR, month INT UNSIGNED, day INT UNSIGNED); INSERT INTO t1 ...
https://dev.mysql.com/doc/refman/8.4/en/charset-binary-set.html
For example: _binary 'a' The _binary introducer is permitted for hexadecimal literals and bit-value literals as well, but unnecessary; such literals are binary strings by default. The binary character set is the character set for binary strings, ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-ucs2.html
The ucs2 character set has these characteristics: Supports BMP characters only (no support for supplementary characters) Uses a fixed-length 16-bit encoding and requires two bytes per character. Note The ucs2 character set is deprecated; expect it ...
https://dev.mysql.com/doc/refman/8.4/en/choosing-types.html
This enables you to do all calculations with 64-bit integers and then convert results back to floating-point values as necessary. For optimum storage, you should try to use the most precise type in all cases. For example, if an integer column is ...