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-wait-summary-tables.html
row *************************** EVENT_NAME: wait/synch/mutex/sql/BINARY_LOG::LOCK_index COUNT_STAR: 8 SUM_TIMER_WAIT: 2119302 MIN_TIMER_WAIT: 196092 AVG_TIMER_WAIT: 264912 MAX_TIMER_WAIT: 569421 ... row *************************** EVENT_NAME: ...
https://dev.mysql.com/doc/refman/5.7/en/table-size-limit.html
The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. If you encounter a full-table error, there are several reasons why it might have occurred: The ...For up-to-date information operating system file size limits, refer to the documentation specific to your operating ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-create-table-external.html
Attempting to access a table when the associated data file is missing causes a serious error that requires a server restart. There are different reasons for creating InnoDB tables externally; that is, creating tables outside of the data directory.
https://dev.mysql.com/doc/refman/5.7/en/windows-start-service.html
You should now be able to invoke any MySQL executable program by typing its name at the DOS prompt from any directory on the system, without having to supply the path. If mysqld does not start, check the error log to see whether the server wrote any ... On Windows, the recommended way to run MySQL is to install it as a Windows service, so that MySQL starts and stops automatically when Windows starts and ...
https://dev.mysql.com/doc/refman/5.7/en/index-statistics.html
For example, if during the course of executing statements for a table, some of those statements modify the table, MySQL may collect statistics. (This may occur for bulk inserts or deletes, or some ALTER TABLE statements, for example.) If this ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-group-membership.html
The group is dynamic and servers can leave (either voluntarily or involuntarily) and join it at any time. Every server in the group has a consistent view of which servers are the members participating actively in the group at a given moment in time.
https://dev.mysql.com/doc/refman/5.7/en/diagnostics-area.html
Standard SQL also supports GET STACKED DIAGNOSTICS syntax for referring to the second diagnostics area during condition handler execution. Execution of RESIGNAL The RESIGNAL statement passes on the error condition information that is available ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-init-startup-configuration.html
The combined log file size (innodb_log_file_size * innodb_log_files_in_group) cannot exceed the maximum value, which is slightly less than 512GB. Normally, InnoDB is initialized when the MySQL server is started for the first time. If a tablespace ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-cmp-table.html
COMPRESS_TIME The total time in seconds used for attempts to compress B-tree pages of size PAGE_SIZE. UNCOMPRESS_TIME The total time in seconds used for uncompressing B-tree pages of the size PAGE_SIZE. COMPRESS_OPS The number of times a B-tree page ... The INNODB_CMP and INNODB_CMP_RESET tables provide status information on operations related to compressed InnoDB ...