PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tables-table.html
The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. If there are no cached statistics or statistics have expired, statistics are retrieved from storage engines when querying table ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-views-table.html
You must have the SHOW VIEW privilege to access this table. The VIEWS table has these columns: TABLE_CATALOG The name of the catalog to which the view belongs. TABLE_SCHEMA The name of the schema (database) to which the view belongs. VIEW_DEFINITION ...
https://dev.mysql.com/doc/refman/8.0/en/innochecksum.html
This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored checksum, and reports mismatches, which indicate damaged pages. It was originally developed to speed up verifying the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-and-mysql-replication.html
It is possible to use replication in a way where the storage engine on the replica is not the same as the storage engine on the source. For example, you can replicate modifications to an InnoDB table on the source to a MyISAM table on the replica.
https://dev.mysql.com/doc/refman/8.0/en/innodb-file-space.html
The data files that you define in the configuration file using the innodb_data_file_path configuration option form the InnoDB system tablespace. You cannot define where within the system tablespace your tables are allocated. In a newly created ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-row-format.html
The row format of a table determines how its rows are physically stored, which in turn can affect the performance of queries and DML operations. As more rows fit into a single disk page, queries and index lookups can work faster, less cache memory ...
https://dev.mysql.com/doc/refman/8.0/en/install-component.html
[SET variable = expr [, variable = expr] ...] variable: { {GLOBAL | @@GLOBAL.} [component_prefix.]system_var_name | {PERSIST | @@PERSIST.} [component_prefix.]system_var_name } This statement installs one or more components, which become active ...
https://dev.mysql.com/doc/refman/8.0/en/invisible-columns.html
An invisible column is normally hidden to queries, but can be accessed if explicitly referenced. As an illustration of when invisible columns may be useful, suppose that an application uses SELECT * queries to access a table, and must continue to ...
https://dev.mysql.com/doc/refman/8.0/en/ipv6-support.html
Support for IPv6 in MySQL includes these capabilities: MySQL Server can accept TCP/IP connections from clients connecting over IPv6. For example, this command connects over IPv6 to the MySQL server on the local host: $> mysql -h ::1 To use this ...
https://dev.mysql.com/doc/refman/8.0/en/ipv6-system-support.html
Before MySQL Server can accept IPv6 connections, the operating system on your server host must support IPv6. As a simple test to determine whether that is true, try this command: $> ping6 ::1 16 bytes from ::1, icmp_seq=0 hlim=64 time=0.171 ms 16 ...