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-next-key-locking.html
For example, if a SELECT is executed twice, but returns a row the second time that was not returned the first time, the row is a “phantom” row. The so-called phantom problem occurs within a transaction when the same query produces different ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-socket-instances-table.html
The socket_instances table provides a real-time snapshot of the active connections to the MySQL server. Information available in this table provides a real-time snapshot of the active connections to the server. Wait times for active sockets are ...
https://dev.mysql.com/doc/refman/5.7/en/events-metadata.html
The session time zone that is current when a CREATE EVENT or ALTER EVENT statement executes is used to interpret times specified in the event definition. This becomes the event time zone (ETZ); that is, the time zone that is used for event ...Event ... To obtain metadata about events: Query the event table of the mysql ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-buffer-pool-tables.html
The InnoDB INFORMATION_SCHEMA buffer pool tables provide buffer pool status information and metadata about the pages within the InnoDB buffer pool. The InnoDB INFORMATION_SCHEMA buffer pool tables include those listed below: mysql> SHOW TABLES FROM ...
https://dev.mysql.com/doc/refman/5.7/en/show-slave-status.html
Seconds_Behind_Master This field is an indication of how “late” the replica is: When the replica is actively processing updates, this field shows the difference between the current timestamp on the replica and the original timestamp logged on ...
https://dev.mysql.com/doc/refman/5.7/en/xa.html
In essence, this extends ACID properties “up a level” so that multiple ACID transactions can be executed in concert as components of a global operation that also has ACID properties. The process for executing a global transaction uses two-phase ... Support for XA transactions is available for the InnoDB storage ...
https://dev.mysql.com/doc/refman/5.7/en/replication.html
MySQL 5.7 also supports delayed replication such that a replica deliberately lags behind the source by at least a specified amount of time; see Section 16.3.10, “Delayed Replication”. Replication enables data from one MySQL database server (the ...
https://dev.mysql.com/doc/refman/5.7/en/charset-metadata.html
Error messages returned from the server to the client are converted to the client character set automatically, as with metadata. Metadata is “the data about the data.” Anything that describes the database—as opposed to being the contents of ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-select.html
The ENGINE option is part of the CREATE TABLE statement, and should not be used following the SELECT; this would result in a syntax error. If any errors occur while copying the data to the table, it is automatically dropped and not created. If ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-files.html
The expression just described has several implications for permitted table definitions: Using long column names can reduce the maximum number of columns, as can the inclusion of ENUM or SET columns, or use of column comments. MySQL represents each ...