PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-threads-table.html
The threads table contains a row for each server thread. When the Performance Schema initializes, it populates the threads table based on the threads in existence then. The INSTRUMENTED and HISTORY column values for new threads are determined by ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-upgrade.html
(Bug #76734, Bug #20727344) You can upgrade such tables individually in the mysql client using the ALTER TABLE ... Each time you upgrade MySQL, you should execute mysql_upgrade, which looks for incompatibilities with the upgraded MySQL server: It ...mysql_upgrade communicates directly with the MySQL server, sending it the SQL statements required to perform an ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-introduction.html
INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. They are actually views, not base tables, so there are no files ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-setup.html
Installing and Configuring the InnoDB memcached Plugin Configure the daemon_memcached plugin so it can interact with InnoDB tables by running the innodb_memcached_config.sql configuration script, which is located in MYSQL_HOME/share. This script ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-maintenance.html
You can use a number of extensions to ALTER TABLE for performing operations of this type on one or more partitions directly, as described in the following list: Rebuilding partitions. If you have deleted a large number of rows from a partition or if ... A number of table and partition maintenance tasks can be carried out using SQL statements intended for such purposes on partitioned tables in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/semijoins.html
A semijoin is a preparation-time transformation that enables multiple execution strategies such as table pullout, duplicate weedout, first match, loose scan, and materialization. For an inner join between two tables, the join returns a row from one ...The optimizer uses semijoin strategies to improve subquery execution, as described in this ...
https://dev.mysql.com/doc/refman/5.7/en/dba-dtrace-mysqld-ref.html
The values for each type are shown in the following table. insert-row-start(database, table) insert-row-done(status) update-row-start(database, table) update-row-done(status) delete-row-start(database, table) delete-row-done(status) ... MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-like.html
LIKE to create an empty table based on the definition of another table, including any column attributes and indexes defined in the original table: CREATE TABLE new_tbl LIKE orig_tbl; The copy is created using the same version of the table storage ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 24.1 INFORMATION_SCHEMA Tables Table Name Description Introduced Deprecated CHARACTER_SETS Available character ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-page-compression.html
Page compression is enabled by specifying the COMPRESSION attribute with CREATE TABLE or ALTER TABLE. For example: CREATE TABLE t1 (c1 INT) COMPRESSION="zlib"; You can also enable page compression in an ALTER TABLE statement. ALTER TABLE t1 ...