Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-user-attributes-table.html
ATTRIBUTE The user comment, user attribute, or both belonging to the account specified by the USER and HOST columns. The USER_ATTRIBUTES table provides information about user comments and user attributes. The USER_ATTRIBUTES table has these ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-autocommit-commit-rollback.html
Both COMMIT and ROLLBACK release all InnoDB locks that were set during the current transaction. If autocommit mode is enabled, each SQL statement forms a single transaction on its own. By default, MySQL starts the session for each new connection ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool-resize.html
You can configure InnoDB buffer pool size offline or while the server is running. For additional information about configuring buffer pool size online, see Configuring InnoDB Buffer Pool Size Online. When increasing or decreasing ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool.html
Pages in both the new and old sublists age as other pages are made new. The buffer pool is an area in main memory where InnoDB caches table and index data as it is accessed. The buffer pool permits frequently used data to be accessed directly from ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-background.html
You might need to size your buffer pool to accommodate the additional data of both compressed and uncompressed pages, although the uncompressed pages are evicted from the buffer pool when space is needed, and then uncompressed again on the next ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-tuning.html
Database Compression versus Application Compression Decide whether to compress data in your application or in the table; do not use both types of compression for the same data. Most often, the internal optimizations described in InnoDB Data Storage ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-usage.html
After the innodb_file_per_table option is configured, specify the ROW_FORMAT=COMPRESSED clause or KEY_BLOCK_SIZE clause, or both, in a CREATE TABLE or ALTER TABLE statement to create a compressed table in a file-per-table tablespace. Compressed ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression.html
This section provides information about the InnoDB table compression and InnoDB page compression features. The page compression feature is also referred to as transparent page compression. Using the compression features of InnoDB, you can create ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-data-encryption.html
If a table is created with both the COMPRESSION and ENCRYPTION options, compression is performed before tablespace data is encrypted. InnoDB supports data-at-rest encryption for file-per-table tablespaces, general tablespaces, the mysql system ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-dedicated-server.html
When the server is started with --innodb-dedicated-server, InnoDB automatically calculates values for and sets the following system variables: innodb_buffer_pool_size innodb_redo_log_capacity Note innodb_redo_log_capacity supersedes both ...You ...