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/glossary.html
high-water mark A value representing an upper limit, either a hard limit that should not be exceeded at runtime, or a record of the maximum value that was actually reached. error log A type of log showing information about MySQL startup and critical ...The database remains in a consistent state at all times — after each commit or rollback, and while transactions are in ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-lifecycle.html
The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the replication source server. If a GTID was assigned for the transaction, the GTID is persisted atomically at commit time by writing it to the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-options-variables.html
ndb_cache_check_time Command-Line Format --ndb-cache-check-time=# Deprecated 5.7.20 System Variable ndb_cache_check_time Scope Global Dynamic Yes Type Integer Default Value 0 Minimum Value 0 Maximum Value 31536000 Unit milliseconds The number of ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-auto-increment-handling.html
With a table-level lock, held to the end of the statement, only one INSERT statement referring to table t1 can execute at a time, and the generation of auto-increment numbers by different statements is not interleaved. However, those table-level ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-formats.html
For example, the event corresponding to execution of an SQL statement received from a client has a <TIMESTAMP> value occurring after the statement finishes, not when it was received. For example, the event corresponding to execution of an SQL ...
https://dev.mysql.com/doc/refman/5.7/en/explain-for-connection.html
If the named connection is executing a statement that is not explainable, an error occurs. To obtain the execution plan for an explainable statement executing in a named connection, use this statement: EXPLAIN [options] FOR CONNECTION ...Because of ...
https://dev.mysql.com/doc/refman/5.7/en/compilation-problems.html
Versions of bison older than 1.75 may report this error: sql_yacc.yy:#####: fatal error: maximum table size (32767) exceeded The maximum table size is not actually exceeded; the error is caused by bugs in older versions of bison. However, if you do ...Each time you run CMake, you must run make again to ...If you do reconfigure, take note of the following: If CMake is run after it has previously been run, it may use ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-batch-commands.html
To do so, create a text file text_file that contains the statements you wish to execute. file_name Sometimes you may want your script to display progress information to the user. Previously, it read them and sent them to the server, resulting in a ... The mysql client typically is used interactively, like this: mysql db_name However, it is also possible to put your SQL statements in a file and then tell mysql to read its input from that ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-internals.html
Every time something inside a block is modified, the whole block is recompressed before it is written to disk. Secondary indexes in InnoDB tables are also B-trees, containing pairs of values: the index key and a pointer to a row in the clustered ...
https://dev.mysql.com/doc/refman/5.7/en/sys-execute-prepared-stmt.html
Thus, this procedure is useful primarily for executing dynamic statements on a one-time basis. Given an SQL statement as a string, executes it as a prepared statement. The prepared statement is deallocated after execution, so it is not subject to ...If that statement name exists when the procedure is called, its previous content is ...