Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-data-encryption.html
You can set an encryption default for schemas and general tablespaces; this permits DBAs to control whether tables created in those schemas and tablespaces are encrypted. Important Once encrypted tablespaces are created in a MySQL instance, the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-trx-table.html
The INNODB_TRX table provides information about every transaction currently executing inside InnoDB, including whether the transaction is waiting for a lock, when the transaction started, and the SQL statement the transaction is executing, if any.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-actors-table.html
Modifications to the setup_actors table affect only foreground threads created subsequent to the modification, not existing threads. The setup_actors table contains information that determines whether to enable monitoring and historical event ...
https://dev.mysql.com/doc/refman/8.4/en/charset-table.html
The CREATE TABLE and ALTER TABLE statements have optional clauses for specifying the table character set and collation: CREATE TABLE tbl_name (column_list) [[DEFAULT] CHARACTER SET charset_name] [COLLATE collation_name]] ALTER TABLE tbl_name ...If ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-progress-table-update.html
Rename the original mysql.backup_progress table to mysql.backup_progress_old, and the mysql.backup_progress_new table to mysql.backup_progress. Note If you are working with a multiprimary Group Replication setting, make sure these privileges are ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-modifying-tables.html
When an InnoDB table is loaded into MySQL HeatWave Cluster, DDL operations such as ALTER TABLE, RENAME TABLE, TRUNCATE TABLE, and DROP TABLE are permitted. While any of these operations are being executed, queries involving the modified table are ...If you are explicitly trying to use the secondary engine, these queries generate an offload ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-cmpmem-table.html
The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables provide status information on compressed pages within the InnoDB buffer pool. The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables have these columns: PAGE_SIZE The block size in bytes. row ...PAGES_USED ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-error-summary-tables.html
The Performance Schema maintains summary tables for aggregating statistical information about server errors (and warnings). Each error summary table has three columns that identify the error: ERROR_NUMBER is the numeric error value. For example, if ...For a list of server errors, see Server Error Message ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-stages-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored stage event, so there is no system variable for configuring the table size. Of the tables that contain stage event rows, events_stages_current is ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-tables.html
These tables store statement events: events_statements_current: The current statement event for each thread. prepared_statements_instances: Prepared statement instances and statistics The following sections describe the statement event tables. There ...Statement events occur at a high level of the event ...