Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-performance.html
An exclusive metadata lock on the table may be taken briefly during the execution phase of the operation. If the LOCK clause specifies a less restrictive level of locking than is permitted for a particular DDL operation, the statement fails with an ... Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table can proceed while the DDL operation is in ...
https://dev.mysql.com/doc/internals/en/format-description-event.html
create_timestamp (4) -- seconds since Unix epoch when the binlog was created event_header_length (1) -- length of the Binlog Event Header of next events. Note added in MySQL 5.0.0 as replacement for START_EVENT_V3 Payload 2 binlog-version string[50] ... Binlog::FORMAT_DESCRIPTION_EVENT: A format description event is the first event of a binlog for ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-innodb-change-buffer.html
What types of operations modify secondary indexes and result in change buffering? A.16.2. What types of operations modify secondary indexes and result in change buffering? INSERT, UPDATE, and DELETE operations can modify secondary indexes. What is ...How much space does InnoDB use for the change buffer? ...
https://dev.mysql.com/doc/workbench/en/wb-develop-sql-editor-help.html
To view context help, first open the SQL Additions panel by clicking View, Panels, and then Show Secondary Sidebar from the menu. Within the visual SQL Editor, you can select a keyword or function in your query to open a help topic describing its ...
https://dev.mysql.com/doc/connectors/en/connector-net-medium-trust-nongac.html
When deploying a web application to a Shared Hosted environment, where this environment is configured to run all their .NET applications under a partial or medium trust level, you might not be able to install the MySQL Connector/NET library in the ...
https://dev.mysql.com/doc/connector-net/en/connector-net-medium-trust-nongac.html
When deploying a web application to a Shared Hosted environment, where this environment is configured to run all their .NET applications under a partial or medium trust level, you might not be able to install the MySQL Connector/NET library in the ...
https://dev.mysql.com/doc/internals/en/innodb-page-example.html
For this example, I used Borland's TDUMP again, as I did for the earlier chapter on Record Format. This is what a page looked like: Address Values in Hexadecimal Values in ASCII 0D4000: 00 00 00 00 00 00 00 35 FF FF FF FF FF FF FF FF ...
https://dev.mysql.com/doc/refman/8.4/en/trigger-syntax.html
The statement following FOR EACH ROW defines the trigger body; that is, the statement to execute each time the trigger activates, which occurs once for each row affected by the triggering event. MySQL handles errors during trigger execution as ...It ... To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER ...
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. The change ...
https://dev.mysql.com/doc/relnotes/mysql-shell/8.4/en/news-8-4-0.html
The following error was returned: ERROR 1231 (42000): Variable 'wait_timeout' can't be set to the value of '31536000' The load utility attempted to set a maximum value for wait_timeout which is not permitted on Windows platforms. (Bug #36494958) If ...The ociParManifest and ociParExpireTime options were removed from the Dump ...Deprecation and Removal Notes AdminAPI Added or Changed Functionality AdminAPI Bugs Fixed Utilities Added or Changed Functionality Utilities Bugs Fixed Functionality Added or Changed Bugs Fixed Deprecation and Removal Notes The helper command, ...