Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-wait-summary-tables.html
The following sections describe the table I/O and lock wait summary tables: table_io_waits_summary_by_index_usage: Table I/O waits per index table_io_waits_summary_by_table: Table I/O waits per table table_lock_waits_summary_by_table: Table lock ...
https://dev.mysql.com/doc/relnotes/connector-net/en/news-8-0-13.html
(Bug #28343828) EF Core: An invalid syntax error was generated when a new property (defined as numeric, has a default value, and is not a primary key) was added to an entity that already contained a primary-key column with the AUTO_INCREMENT ...This ... Important Changes Functionality Added or Changed Bugs Fixed Important Changes The default value for the SslMode connection option now differs based on the protocol used to make the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-log-statistics.html
A unique index read operation generates 2 primary key read operations—1 for the hidden unique index table, and 1 for the table on which the read takes place. Note A unique index update operation can generate multiple PK read and write operations ... The NDB management client's CLUSTERLOG STATISTICS command can provide a number of useful statistics in its ...
MySQL 8.4 Reference Manual :: 19.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging
https://dev.mysql.com/doc/refman/8.4/en/replication-rbr-safe-unsafe.html
When using statement-based logging, statements flagged as being unsafe generate a warning to this effect. Whenever the 50 most recent ER_BINLOG_UNSAFE_STATEMENT warnings have been generated more than 50 times in any 50-second period, warning ... The ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-statistics.html
This histogram type is created when the number of distinct values in the column is less than or equal to the number of buckets specified in the ANALYZE TABLE statement that generated the histogram. This histogram type is created when the number of ... The column_statistics data dictionary table stores histogram statistics about column values, for use by the optimizer in constructing query execution ...Here is a sample histogram object: { "buckets": [ [ 1, 0.3333333333333333 ], [ 2, 0.6666666666666666 ], [ 3, 1 ] ], "null-values": 0, "last-updated": "2017-03-24 13:32:40.000000", "sampling-rate": 1, "histogram-type": ...
https://dev.mysql.com/doc/connectors/en/connector-python-connectargs.html
The 8.x default values are generated from the latest MySQL Server 8.0 defaults. oci_config_profile "DEFAULT" Used to specify a profile to use from the OCI configuration file that contains the generated ephemeral key pair and security token. A ...
https://dev.mysql.com/doc/connector-python/en/connector-python-connectargs.html
The 8.x default values are generated from the latest MySQL Server 8.0 defaults. oci_config_profile "DEFAULT" Used to specify a profile to use from the OCI configuration file that contains the generated ephemeral key pair and security token. A ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-channel.html
Generate primary key: Allow replicating a CREATE TABLE or ALTER TABLE transaction with no primary keys, and automatically generate a new invisible primary key column while creating a table without primary keys on the target. If you do not specify a ... Creating a Channel 8.5 Creating a Channel Note:In MySQL replication, a replica is a MySQL server that receives changes from another MySQL server (source) and applies the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-gtids.html
If all binary logs on the server were generated using MySQL 5.7.8 or later, binlog_gtid_simple_recovery=TRUE can always safely be used. WARN: all transactions are allowed to violate GTID consistency, but a warning is generated in this case. This is ... The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers ...
https://dev.mysql.com/doc/relnotes/mysql-ai/en/news-9-5-0.html
This feature collects information on the schemas, tables, and columns that you have access to, and then uses a Large Language Model (LLM) to generate an SQL query for the question pertaining to your data. This new feature leverages PyTorch to ...