Search Results
https://dev.mysql.com/doc/workbench/en/wb-eer-color-key.html
Color connection lines within EER diagrams provide quick visual information about how the tables in your model relate. Existing connection lines are highlighted when you use a pointer device to hover on different database objects. The following ...
https://dev.mysql.com/doc/workbench/en/wb-view-overview-physical-schemas.html
The Physical Schemas panel of the MySQL Model page shows the active schemas and the objects that they contain. Expand and contract the Physical Schemas panel by clicking the arrow for the panel. MySQL Workbench provides the details of each physical ...
https://dev.mysql.com/doc/internals/en/multi-resultset.html
01 31 00 0c 3f 00 01 00 00 00 08 81 00 00 00 00 .1..?........... 05 00 00 03 fe 00 00 0a 00 02 00 00 04 01 31 05 ..............1. see the EOF_Packet: 05 00 00 03 fe 00 00 0a 00 with its status-flag being 0a the 2nd resultset: 01 00 00 06 01 17 00 00 ...
https://dev.mysql.com/doc/refman/8.4/en/version-tokens-reference.html
Timeout values are nonnegative integers representing the time in seconds to wait to acquire locks before timing out with an error. mysql> SELECT version_tokens_lock_exclusive('lock1', 'lock2', 10); ...(It is not an error to delete nonexisting ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-performance-page-statements.html
The Statements dashboard displays information on the various types of statement executed on the monitored server. Table 5.7 Statements Performance Page Regions GraphDescriptionDML Statements Graphs the number and type of DML statements. The ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-parallel-load.html
Load Data Using Auto Parallel Load First, run Auto Parallel Load in dryrun mode to check for errors and warnings and to inspect the generated load script. If Auto Parallel Load fails with an error, inspect the errors with a query to the ... You can ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/news-8-4-4.html
Replica skip error functionality was also affected in that it attempted to skip only the error that occurred when a transaction was committed a second time. Handling of DBTC and API state alignment errors has been improved by this set of fixes, as ...(Bug #37201922) NDB Replication: The replication applier normally retries temporary errors occurring while applying ... MySQL NDB Cluster 8.4.4 is a new LTS release of NDB 8.4, based on MySQL Server 8.4 and including ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-functions.html
(You can consider the function execution timestamp and random number seed as implicit inputs that are identical on the source and replica.) The FOUND_ROWS() and ROW_COUNT() functions are not replicated reliably using statement-based replication. To ... Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and LOAD_FILE() functions are replicated without change and thus do not work reliably on the replica unless row-based replication is ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-prepared-statements-instances-table.html
COUNT_EXECUTE, SUM_TIMER_EXECUTE, MIN_TIMER_EXECUTE, AVG_TIMER_EXECUTE, MAX_TIMER_EXECUTE Aggregated statistics for executions of the prepared statement. MAX_CONTROLLED_MEMORY Reports the maximum amount of controlled memory used by a prepared ...C ... The Performance Schema provides instrumentation for prepared statements, for which there are two protocols: The binary ...
https://dev.mysql.com/doc/internals/en/huffman-compression.html
On the other hand, the theoretical maximum compression is 1:8 (12.5%) in this case. In his article from 1952 Huffman proved that his algorithm uses the least possible number of bits to encode a sequence of messages. The number of bits assigned to ...