MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 11 to 18 of 18 total results

« Previous
1
2
Next »

6.5.4 mysqldump — A Database Backup Program

https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html

The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data. It dumps one or more MySQL databases for backup or transfer to ...

28.3.21 The INFORMATION_SCHEMA PARTITIONS Table

https://dev.mysql.com/doc/refman/8.0/en/information-schema-partitions-table.html

AVG_ROW_LENGTH The average length of the rows stored in this partition or subpartition, in bytes. Each row in this table corresponds to an individual partition or subpartition of a partitioned table. The PARTITIONS table has these columns: ...

26.3.3 Exchanging Partitions and Subpartitions with Tables

https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-exchange.html

The AVG_ROW_LENGTH cannot differ between the two tables pt and nt. Table nt contains no foreign key references, and no other table has any foreign keys that refer to nt. There are no rows in nt that lie outside the boundaries of the partition ...

7.1.8 Server System Variables

https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html

The MySQL server maintains many system variables that affect its operation. Most system variables can be set at server startup using options on the command line or in an option file. Most of them can be changed dynamically at runtime using the SET ...

10.2.3 Optimizing INFORMATION_SCHEMA Queries

https://dev.mysql.com/doc/refman/8.0/en/information-schema-optimization.html

Some INFORMATION_SCHEMA tables contain columns that provide table statistics: STATISTICS.CARDINALITY TABLES.AUTO_INCREMENT TABLES.AVG_ROW_LENGTH TABLES.CHECKSUM TABLES.CHECK_TIME TABLES.CREATE_TIME TABLES.DATA_FREE TABLES.DATA_LENGTH ...

28.3.15 The INFORMATION_SCHEMA FILES Table

https://dev.mysql.com/doc/refman/8.0/en/information-schema-files-table.html

The FILES table provides information about the files in which MySQL tablespace data is stored. In NDB Cluster, this table also provides information about the files in which NDB Cluster Disk Data tables are stored. For additional information ...

17.6.1.1 Creating InnoDB Tables

https://dev.mysql.com/doc/refman/8.0/en/using-innodb-tables.html

row *************************** Name: t1 Engine: InnoDB Version: 10 Row_format: Dynamic Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: NULL Create_time: 2021-02-18 12:18:28 Update_time: ... InnoDB tables are created using the CREATE TABLE statement; for example: CREATE TABLE t1 (a INT, b CHAR (20), PRIMARY KEY (a)) ENGINE=InnoDB; The ENGINE=InnoDB clause is not required when InnoDB is defined as the default storage engine, which it is by ...

2.3 Installing MySQL on Microsoft Windows

https://dev.mysql.com/doc/refman/8.0/en/windows-installation.html

Do not forget to use MAX_ROWS and AVG_ROW_LENGTH when you create tables. Important MySQL 8.0 Server requires the Microsoft Visual C++ 2019 Redistributable Package to run on Windows platforms. Users should make sure the package has been installed on ...