PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.8Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tables-table.html
(This is also true if the InnoDB table is partitioned.) AVG_ROW_LENGTH The average row length. The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. If there are no cached statistics or ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-views-table.html
The flag is set to YES (true) if UPDATE and DELETE (and similar operations) are legal for the view. 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 ...
https://dev.mysql.com/doc/refman/8.0/en/innochecksum.html
--count, -c Command-Line Format --count Type Base name Default Value true Print a count of the number of pages in the file and exit. This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-and-mysql-replication.html
This is true whether you are using statement-based or row-based replication. 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 ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-file-space.html
The 768-byte prefix is accompanied by a 20-byte value that stores the true length of the column and points into the overflow list where the rest of the value is stored. The data files that you define in the configuration file using the ...
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
For example, if you set a boolean variable to 11 (component1.boolvar = 11), you see the following behavior: SET clause yields true Command line yields false (11 is neither ON nor 1) If any error occurs, the statement fails and has no effect. [SET ...
https://dev.mysql.com/doc/refman/8.0/en/invisible-columns.html
For the third INSERT statement, the VALUES() list must provide the same number of values as the number of named columns; the same is true when you use VALUES ROW() rather than VALUES(). An invisible column is normally hidden to queries, but can be ...
https://dev.mysql.com/doc/refman/8.0/en/ipv6-support.html
For example, this command connects over IPv6 to the MySQL server on the local host: $> mysql -h ::1 To use this capability, two things must be true: Your system must be configured to support IPv6. Support for IPv6 in MySQL includes these ...
https://dev.mysql.com/doc/refman/8.0/en/ipv6-system-support.html
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 bytes from ::1, icmp_seq=1 hlim=64 time=0.077 ms ... Before MySQL Server can accept IPv6 connections, the ...