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/innodb-analyze-table-complexity.html
To set the number of pages sampled for an individual table, use the STATS_SAMPLE_PAGES option with CREATE TABLE or ALTER TABLE. ANALYZE TABLE complexity for InnoDB tables is dependent on: The number of pages sampled, as defined by ...Note ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-mysql-cluster.html
It is also possible to convert existing tables that use other storage engines to NDBCLUSTER using one or more ALTER TABLE statement. See Section 21.6.11, “NDB Cluster Disk Data Tables”, for more information. You must also remember to account for ... In the following section, we answer questions that are frequently asked about NDB Cluster and the NDB storage ...
https://dev.mysql.com/doc/refman/5.7/en/metadata-locking.html
For example, a second session blocks if it attempts any of these operations: DROP TABLE t; ALTER TABLE t ...; DROP TABLE nt; ALTER TABLE nt ...; LOCK TABLE t ... Metadata locking applies not just to tables, but also to schemas, stored programs ...
https://dev.mysql.com/doc/refman/5.7/en/join.html
MySQL supports the following JOIN syntax for the table_references part of SELECT statements and multiple-table DELETE and UPDATE statements: table_references: escaped_table_reference [, escaped_table_reference] ... A table reference (when it refers ...index_hint: { USE {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] ([index_list]) | {IGNORE|FORCE} {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] (index_list) } index_list: index_name [, index_name] ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-temp-table-info.html
INNODB_TEMP_TABLE_INFO provides information about user-created InnoDB temporary tables that are active in the InnoDB instance. It does not provide information about internal InnoDB temporary tables used by the optimizer. mysql> SHOW TABLES FROM ...
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/myisam-repair.html
In this case, you must use ALTER TABLE to increase the MAX_ROWS and AVG_ROW_LENGTH table option values: ALTER TABLE tbl_name MAX_ROWS=xxx AVG_ROW_LENGTH=yyy; If you do not know the current table option values, use SHOW CREATE TABLE. The discussion ...On Unix, make sure that they are readable by the user that mysqld runs as (and to you, because you need to access the files you are ...
https://dev.mysql.com/doc/refman/5.7/en/symbolic-links-to-tables.html
For InnoDB tables, use the alternative technique explained in Section 14.6.1.2, “Creating Tables Externally” instead. The same is true for the ALTER TABLE, OPTIMIZE TABLE, and REPAIR TABLE statements. These table symlink operations are not ...
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 ...