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/partitioning-management-hash-key.html
Tables which are partitioned by hash or by key are very similar to one another with regard to making changes in a partitioning setup, and both differ in a number of ways from tables which have been partitioned by range or list. For that reason, ...
https://dev.mysql.com/doc/refman/8.0/en/bug-reports.html
If a database table is related to the problem, include the output from the SHOW CREATE TABLE db_name.tbl_name statement in the bug report. You should also include the output from SHOW CREATE TABLE tbl_name for each table that is involved. If you ...
https://dev.mysql.com/doc/refman/8.0/en/programs-overview.html
mysqladmin A client that performs administrative operations, such as creating or dropping databases, reloading the grant tables, flushing tables to disk, and reopening log files. This program creates the SSL certificate and key files and RSA ...
https://dev.mysql.com/doc/refman/8.0/en/index-statistics.html
Storage engines collect statistics about tables for use by the optimizer. Table statistics are based on value groups, where a value group is a set of rows with the same key prefix value. The average value group size is related to table cardinality, ...For optimizer purposes, an important statistic is the average value group ...
https://dev.mysql.com/doc/refman/8.0/en/invisible-indexes.html
ALTER INDEX operation: ALTER TABLE t1 ALTER INDEX i_idx INVISIBLE; ALTER TABLE t1 ALTER INDEX i_idx VISIBLE; Information about whether an index is visible or invisible is available from the Information Schema STATISTICS table or SHOW INDEX output.
https://dev.mysql.com/doc/refman/8.0/en/mysql-command-options.html
The DROP TABLE and CREATE TABLE statements are not executed because the default database is not db1, even though the statements name a table in db1. The INSERT and CREATE TABLE statements are executed because the default database is db1, even though ...This option is on by default, which enables database, table, and column name ... mysql supports the following options, which can be ...
https://dev.mysql.com/doc/refman/8.0/en/view-restrictions.html
The maximum number of tables that can be referenced in the definition of a view is 61. View processing is not optimized: It is not possible to create an index on a view. However, a view that is processed with the temptable algorithm is unable to ...
https://dev.mysql.com/doc/refman/8.0/en/blackhole-storage-engine.html
When you create a BLACKHOLE table, the server creates the table definition in the global data dictionary. The setup for the source is: CREATE TABLE t1 (public_col_1, ..., public_col_N, secret_col_1, ..., secret_col_M) ENGINE=MyISAM; The setup for ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-temporary-tablespace.html
Session Temporary Tablespaces Session temporary tablespaces store user-created temporary tables and internal temporary tables created by the optimizer when InnoDB is configured as the storage engine for on-disk internal temporary tables. InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/bnl-bka-optimization.html
In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join buffer. Benefits of BKA include improved join performance due to more efficient table scanning. Moreover, a join buffer can ...The BKA algorithm supports inner join, outer join, and semijoin operations, including nested outer ...