Search Results
https://dev.mysql.com/doc/refman/8.4/en/identifier-length.html
The following table describes the maximum length for each type of identifier. For constraint definitions that include no constraint name, the server internally generates a name derived from the associated table name. For example, internally ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-page-compression.html
Enabling Page Compression To enable page compression, specify the COMPRESSION attribute in the CREATE TABLE statement. For example: CREATE TABLE t1 (c1 INT) COMPRESSION="zlib"; You can also enable page compression in an ALTER TABLE statement. R-tree ... InnoDB supports page-level compression for tables that reside in file-per-table ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-maintenance-schedule.html
One way to check and repair MyISAM tables is with the CHECK TABLE and REPAIR TABLE statements. Alternatively, if you can stop the mysqld server for a while, change location into the data directory and use this command while the server is stopped: $> ... It is a good idea to perform table checks on a regular basis rather than waiting for problems to ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-stages-current-table.html
The nesting event for a stage event is usually a statement event. The events_stages_current table has these indexes: Primary key on (THREAD_ID, EVENT_ID) TRUNCATE TABLE is permitted for the events_stages_current table. The table stores one row per ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-firewall-group-allowlist-table.html
RULE A normalized statement indicating an acceptable statement pattern for the profile. The firewall_group_allowlist table provides a view into the in-memory data cache for MySQL Enterprise Firewall. It is used in conjunction with the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-firewall-groups-table.html
The value is NULL, or a non-NULL account that has the format user_name@host_name: If the value is NULL, the firewall records allowlist rules for statements received from any account that is a member of the group. If the value is non-NULL, the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-persisted-variables-table.html
The persisted_variables table provides an SQL interface to the mysqld-auto.cnf file that stores persisted global system variable settings, enabling the file contents to be inspected at runtime using SELECT statements. Variables are persisted using ...The table contains a row for each persisted system variable in the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-applier-configuration-table.html
Parameters stored in the table can be changed at runtime with the CHANGE REPLICATION SOURCE TO statement. This is escaped so that it can be copied into an SQL statement to execute individual transactions. The replication_applier_configuration table ... This table shows the configuration parameters that affect transactions applied by the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tls-channel-status-table.html
Connection interface TLS properties are set at server startup, and can be updated at runtime using the ALTER INSTANCE RELOAD TLS statement. For the main interface, similar status information can be obtained using these statements: SHOW GLOBAL ...
https://dev.mysql.com/doc/refman/8.4/en/replica-connection-thread-states.html
Changing master Changing replication source The thread is processing a CHANGE REPLICATION SOURCE TO statement. Rebuilding the index on master dump table This state occurs after Reading master dump table data. These thread states occur on a replica ...