Search Results
https://dev.mysql.com/doc/refman/8.4/en/account-categories.html
By direct grant-table modification using statements such as INSERT and UPDATE. This method is discouraged but possible for users with the appropriate privileges on the mysql system schema that contains the grant tables. Privileges for the mysql ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-setting.html
If a session has open temporary tables, the replication format cannot be changed for the session (SET @@SESSION.binlog_format). If any replication channel has open temporary tables, the replication format cannot be changed globally (SET ... You can ...
https://dev.mysql.com/doc/refman/8.4/en/connection-control-plugin-installation.html
To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 7.6.2, “Obtaining Server Plugin Information”). In particular, installing only the CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS ... This section describes how to install the connection control plugins, CONNECTION_CONTROL and ...
https://dev.mysql.com/doc/refman/8.4/en/crashing.html
The preceding means that normally you should not get corrupted tables unless one of the following happens: The MySQL server or the server host was killed in the middle of an update. Some external program is manipulating data files or index files at ... Each MySQL version is tested on many platforms before it is ...
https://dev.mysql.com/doc/refman/8.4/en/csv-storage-engine.html
When you create a CSV table, the server creates a plain text data file having a name that begins with the table name and has a .CSV extension. When you store data into the table, the storage engine saves it into the data file in comma-separated ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-components-installation.html
MySQL Enterprise Data Masking and De-Identification database table and components are: masking_dictionaries table Purpose: A table that provides persistent storage for masking dictionaries and terms. To set up MySQL Enterprise Data Masking and ...
https://dev.mysql.com/doc/refman/8.4/en/extended-show.html
Some extensions to SHOW statements accompany the implementation of INFORMATION_SCHEMA: SHOW can be used to get information about the structure of INFORMATION_SCHEMA itself. Several SHOW statements accept a WHERE clause that provides more ...
https://dev.mysql.com/doc/refman/8.4/en/full-disk.html
Other threads might be waiting for the table that caused the disk-full condition. Exceptions to the preceding behavior are when you use REPAIR TABLE or OPTIMIZE TABLE or when the indexes are created in a batch after LOAD DATA or after an ALTER TABLE ... This section describes how MySQL responds to disk-full errors (such as “no space left on device”), and to quota-exceeded errors (such as “write failed” or “user block limit ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-benchmarking.html
Since changing the default storage engine only affects newly created tables, run your application installation and setup steps to confirm that everything installs properly, then exercise the application features to make sure the data loading, ... If ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-innodb_cmpmem.html
The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables provide status information about compressed pages that reside in the buffer pool. Please consult Section 17.9, “InnoDB Table and Page Compression” for further information on compressed tables and ...Internal Details InnoDB uses a buddy allocator system to manage memory allocated to pages of various sizes, from 1KB to ...