Search Results
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-user-configurable-system-variables.html
Note:Click on the name of a system varuable in Table 19-7 to see its description in the MySQL Reference Manual. skip_name_resolve OFF sort_buffer_size 262144 sql_mode ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION, NO_ZERO_DATE, NO_ZERO_IN_DATE, ... User-Configurable System Variables 19.5 User-Configurable System Variables Configure the following global system variables with the MySQL HeatWave ...
https://dev.mysql.com/doc/refman/8.4/en/apache.html
There are programs that let you authenticate your users from a MySQL database and also let you write your log files into a MySQL table.
https://dev.mysql.com/doc/refman/8.4/en/binary-varbinary.html
Instead, it causes the binary (_bin) collation for the column character set (or the table default character set if no column character set is specified) to be used, and the column itself stores nonbinary character strings rather than binary byte ...
https://dev.mysql.com/doc/refman/8.4/en/calculating-days.html
CREATE TABLE t1 (year YEAR, month INT UNSIGNED, day INT UNSIGNED); INSERT INTO t1 VALUES(2000,1,1),(2000,1,20),(2000,1,30),(2000,2,2), (2000,2,23),(2000,2,23); The example table contains year-month-day values representing visits by users to the page. 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 ...
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-names.html
For Unicode character sets, the xxx_general_mysql500_ci collations preserve the pre-5.1.24 ordering of the original xxx_general_ci collations and permit upgrades for tables created before MySQL 5.1.24 (Bug #27877). The following table shows the ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin.html
By default, a remote cloning operation removes existing user-created data (schemas, tables, tablespaces) and binary logs from the recipient data directory before cloning data from the donor. Cloned data is a physical snapshot of data stored in ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlocks.html
A deadlock can occur when transactions lock rows in multiple tables (through statements such as UPDATE or SELECT ... FOR UPDATE) in each transaction; create indexes on the columns used in SELECT ... A deadlock is a situation in which multiple ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-redo-log.html
During normal operations, the redo log encodes requests to change table data that result from SQL statements or low-level API calls. If the redo log files occupy less space than the specified value, dirty pages are flushed from the buffer pool to ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-disk-data.html
Disk data objects are subject to the following maximums and minimums: Maximum number of tablespaces: 232 (4294967296) Maximum number of data files per tablespace: 216 (65536) The minimum and maximum possible sizes of extents for tablespace data ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-management.html
See Section 25.6.8.2, “Using The NDB Cluster Management Client to Create a Backup”, for more information. The values of these variables can be read in the mysql client from the output of a SHOW STATUS statement, or by querying either the ...