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/sys-ps-thread-trx-info.html
Configuration Options ps_thread_trx_info() 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”): ps_thread_trx_info.max_length, ...
https://dev.mysql.com/doc/refman/5.7/en/out-of-range-and-overflow.html
If no restrictive modes are enabled, MySQL clips the value to the appropriate endpoint of the column data type range and stores the resulting value instead. When an out-of-range value is assigned to an integer column, MySQL stores the value ...
https://dev.mysql.com/doc/refman/5.7/en/server-logs.html
(The DDL log is always created when required, and has no user-configurable options; see Section 5.4.6, “The DDL Log”.) The following log-specific sections provide information about the server options that enable logging. For information about ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-locks-per-fragment.html
fq_name is a fully qualified database object name in database/schema/name format, such as test/def/t1 or sys/def/10/b$unique. The locks_per_fragment table provides information about counts of lock claim requests, and the outcomes of these requests ...Together with the block name, this number can be used to look up a given instance in the threadblocks ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-pruning.html
By doing so, it is possible to expend much less time and effort in finding matching rows than would be required to scan all partitions in the table. When the optimizer can make use of partition pruning in performing this query, execution of the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-index-table-table.html
Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that contains the FULLTEXT index; for example test/articles. Before querying it, set the value of the ... The ...The ...
https://dev.mysql.com/doc/refman/5.7/en/replica-logs-relaylog.html
The relay log, like the binary log, consists of a set of numbered files containing events that describe database changes, and an index file that contains the names of all used relay log files. The term “relay log file” generally denotes an ...
https://dev.mysql.com/doc/refman/5.7/en/creating-tables.html
Storing birth date rather than age has other advantages, too: You can use the database for tasks such as generating reminders for upcoming pet birthdays. For example, if you store death date in the database, you can easily calculate how old a pet ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-limits.html
For example, you might hit this limit with a column prefix index of more than 255 characters on a TEXT or VARCHAR column, assuming a utf8mb3 character set and the maximum of 3 bytes for each character. This section describes limits for InnoDB ...A ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-syntax.html
For example, to invoke a stored procedure p or function f that is associated with the test database, you can say CALL test.p() or test.f(). A stored procedure or function is associated with a particular database. This has several implications: When ... A stored routine is either a procedure or a ...