PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/innodb-transaction-isolation-levels.html
For other search conditions, InnoDB locks the index range scanned, using gap locks or next-key locks to block insertions by other sessions into the gaps covered by the range. Gap locking is only used for foreign-key constraint checking and ...
https://dev.mysql.com/doc/refman/9.7/en/invisible-indexes.html
If an index made invisible actually is needed or used by the optimizer, there are several ways to notice the effect of its absence on queries for the table: Errors occur for queries that include index hints that refer to the invisible index. If the ... MySQL supports invisible indexes; that is, indexes that are not used by the ...
https://dev.mysql.com/doc/refman/9.7/en/locking-service.html
MySQL distributions provide a locking interface that is accessible at two levels: At the SQL level, as a set of loadable functions that each map onto calls to the service routines. As a C language interface, callable as a plugin service from server ...For general information about plugin services, see Section 7.6.8, “MySQL Plugin ...
https://dev.mysql.com/doc/refman/9.7/en/memory-storage-engine.html
Shared-nothing architecture and multiple-host operation with no single point of failure, enabling 99.999% availability. Deleted rows are put in a linked list and are reused when you insert new data into the table. CREATE TABLE t (i INT) ENGINE = ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-restore.html
This program reads the files created as a result of the backup and inserts the stored information into the database. --allow-pk-changes Command-Line Format --allow-pk-changes[=0|1] Type Integer Default Value 0 Minimum Value 0 Maximum Value 1 When ...
https://dev.mysql.com/doc/refman/9.7/en/mysqlbinlog-row-events.html
# at 218 #080828 15:03:08 server id 1 end_log_pos 258 Write_rows: table id 17 flags: STMT_END_F BINLOG ' fAS3SBMBAAAALAAAANoAAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ= fAS3SBcBAAAAKAAAAAIBAAAQABEAAAAAAAEAA//8AQAAAAVhcHBsZQ== '/*!*/; ### INSERT INTO ...
https://dev.mysql.com/doc/refman/9.7/en/sql-mode.html
Changing the server SQL mode after creating and inserting data into partitioned tables can cause major changes in the behavior of such tables, and could lead to loss or corruption of data. STRICT_TRANS_TABLES If a value could not be inserted as ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-libraries.html
(This is true of all JavaScript values that you wish to import into another routine; see export, in the Mozilla Developer documentation for more information). You can obtain general information about JavaScript libraries by querying the Information ... This section provides information about and examples of use of JavaScript libraries in JavaScript stored programs as supported by the Multilingual Engine (MLE) in MySQL Enterprise ...
https://dev.mysql.com/doc/refman/9.7/en/type-conversion.html
For example, if a subquery returns an integer to be compared to a DATETIME value, the comparison is done as two integers. The arguments are compared as decimal values if the other argument is a decimal or integer value, or as floating-point values ... When an operator is used with operands of different types, type conversion occurs to make the operands ...
https://dev.mysql.com/doc/refman/9.7/en/atomic-ddl.html
An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a single, atomic operation. Atomic DDL Characteristics The characteristics of atomic DDL statements ...The operation is either committed, with applicable changes persisted to the data dictionary, storage engine, and binary log, or is rolled back, even if the server halts during the ...