Search Results
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-functionality-catalog-schema.html
At the same time SCHEMA was often used as a synonym for a MySQL Database. Many relational databases reference CATALOG and SCHEMA in ways that do not directly correspond to what MySQL refers to as a database. Historically with MySQL ODBC Driver, ...
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-implementation-notes.html
MySQL Connector/J, as a rigorous implementation of the JDBC API, passes all of the tests in the publicly available version of Oracle's JDBC compliance test suite. This section gives details on an interface-by-interface level about implementation ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-change-buffer.html
Merging cached changes at a later time, when affected pages are read into the buffer pool by other operations, avoids substantial random access I/O that would be required to read secondary index pages into the buffer pool from disk. During this ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-storage-engine.html
Table 18.2 MyISAM Storage Engine Features Feature Support B-tree indexes Yes Backup/point-in-time recovery (Implemented in the server, rather than in the storage engine.) Yes Cluster database support No Clustered indexes No Compressed data Yes ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-prepared-statements-instances-table.html
This is accessed through the MySQL C API and maps onto underlying server commands as shown in the following table. C API Function Corresponding Server Command mysql_stmt_prepare() COM_STMT_PREPARE mysql_stmt_execute() COM_STMT_EXECUTE ... The ...
https://dev.mysql.com/doc/refman/8.4/en/show-events.html
In its simplest form, SHOW EVENTS lists all of the events in the current schema: mysql> SELECT CURRENT_USER(), SCHEMA(); +----------------+----------+ | CURRENT_USER() | SCHEMA() | +----------------+----------+ | jon@ghidora | myschema | ... SHOW ...
https://dev.mysql.com/doc/refman/8.4/en/replication-delayed.html
MySQL supports delayed replication such that a replica server deliberately executes transactions later than the source by at least a specified amount of time. In MySQL 8.4, the method of delaying replication depends on two timestamps, ...This ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/replication-advisor-ref.html
The binary log enables replication as well as point-in-time recovery, preventing data loss during a disaster recovery situation. Default frequency 06:00:00 Default auto-close enabled no Binary Log Row Based Images Excessive As of MySQL Server 5.6, ...By default, the server logs the length of the event as well as the event itself and uses this information to verify that the event was written ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-data-import-details.html
Last updated: The date and time when the Data Import Details were last updated. Created: The date and time when the data import operation started. Update GTID set (for MySQL dump file imports only): For data that contain GTIDs, how the gtid_executed ... Data Import Details 7.2.1.3.1 Data Import Details Use the Console to view the Data Import ...
https://dev.mysql.com/doc/refman/8.4/en/bnl-bka-optimization.html
In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join buffer. Incremental buffers also provide a savings in processing time due to the reduction in copying time. For information ...The BKA algorithm supports inner join, outer join, and semijoin operations, including nested outer ...