PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-table-lock-waits.html
For additional information, see the description of the Performance Schema metadata_locks table at Section 25.12.12.1, “The metadata_locks Table”. The schema_table_lock_waits and x$schema_table_lock_waits views have these columns: object_schema ... These views display which sessions are blocked waiting on metadata locks, and what is blocking ...
https://dev.mysql.com/doc/refman/5.7/en/general-thread-states.html
After create This occurs when the thread creates a table (including internal temporary tables), at the end of the function that creates the table. This state is used even if the table could not be created due to some error. altering table The server ... The following list describes thread State values that are associated with general query processing and not more specialized activities such as ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema.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. Other terms that are sometimes used for this information are data ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-disk-data.html
It is possible to store the nonindexed columns of NDB tables on disk, rather than in RAM. As part of implementing NDB Cluster Disk Data work, a number of improvements were made in NDB Cluster for the efficient handling of very large amounts ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb.html
This section explains how to optimize database operations for InnoDB tables. InnoDB is the storage engine that MySQL customers typically use in production databases where reliability and concurrency are important.
https://dev.mysql.com/doc/refman/5.7/en/optimizing-myisam.html
The MyISAM storage engine performs best with read-mostly data or with low-concurrency operations, because table locks limit the ability to perform simultaneous updates. In MySQL, InnoDB is the default storage engine rather than MyISAM.
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations.html
Tables employing user-defined partitioning do not preserve the SQL mode in effect at the time that they were created. Therefore, a change in the SQL mode at any time after the creation of partitioned tables may lead to major changes in the behavior ... This section discusses current restrictions and limitations on MySQL partitioning ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html
Information about table definitions is stored both in the .frm files, and in the InnoDB data dictionary. CREATE TABLE Failure Due to Orphan Table A symptom of an out-of-sync data dictionary is that a CREATE TABLE statement fails. If the log says ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-options-variables.html
(Bug #81689, Bug #23518923) --ndb-allow-copying-alter-table=[ON|OFF] Command-Line Format --ndb-allow-copying-alter-table[={OFF|ON}] Introduced 5.7.10-ndb-7.5.0 System Variable ndb_allow_copying_alter_table Scope Global, Session Dynamic Yes Type ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-replica.html
This section explains the server options and system variables that apply to replicas and contains the following: Startup Options for Replicas Options for Logging Replica Status to Tables System Variables Used on Replicas Specify the options either ...Many of the options can be set while the server is running by using the CHANGE MASTER TO ...