Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/understanding-automatic-document-ids.html
When using manual document IDs, you must ensure that they do not clash with any IDs that might ever be generated automatically by the server (see Document ID Generation for details), in order to avoid any errors due to primary key duplication. The ... This sections describes in detail how document IDs are generated and how to interpret ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/understanding-automatic-document-ids.html
When using manual document IDs, you must ensure that they do not clash with any IDs that might ever be generated automatically by the server (see Document ID Generation for details), in order to avoid any errors due to primary key duplication. The ... This sections describes in detail how document IDs are generated and how to interpret ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-buffer-page-lru-table.html
ACCESS_TIME An abstract number used to judge the first access time of the page. This can be the name of a clustered index or a secondary index. Querying this table can require MySQL to allocate a large block of contiguous memory, more than 64 bytes ... The INNODB_BUFFER_PAGE_LRU table provides information about the pages in the InnoDB buffer pool; in particular, how they are ordered in the LRU list that determines which pages to evict from the buffer pool when it becomes ...
https://dev.mysql.com/doc/relnotes/connector-cpp/en/news-8-0-17.html
(WL #13133) Configuration Notes The maximum permitted length of host names throughout Connector/C++ has been raised to 255 ASCII characters, up from the previous limit of 60 characters. Applications that expect host names to be a maximum of 60 ...
https://dev.mysql.com/doc/internals/en/capability-negotiation.html
They can agree on: use of status flags use of SQL states for error-codes authentication methods SSL support Compression . To permit an old client to connect to newer servers, the initial handshake contains the MySQL Server version the server's ...
https://dev.mysql.com/doc/refman/8.4/en/using-explain.html
The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. When EXPLAIN is used with an explainable statement, MySQL displays information from the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-all.html
The use of CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP or NOW() as a default value for a timestamp column. Enable explicit_defaults_for_timestamp to use ALTER TABLE and CREATE TABLE statements with Lakehouse tables that have a timestamp column. A ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-redo-log-reader.html
Reads a redo log file, checking it for errors, printing its contents in a human-readable format, or both. Command-Line Format -mbyte # Type Numeric Default Value 0 Minimum Value 0 Maximum Value 15 -mbyte #: Starting megabyte. Command-Line Format ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-navigator-instance-server-logs.html
For each connection, the Administration - Server Logs tab includes additional tabs for the general error logs and the slow logs (if available). Error Log File The following figure shows an example of entries within the Error Log File tab. Figure 6.2 ... The Administration - Server Logs tab displays log information for the MySQL server represented by each connection ...
https://dev.mysql.com/doc/internals/en/binlog-event-header.html
Binlog::EventHeader: Binlog header Payload 4 timestamp 1 event type 4 server-id 4 event-size if binlog-version > 1: 4 log pos 2 flags Fields timestamp (4) -- seconds since unix epoch event_type (1) -- see Binlog Event Type server_id (4) -- server-id ... The binlog event header starts each event and is either 13 or 19 bytes long, depending on the binlog ...