Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-temp-table-info-table.html
The INNODB_TEMP_TABLE_INFO table provides information about user-created InnoDB temporary tables that are active in an InnoDB instance. The INNODB_TEMP_TABLE_INFO table is created when first queried, exists only in memory, and is not persisted to ...It does not provide information about internal InnoDB temporary tables used by the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-transaction-isolation-levels.html
A user can change the isolation level for a single session or for all subsequent connections with the SET TRANSACTION statement. This is because a non-locking SELECT statement presents the state of the database from a read view which consists of ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-repair.html
In this case, you must use ALTER TABLE to increase the MAX_ROWS and AVG_ROW_LENGTH table option values: ALTER TABLE tbl_name MAX_ROWS=xxx AVG_ROW_LENGTH=yyy; If you do not know the current table option values, use SHOW CREATE TABLE. On Unix, make ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-diskio.html
For example, creating a new MySQL instance and its associated data files could cause large surges of disk write activity, impeding the performance of other MySQL instances that use the same storage devices. (It is necessary to use the mount option ... If you follow best practices for database design and tuning techniques for SQL operations, but your database is still slow due to heavy disk I/O activity, consider these disk I/O ...
https://dev.mysql.com/doc/refman/8.4/en/replication-channels.html
This channel is always present; it cannot be created or destroyed by the user. The maximum number of channels that can be created on one replica server in a multi-source replication topology is 256. To provide compatibility with previous versions, ... In MySQL multi-source replication, a replica opens multiple replication channels, one for each source ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-additionalslaves.html
To do this, you can set up the new replica by copying the data directory of an existing replica, and giving the new replica a different server ID (which is user-specified) and server UUID (which is generated at startup). Note If the replication ...
https://dev.mysql.com/doc/refman/8.4/en/switchable-optimizations.html
The parent query does not set a user variable, since rewriting it may affect the order of execution, which could lead to unexpected results if the variable is accessed more than once in the same query. Its value is a set of flags, each of which has ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.full.html
After you have created a full backup, you might perform incremental backups (which are smaller and faster) for the next several backup tasks. This section outlines some of the things to consider when deciding on a strategy for creating full backups.
https://dev.mysql.com/doc/mysql-errors/8.4/en/client-error-reference.html
Error number: 2072; Symbol: CR_INVALID_FACTOR_NO; Message: Invalid first argument for MYSQL_OPT_USER_PASSWORD option. Client error messages originate from within the MySQL client library. Here is an example client error message, as displayed by the ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-audit-plugins.html
The first time the server calls event_notify for a thread, it creates a binding of the plugin to the thread. */ MYSQL_AUDIT_CONNECTION_DISCONNECT = 1 << 1, /** occurs after COM_CHANGE_USER RPC is completed. */ MYSQL_AUDIT_CONNECTION_PRE_AUTHENTICATE ... This section describes how to write a server-side audit plugin, using the example plugin found in the plugin/audit_null directory of MySQL source ...