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/binlog-replication-configuration-overview.html
Replicas are configured to read the binary log from the source and to execute the events in the binary log on the replica's local database. It is the responsibility of the replica to decide which statements in the binary log should be executed.
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-table-lock-waits.html
sql_kill_blocking_query The KILL statement to execute to kill the blocking statement. sql_kill_blocking_connection The KILL statement to execute to kill the session running the blocking statement. These views display which sessions are blocked ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-understanding-innodb-locking.html
If a second transaction wants to update a row or lock a table already locked by a prior transaction in an incompatible mode, InnoDB adds a lock request for the row to the corresponding queue. At any given time, a transaction may request a lock that ... When a transaction updates a row in a table, or locks it with SELECT FOR UPDATE, InnoDB establishes a list or queue of locks on that ...
https://dev.mysql.com/doc/refman/5.7/en/sys-diagnostics.html
Parameters in_max_runtime INT UNSIGNED: The maximum data collection time in seconds. in_interval INT UNSIGNED: The sleep time between data collections in seconds. This procedure disables binary logging during its execution by manipulating the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-security.html
memcp --servers=localhost:11211 --binary --username=testname --password=password myfile.txt memcat --servers=localhost:11211 --binary --username=testname --password=password myfile.txt If you specify an incorrect user name or password, the operation ... Caution Consult this section before deploying the daemon_memcached plugin on a production server, or even on a test server if the MySQL instance contains sensitive ...
https://dev.mysql.com/doc/refman/5.7/en/outer-join-optimization.html
MySQL implements an A LEFT JOIN B join_specification as follows: Table B is set to depend on table A and all tables on which A depends. Table A is set to depend on all tables (except B) that are used in the LEFT JOIN condition. The LEFT JOIN ...
https://dev.mysql.com/doc/refman/5.7/en/stored-program-restrictions.html
In addition—due to rounding, the nature of threaded applications, and the fact that a nonzero length of time is required to create events and to signal their execution—events may be delayed by as much as 1 or 2 seconds. However, the time shown ...If you refer to a temporary table multiple times in a stored function under different aliases, a Can't reopen table: 'tbl_name' error occurs, even if the references occur in different statements within the ...
https://dev.mysql.com/doc/refman/5.7/en/savepoint.html
In this case, the row lock is released in the undo.) Savepoints that were set at a later time than the named savepoint are deleted. If the ROLLBACK TO SAVEPOINT statement returns the following error, it means that no savepoint with the specified ...
https://dev.mysql.com/doc/refman/5.7/en/hexadecimal-literals.html
Legal hexadecimal literals: X'01AF' X'01af' x'01AF' x'01af' 0x01AF 0x01af Illegal hexadecimal literals: X'0G' (G is not a hexadecimal digit) 0X01AF (0X must be written as 0x) Values written using X'val' notation must contain an even number of digits ... Hexadecimal literal values are written using X'val' or 0xval notation, where val contains hexadecimal digits (0..9, ...
https://dev.mysql.com/doc/refman/5.7/en/load-data.html
Unless REPLACE is also specified, LOCAL has the same effect as the IGNORE modifier on the interpretation of input file contents and error handling; see Duplicate-Key and Error Handling, and Column Value Assignment. For example, if mysqld was started ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...