PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/flush.html
FLUSH PRIVILEGES Re-reads the privileges from the grant tables in the mysql system database. FLUSH TABLES WITH READ LOCK Closes all open tables and locks all tables for all databases with a global read lock. For each table, InnoDB also produces a ...
https://dev.mysql.com/doc/refman/5.7/en/general-tablespaces.html
A DROP DATABASE operation can drop tables that belong to a general tablespace but it cannot drop the tablespace, even if the DROP DATABASE operation drops all tables that belong to the tablespace. A general tablespace is a shared InnoDB tablespace ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-bootstrap.html
mysql> CREATE DATABASE test; mysql> USE test; mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 TEXT NOT NULL); mysql> INSERT INTO t1 VALUES (1, 'Luis'); Check the content of table t1 and the binary log. The process of starting a group for the first ...
https://dev.mysql.com/doc/refman/5.7/en/handler.html
If you do not use an alias, but open the table using a table name qualified by the database name, further references must use the unqualified table name. (See Section 14.21, “InnoDB memcached Plugin” for an alternative way to adapt applications ... HANDLER tbl_name OPEN [ [AS] alias] HANDLER tbl_name READ index_name { = | <= | >= | < | > } (value1,value2,...) [ WHERE where_condition ] [LIMIT ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-key-column-usage-table.html
CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint belongs. TABLE_SCHEMA The name of the schema (database) to which the table belongs. REFERENCED_TABLE_SCHEMA The name of the schema (database) referenced by the constraint.
https://dev.mysql.com/doc/refman/5.7/en/information-schema-triggers-table.html
TRIGGER_SCHEMA The name of the schema (database) to which the trigger belongs. These columns indicate the catalog and schema (database) in which this table occurs, and the table name, respectively. DATABASE_COLLATION The collation of the database ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlocks-handling.html
It explains how to organize database operations to minimize deadlocks and the subsequent error handling required in applications. Deadlocks are a classic problem in transactional databases, but they are not dangerous unless they are so frequent that ... This section builds on the conceptual information about deadlocks in Section 14.7.5.2, “Deadlock ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-disk-management.html
Within these constraints, InnoDB tries to optimize the database work and the organization of disk files to minimize the amount of disk I/O. Sometimes, I/O is postponed until the database is not busy, or until everything needs to be brought to a ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-init-startup-configuration.html
In some cases, you can improve database performance by placing data and log files on separate physical disks. Because of this, an operating system crash or a power outage may destroy recently committed data, or in the worst case, even corrupt the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-statistics-estimation.html
The auto-rehash feature enables automatic name completion of database, table, and column names for interactive users. Choose a value that results in reasonably accurate estimates for all tables in your database without requiring excessive I/O. If ...