PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/corrupted-myisam-tables.html
Even though the MyISAM table format is very reliable (all changes to a table made by an SQL statement are written before the statement returns), you can still get corrupted tables if any of the following events occur: The mysqld process is killed ...An unexpected computer shutdown occurs (for example, the computer is turned ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-temptables.html
In statement-based replication mode, CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE statements cannot be used inside a transaction, procedure, function, or trigger when GTIDs are in use on the server (that is, when the enforce_gtid_consistency ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-prepared-statements-instances-table.html
Instrument Server Command statement/com/Prepare COM_STMT_PREPARE statement/com/Execute COM_STMT_EXECUTE statement/sql/prepare_sql SQLCOM_PREPARE statement/sql/execute_sql SQLCOM_EXECUTE The Performance Schema manages the contents of the ...This is ... The Performance Schema provides instrumentation for prepared statements, for which there are two protocols: The binary ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-table-distribution-status.html
The table_distribution_status table provides information about the progress of table distribution for NDB tables. is_reorg_ongoing Whether the table is currently being reorganized (1 if true) .
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-performance.html
Session 1: mysql> CREATE TABLE t1 (c1 INT) ENGINE=InnoDB; mysql> START TRANSACTION; mysql> SELECT * FROM t1; The session 1 SELECT statement takes a shared metadata lock on table t1. Online DDL improves several aspects of MySQL operation: ...Reduced ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-upgrade.html
Each time you upgrade MySQL, you should execute mysql_upgrade, which looks for incompatibilities with the upgraded MySQL server: It upgrades the system tables in the mysql schema so that you can take advantage of new privileges or capabilities that ... Note As of MySQL 8.0.16, the MySQL server performs the upgrade tasks previously handled by mysql_upgrade (for details, see Section 3.4, “What the MySQL Upgrade Process ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-general-table-reference.html
The following table summarizes INFORMATION_SCHEMA general tables. For greater detail, see the individual table descriptions. Table 28.2 INFORMATION_SCHEMA General Tables Table Name Description Deprecated ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-statements-current-table.html
CREATED_TMP_DISK_TABLES Like the Created_tmp_disk_tables status variable, but specific to the statement. CREATED_TMP_TABLES Like the Created_tmp_tables status variable, but specific to the statement. The table stores one row per thread showing the ...The THREAD_ID and EVENT_ID values taken together uniquely identify the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-wait-summary-tables.html
If an instrument is used to create multiple instances, each instance has a unique OBJECT_INSTANCE_BEGIN value and is summarized separately in this table. The Performance Schema maintains tables for collecting current and recent wait events, and ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-truncate-table-reclaim-space.html
For a table to be stored in its own .ibd file, innodb_file_per_table must enabled when the table is created. When a table is truncated, it is dropped and re-created in a new .ibd file, and the freed space is returned to the operating system. This is ... To reclaim operating system disk space when truncating an InnoDB table, the table must be stored in its own .ibd ...