Search Results
https://dev.mysql.com/doc/refman/8.4/en/gtid-functions.html
row *************************** GTID_SUBSET('3E11FA47-71CA-11E1-9E33-C80AA9429562:23', '3E11FA47-71CA-11E1-9E33-C80AA9429562:21-57'): 1 1 row in set (0.00 sec) mysql> SELECT GTID_SUBSET('3E11FA47-71CA-11E1-9E33-C80AA9429562:23-25', -> ... The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-object-filtering.html
The OBJECT_TYPE column indicates the type of object to which a row applies. (Tables in the INFORMATION_SCHEMA database are not instrumented regardless of the contents of setup_objects; the row for information_schema.% simply makes this default ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-metrics-table.html
row *************************** NAME: undo_tablespaces_active METER: mysql.inno METRIC_TYPE: ASYNC GAUGE COUNTER NUM_TYPE: INTEGER UNIT: DESCRIPTION: Number of active undo tablespaces, including implicit and explicit tablespaces ... The ...
https://dev.mysql.com/doc/refman/8.4/en/semijoins-antijoins.html
For an inner join between two tables, the join returns a row from one table as many times as there are matches in the other table. Assuming that class_num is a primary key in the class table, duplicate suppression is possible by using SELECT ... A ...
https://dev.mysql.com/doc/refman/8.4/en/sys-statement-performance-analyzer.html
statement_performance_analyzer.limit, @sys.statement_performance_analyzer.limit The maximum number of rows to return for views that have no built-in limit. mysql> CALL sys.statement_performance_analyzer('delta', 'mydb.tmp_digests_ini', ... Creates a ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/news-8-4-1.html
It was removed due to a critical issue that could stop the server from restarting following the creation of a very large number of tables (8001 or more). (Bug #36453684) NDB Replication: The binary log index purge callback was skipped for the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-sql.html
When loading multiple compressed files, it is best to prepare files of similar size, and in the range of 80-120 MB each. HEADER: Adds a header row to the CSV file based on the selected option (ON or OFF). If HEADER and IGNORE are both specified, ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
With the mysql_info() C API function, you can find out how many rows were copied by ALTER TABLE. To change the InnoDB table to use compressed row-storage format: ALTER TABLE t1 ROW_FORMAT = COMPRESSED; The ENCRYPTION clause enables or disables ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-usage.html
row *************************** id: 1 pattern: SELECT ? pattern_database: NULL replacement: SELECT ? + 1 enabled: YES message: NULL pattern_digest: NULL normalized_pattern: NULL The rule specifies a pattern template indicating which SELECT ... To ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-buffer-pool-tables.html
The InnoDB INFORMATION_SCHEMA buffer pool tables provide buffer pool status information and metadata about the pages within the InnoDB buffer pool. The InnoDB INFORMATION_SCHEMA buffer pool tables include those listed below: mysql> SHOW TABLES FROM ...