Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-page-compression.html
ALTER TABLE t1 COMPRESSION="zlib"; OPTIMIZE TABLE t1; Disabling Page Compression To disable page compression, set COMPRESSION=None using ALTER TABLE. Page Compression Limitations and Usage Notes Page compression is disabled if the file system block ... InnoDB supports page-level compression for tables that reside in file-per-table ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-transaction-isolation-levels.html
Because gap locking is disabled, phantom row problems may occur, as other sessions can insert new rows into the gaps. Transaction isolation is one of the foundations of database processing. Isolation is the I in the acronym ACID; the isolation ...
https://dev.mysql.com/doc/refman/8.4/en/internal-locking.html
At times, it may be more efficient to disable deadlock detection and rely on the innodb_lock_wait_timeout setting for transaction rollback when a deadlock occurs. If there are holes, concurrent inserts are disabled but are enabled again ... This ...
https://dev.mysql.com/doc/refman/8.4/en/internal-temporary-tables.html
temptable_max_mmap = 0 disables allocation from memory-mapped files, effectively disabling their use, regardless of the value of temptable_use_mmap. In some cases, the server creates internal temporary tables while processing statements. The server ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-configurator-workflow-server.html
You may disable TCP/IP Networking to permit local host connections only. If a port number is in use already, you will see the error icon () next to the default value and Next is disabled until you provide a new port number. This option is less ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-statistics.html
Alternatively, to disable histogram statistics, use ANALYZE TABLE to drop them. A different method of disabling histogram statistics is to turn off the condition_fanout_filter flag of the optimizer_switch system variable (although this may disable ... The column_statistics data dictionary table stores histogram statistics about column values, for use by the optimizer in constructing query execution ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-functions.html
(These remarks also apply to PS_CURRENT_THREAD_ID().) Disabling the thread_instrumentation consumer disables statistics from being collected and aggregated at the thread level, but has no effect on PS_THREAD_ID(). If the Performance Schema itself is ... MySQL includes built-in SQL functions that format or retrieve Performance Schema data, and that may be used as equivalents for the corresponding sys schema stored ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-memory-summary-tables.html
The memory/performance_schema/ instruments are built in, always enabled, and cannot be disabled at startup or runtime. Operation counts help to understand or tune the overall pressure the server is putting on the memory allocator, which has an ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-digests.html
Warning Setting the max_digest_length system variable to zero disables digest production, which also disables server functionality that requires digests. To disable the age-based part of the resampling policy, set ... The MySQL server is capable of ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-auto-positioning.html
Disabling the SOURCE_AUTO_POSITION option again causes the replica to revert to file-based replication; this means that, when GTID_ONLY=ON, some positions may be marked as invalid, in which case you must also specify both SOURCE_LOG_FILE and ...