Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-ref-interceptors.html
Classes Class Description BaseExceptionInterceptor Represents the base class for all user-defined exception interceptors.
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-restore-agent.html
Sometimes, an mcmd agent can fail to restart after a failure because its configuration store has been corrupted (for example, by an improper shutdown of the host). If there is at least one other mcmd agent that is still functioning properly on ...
https://dev.mysql.com/doc/internals/en/innodb-field-contents.html
I made a table with this definition: CREATE TABLE T (FIELD1 VARCHAR(3), FIELD2 VARCHAR(3), FIELD3 VARCHAR(3)) Type=InnoDB; To understand what follows, you must know that table T has six columns — not three — because InnoDB automatically added ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-operations.html
The rows of an InnoDB table are stored in a clustered index organized based on the primary key, forming what some database systems call an “index-organized table”. Dropping a column default value ALTER TABLE tbl ALTER COLUMN col DROP DEFAULT, ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-create-table-external.html
Attempting to access a table when the associated data file is missing causes a serious error that requires a server restart. mysql> CREATE TABLE t2 (c1 INT PRIMARY KEY) TABLESPACE = innodb_file_per_table DATA DIRECTORY = '/external/directory'; This ... There are different reasons for creating InnoDB tables externally; that is, creating tables outside of the data ...mysql> SELECT @@innodb_file_per_table; +-------------------------+ | @@innodb_file_per_table | +-------------------------+ | 1 | ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/glossary.html
file format The format used by InnoDB for its data files named ibdata1, ibdata2, and so on. ibdata file A set of files with names such as ibdata1, ibdata2, and so on, that make up the InnoDB system tablespace. (For recent backups of critical data, ...This file records the settings that apply to this backup ...Files with this extension are always included in backups produced by ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-undo-tablespaces.html
CREATE UNDO TABLESPACE tablespace_name ADD DATAFILE 'file_name.ibu'; The undo tablespace file name must have an .ibu extension. Undo tablespace files must be discovered and opened before redo recovery and before other data files are opened to permit ...If the innodb_undo_directory variable is undefined, default undo tablespaces are created in the data ... Undo tablespaces contain undo logs, which are collections of ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump.html
If --add-drop-database is used with --all-databases or with --databases where the list of schemas to be dumped includes mysql, the dump file contains a DROP DATABASE `mysql` statement that causes an error when the dump file is reloaded. Because the ...To reload a dump file, you must have the privileges required to execute the statements that it contains, such as the appropriate CREATE privileges for objects created by those ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-temporary-tablespace.html
The innodb_temp_data_file_path variable defines the relative path, name, size, and attributes for global temporary tablespace data files. If no value is specified for innodb_temp_data_file_path, the default behavior is to create a single ...The ...A ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-persistent-stats.html
17.8.10.1.5 InnoDB Persistent Statistics Tables The persistent statistics feature relies on the internally managed tables in the mysql database, named innodb_table_stats and innodb_index_stats. row *************************** database_name: sakila ...Because of the asynchronous nature of automatic statistics recalculation, which occurs in the background, statistics may not be recalculated instantly after running a DML operation that affects more than 10% of a table, even when innodb_stats_auto_recalc is ...