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/handler.html
] HANDLER tbl_name CLOSE The HANDLER statement provides direct access to table storage engine interfaces. OPEN statement opens a table, making it accessible using subsequent HANDLER ... This table object is not shared by other sessions and is not ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html
Each table within a database corresponds to at least one file within the database directory (and possibly more, depending on the storage engine). Consequently, the case sensitivity of the underlying operating system plays a part in the case ... In ...
https://dev.mysql.com/doc/refman/5.7/en/implicit-commit.html
(ALTER FUNCTION can only be used with stored functions.) CREATE TABLE and DROP TABLE statements do not commit a transaction if the TEMPORARY keyword is used. (This does not apply to other operations on temporary tables such as ALTER TABLE and CREATE ... The statements listed in this section (and any synonyms for them) implicitly end any transaction active in the current session, as if you had done a COMMIT before executing the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-examples.html
The tables that contain information about InnoDB transactions and data locks enable you to determine which transaction is waiting for another, and which resource is being requested. (For descriptions of these tables, see Section 14.16.2, “InnoDB ... Identifying Blocking Transactions It is sometimes helpful to identify which transaction blocks ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-key.html
NDB Cluster uses MD5() for this purpose; for tables using other storage engines, the server employs its own internal hashing function which is based on the same algorithm as PASSWORD(). PARTITION BY KEY are similar to those for creating a table that ... Partitioning by key is similar to partitioning by hash, except that where hash partitioning employs a user-defined expression, the hashing function for key partitioning is supplied by the MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-object-filtering.html
The setup_objects table controls whether the Performance Schema monitors particular table and stored program objects. TABLE filtering affects table I/O events (wait/io/table/sql/handler instrument) and table lock events (wait/lock/table/sql/handler ...The OBJECT_TYPE column indicates the type of object to which a row ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-concepts.html
The MySQL system table mysql.gtid_executed is used to preserve the assigned GTIDs of all the transactions applied on a MySQL server, except those that are stored in a currently active binary log file. The GTID for a transaction is shown in the ... A ...
https://dev.mysql.com/doc/refman/5.7/en/stored-program-restrictions.html
The following statements are not permitted: The locking statements LOCK TABLES and UNLOCK TABLES. This includes SELECT statements that do not have an INTO var_list clause and other statements such as SHOW, EXPLAIN, and CHECK TABLE. A stored function ...Some of the restrictions noted here apply to all stored routines; that is, both to stored procedures and stored ...
https://dev.mysql.com/doc/refman/5.7/en/backup-methods.html
Making a Hot Backup with MySQL Enterprise Backup Customers of MySQL Enterprise Edition can use the MySQL Enterprise Backup product to do physical backups of entire instances or selected databases, tables, or both. (Ideally, the InnoDB tables should ...Backing up the physical database files makes restore much faster than logical techniques such as the mysqldump ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-add-node-remarks.html
The ability to add new nodes online includes a means to reorganize NDBCLUSTER table data and indexes so that they are distributed across all data nodes, including the new ones, by means of the ALTER TABLE ... Table reorganization of both in-memory ... This section provides general information about the behavior of and current limitations in adding NDB Cluster nodes ...