Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-mysql-firewall-users-table.html
The MYSQL_FIREWALL_USERS table provides a view into the in-memory data cache for MySQL Enterprise Firewall. It lists names and operational modes of registered firewall account profiles. It is used in conjunction with the mysql.firewall_users system ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-mysql-firewall-whitelist-table.html
The MYSQL_FIREWALL_WHITELIST table provides a view into the in-memory data cache for MySQL Enterprise Firewall. It is used in conjunction with the mysql.firewall_whitelist system table that provides persistent storage of firewall data; see MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-autocommit-commit-rollback.html
Grouping DML Operations with Transactions By default, connection to the MySQL server begins with autocommit mode enabled, which automatically commits every SQL statement as you execute it. If autocommit mode is enabled, each SQL statement forms a ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-benefits.html
It is very fast to reference the primary key columns in WHERE clauses, ORDER BY clauses, GROUP BY clauses, and join operations. InnoDB tables have the following benefits: If the server unexpectedly exits because of a hardware or software issue, ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-best-practices.html
Group sets of related DML operations into transactions by bracketing them with START TRANSACTION and COMMIT statements. Specify a primary key for every table using the most frequently queried column or columns, or an auto-increment value if there is ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-space.html
The pages are grouped into extents of size 1MB for pages up to 16KB in size (64 consecutive 16KB pages, or 128 8KB pages, or 256 4KB pages). The data files that you define in the configuration file using the innodb_data_file_path configuration ...
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 ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-single-multi.html
Operations all using the same specific LOCK clause, that you want to either succeed or fail as a group. Before the introduction of online DDL, it was common practice to combine many DDL operations into a single ALTER TABLE statement. Because each ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-ro-txn.html
InnoDB can avoid the overhead associated with setting up the transaction ID (TRX_ID field) for transactions that are known to be read-only. A transaction ID is only needed for a transaction that might perform write operations or locking reads such ...
https://dev.mysql.com/doc/refman/8.4/en/json-search-functions.html
This includes (but is not limited to) SELECT lists, WHERE and HAVING clauses, and ORDER BY and GROUP BY clauses. The functions in this section perform search or comparison operations on JSON values to extract data from them, report whether data ...