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-enabling-monitors.html
When InnoDB monitors are enabled for periodic output, InnoDB writes the output to mysqld server standard error output (stderr) every 15 seconds, approximately. For more information, see Section 5.4.2.2, “Error Logging on Unix and Unix-Like ...
https://dev.mysql.com/doc/refman/5.7/en/lock-tables.html
Tables in the performance_schema database cannot be locked with LOCK TABLES, except the setup_xxx tables. For view locking, LOCK TABLES adds all base tables used in the view to the set of tables to be locked and locks them automatically. Another use ...lock_type: { READ [LOCAL] | [LOW_PRIORITY] WRITE } UNLOCK {TABLE | TABLES} MySQL enables client sessions to acquire table locks explicitly for the purpose of cooperating with other sessions for access to tables, or to prevent other sessions from modifying tables during periods when a session requires exclusive access to ...
https://dev.mysql.com/doc/refman/5.7/en/execute.html
If the prepared statement contains any parameter markers, you must supply a USING clause that lists user variables containing the values to be bound to the parameters. Parameter values can be supplied only by user variables, and the USING clause ...
https://dev.mysql.com/doc/refman/5.7/en/sys-execute-prepared-stmt.html
Configuration Options execute_prepared_stmt() operation can be modified using the following configuration options or their corresponding user-defined variables (see Section 26.4.2.1, “The sys_config Table”): debug, @sys.debug If this option is ...Thus, this procedure is useful primarily for executing dynamic statements on a one-time ...
https://dev.mysql.com/doc/refman/5.7/en/thread-information.html
To ascertain what your MySQL server is doing, it can be helpful to examine the process list, which indicates the operations currently being performed by the set of threads executing within the server. row *************************** Id: 1 User: ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-compatibility-checking.html
To prevent possible crashes or data corruptions when InnoDB opens an ib-file set, it checks that it can fully support the file formats in use within the ib-file set. Beginning with version InnoDB 1.0.1, the system tablespace records an identifier ...If the system is restarted following a crash, or a “fast shutdown” (i.e., innodb_fast_shutdown is greater than zero), there may be on-disk data structures (such as redo or undo entries, or doublewrite pages) that are in a “too-new” format for the current ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-params-other.html
The listings in this section provide information about parameters used in the [computer], [tcp], and [shm] sections of a config.ini file for configuring NDB Cluster. For detailed descriptions and additional information about individual parameters, ...The following parameters apply to the config.ini file's [computer] section: HostName: Host name or IP address of this ...
https://dev.mysql.com/doc/refman/5.7/en/function-optimization.html
This UPDATE statement uses a nondeterministic function to select rows to be modified: UPDATE t SET col_a = some_expr WHERE id = FLOOR(1 + RAND() * 49); Presumably the intent is to update at most a single row for which the primary key matches the ...
https://dev.mysql.com/doc/refman/5.7/en/char.html
For example, a CHAR(255) column can exceed 768 bytes if the maximum byte length of the character set is greater than 3, as it is with utf8mb4. Note For more information about MySQL character sets and collations, see Chapter 10, Character Sets, ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-bulk-data-loading.html
SET unique_checks=1; For big tables, this saves a lot of disk I/O because InnoDB can use its change buffer to write secondary index records in a batch. If you have FOREIGN KEY constraints in your tables, you can speed up table imports by turning off ... These performance tips supplement the general guidelines for fast inserts in Section 8.2.4.1, “Optimizing INSERT ...