Search Results
https://dev.mysql.com/doc/refman/8.4/en/binary-log-mixed.html
Like all other unsafe statements, this generates a warning if binlog_format = STATEMENT. For information about how replication treats sql_mode, see Section 19.5.1.39, “Replication and Variables”. In MySQL 8.4, operations on temporary tables are ... When running in MIXED logging format, the server automatically switches from statement-based to row-based logging under the following conditions: When a function contains ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-auto-increment-handling.html
Under the consecutive lock mode, InnoDB can avoid using table-level AUTO-INC locks for “simple insert” statements where the number of rows is known in advance, and still preserve deterministic execution and safety for statement-based replication. This lock mode ensures that, in the presence of INSERT statements where the number of rows is not known in advance (and where auto-increment numbers are assigned as the statement progresses), all auto-increment values assigned by any “INSERT-like” statement are consecutive, and operations are safe for statement-based ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-metrics-table.html
SET GLOBAL innodb_monitor_disable = [counter-name|module_name|pattern|all]; innodb_monitor_reset: Resets counter values to zero. The innodb_monitor_disable and innodb_monitor_reset variables are supported on the command line only. Counters shown in ... The INNODB_METRICS table provides information about InnoDB performance and resource-related ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-usage.html
Enabling or Disabling the Firewall Scheduling Firewall Cache Reloads Assigning Firewall Privileges Firewall Concepts Registering Firewall Group Profiles Registering Firewall Account Profiles Monitoring the Firewall Migrating Account Profiles to ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-disable-instrument.html
Disables Performance Schema instruments with names that contain the argument. Example Disable a specific instrument: mysql> CALL sys.ps_setup_disable_instrument('wait/lock/metadata/sql/mdl'); +-----------------------+ | summary | ...Parameters ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-disable-thread.html
Given a connection ID, disables Performance Schema instrumentation for the thread. Example Disable a specific connection by its connection ID: mysql> CALL sys.ps_setup_disable_thread(225); +-------------------+ | summary | +-------------------+ | ...This is a value of the type given in the PROCESSLIST_ID column of the Performance Schema threads table or the Id column of SHOW PROCESSLIST ...
https://dev.mysql.com/doc/refman/8.4/en/glossary.html
It is safe to use for all settings of the innodb_autoinc_lock_mode option. The results of transactions are durable: once a commit operation succeeds, the changes made by that transaction are safe from power failures, system crashes, race conditions, ... These terms are commonly used in information about the MySQL database ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-disable-consumer.html
Disables Performance Schema consumers with names that contain the argument. Example Disable all statement consumers: mysql> CALL sys.ps_setup_disable_consumer('statement'); +----------------------+ | summary | +----------------------+ | Disabled 4 ...Parameters consumer VARCHAR(128): The value used to match consumer names, which are identified by using %consumer% as an operand for a LIKE pattern ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-disable-background-threads.html
Produces a result set indicating how many background threads were disabled. Example mysql> CALL sys.ps_setup_disable_background_threads(); +--------------------------------+ | summary | +--------------------------------+ | Disabled 24 background ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-update-ha.html
Enable or Disable High Availability 3.4.2 Enable or Disable High Availability See Enabling and Disabling High Availability for instructions.