Search Results
https://dev.mysql.com/doc/workbench/en/wb-performance-explain.html
MySQL Workbench provides all of the EXPLAIN formats for executed queries including the raw extended JSON, traditional format, and visual query plan. Visual Explain Usage To view a visual explain execution plan, execute your query from the SQL editor ... The visual explain feature generates and displays a visual representation of the MySQL EXPLAIN statement by using extended information available in the extended JSON ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-restore.html
--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving up. --connect-retry-delay Command-Line Format --connect-retry-delay=# Type ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/replication-advisor-ref.html
However, the slave notices the network outage only after receiving no data from the master for slave_net_timeout seconds. Default frequency 06:00:00 Default auto-close enabled yes Binary Log File Count Exceeds Specified Limit The binary log captures ...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/refman/8.4/en/string-type-syntax.html
The effective maximum length of a VARCHAR is subject to the maximum row size (65,535 bytes, which is shared among all columns) and the character set used. For example, utf8mb3 characters can require up to three bytes per character, so a VARCHAR ...
https://dev.mysql.com/doc/internals/en/transactions-life-cycle.html
In such situations there is little the server can do and the only option is to roll back transactions in all other participating engines, and send an error to the user. The remaining rare cases, when the server explicitly must commit a statement ...
https://dev.mysql.com/doc/ndbapi/en/mccj-overview-clusterj-object-models.html
It also stores parameters regarding how to connect to the cluster, including connection delays and timeouts. In addition, it enables the user to mark a transaction as being rollback-only, which makes it possible for a component that is not ... This ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-compliance-administration-standard-rules.html
It is a framework for executing SQL commands at specific times or at regular intervals. In-Memory Temporary Table Size Limited By Maximum Heap Table Size Description If the space required to build a temporary table exceeds either tmp_table_size or ...The binary log enables point-in-time recovery, preventing data loss during a disaster recovery ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-connections-pages-locking.html
Blocking Trx Age How long the blocking transaction has been executing, as a TIME value. Blocking Trx Started The time at which the blocking transaction started. Wait Age How long the lock has been waited for, as a TIME value. Waiting Trx Age How ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-innodbconfiguration-category.html
Flush Log At Timeout Write and flush the logs every N seconds. Io Capacity The maximum number of I/O operations per second that InnoDB will perform. Lock Wait Timeout The timeout in seconds an InnoDB transaction may wait for a row lock before giving ...Buffer Pool Load At Startup Enabled Specifies that, on MySQL server startup, the InnoDB buffer pool is automatically warmed up by loading the same pages it held at an earlier ...
https://dev.mysql.com/doc/internals/en/item-class.html
MySQL's Item class is defined in .../sql/item.h, and its subclasses are defined in .../sql/item*.h (that is, in item.h, item_cmpfunc.h, item_func.h, item_geofunc.h, item_row.h, item_strfunc.h, item_subselect.h, item_sum.h, item_timefunc.h). To us, ...