Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-data-compression.html
If data storage size is not a concern, disable data compression by setting the rapid_compression session variable to OFF before loading data: mysql> SET SESSION rapid_compression=OFF; As of MySQL version 8.3.0, the default option is AUTO which ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-show-disabled-consumers.html
Example mysql> CALL sys.ps_setup_show_disabled_consumers(); +----------------------------------+ | disabled_consumers | +----------------------------------+ | events_stages_current | | events_stages_history | | events_stages_history_long | | ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-show-disabled-instruments.html
Displays all currently disabled Performance Schema instruments. This might be a long list. Parameters None. Example mysql> CALL sys.ps_setup_show_disabled_instruments()\G *************************** 1. row *************************** ...
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/mysql-enterprise-backup/8.4/en/backup-special-options.html
--safe-replica-backup-timeout=SECONDS For a replication setup, the option specifies the time (in seconds) mysqlbackup will wait for Replica_open_temp_tables to become “0” (which happens when no temporary tables are open) to complete the backup ... These options are for backing up database servers that play specific roles in replication, or contain certain kinds of data that require special care in backing ...
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/firewall-reference.html
mysql_firewall_mode Command-Line Format --mysql-firewall-mode[={OFF|ON}] System Variable mysql_firewall_mode Scope Global Dynamic Yes SET_VAR Hint Applies No Type Boolean Default Value ON Whether MySQL Enterprise Firewall is enabled (the default) or ...The firewall-database.firewall_groups table lists names and operational modes of registered firewall group ...
https://dev.mysql.com/doc/refman/8.4/en/commit.html
To disable autocommit mode explicitly, use the following statement: SET autocommit=0; After disabling autocommit mode by setting the autocommit variable to zero, changes to transaction-safe tables (such as those for InnoDB or NDB) are not made ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysqlsh.html
Default is 0 (first device) --port TCP/IP port number for connection --py, --python Start in Python mode --pyc Execute a Python command and quit. Note that with the option ssl-mode=preferred, the SSL connection is not guaranteed, so a connection ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-sql-modes.html
While the performance impact is not that great, if you do not require such validation (perhaps your application already handles all of this), then MySQL gives you the option of leaving strict mode disabled. What is the default server SQL mode when ...This makes it easier to use MySQL in different environments and to use MySQL together with other database ...