PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.4Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/information-schema-optimization.html
Querying statistics columns does not store or update statistics in the mysql.index_stats and mysql.innodb_table_stats dictionary tables under these circumstances: When cached statistics have not expired. Applications that monitor databases may make ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-optimizer-trace-table.html
INSUFFICIENT_PRIVILEGES If a traced query uses views or stored routines that have SQL SECURITY with a value of DEFINER, it may be that a user other than the definer is denied from seeing the trace of the query. The OPTIMIZER_TRACE table provides ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-st-geometry-columns-table.html
The ST_GEOMETRY_COLUMNS table provides information about table columns that store spatial data. This table is based on the SQL/MM (ISO/IEC 13249-3) standard, with extensions as noted. MySQL implements ST_GEOMETRY_COLUMNS as a view on the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-statistics-table.html
CARDINALITY is counted based on statistics stored as integers, so the value is not necessarily exact even for small tables. The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. If ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-view-routine-usage-table.html
The VIEW_ROUTINE_USAGE table (available as of MySQL 8.0.13) provides access to information about stored functions used in view definitions. The table does not list information about built-in (native) functions or loadable functions used in the ...
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. If checksum mismatches are found, restore the tablespace ...It was originally developed to speed up verifying the integrity of tablespace files after power outages but can also be used after file ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-background.html
The different page size requires that the table be placed in a file-per-table tablespace or general tablespace rather than in the system tablespace, as the system tablespace cannot store compressed tables. Because processors and cache memories have ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression.html
Using the compression features of InnoDB, you can create tables where the data is stored in compressed form. This section provides information about the InnoDB table compression and InnoDB page compression features. The page compression feature is ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlocks-handling.html
For example, organize database operations into functions within your application, or call stored routines, rather than coding multiple similar sequences of INSERT, UPDATE, and DELETE statements in different places. This section builds on the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-file-defragmenting.html
All InnoDB data and indexes are stored in B-trees, and their fill factor may vary from 50% to 100%. Random insertions into or deletions from a secondary index can cause the index to become fragmented. Fragmentation means that the physical ordering ...