PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-parameters-table.html
The PARAMETERS table provides information about parameters for stored routines (stored procedures and stored functions), and about return values for stored functions. The PARAMETERS table does not include built-in (native) functions or loadable ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-referential-constraints-table.html
The REFERENTIAL_CONSTRAINTS table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the constraint belongs. CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint belongs. UNIQUE_CONSTRAINT_CATALOG The name ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-statistics-table.html
This can have values A (ascending), D (descending), or NULL (not sorted). To update this number, run ANALYZE TABLE or (for MyISAM tables) myisamchk -a. Take this into account when specifying a prefix length for a nonbinary string column that uses a ...The STATISTICS table has these columns: TABLE_CATALOG The name of the catalog to which the table containing the index ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlocks-handling.html
This section builds on the conceptual information about deadlocks in Section 14.7.5.2, “Deadlock Detection”. For example, if you need to write to table t1 and read from table t2, you can do this: SET autocommit=0; LOCK TABLES t1 WRITE, t2 READ, ...It explains how to organize database operations to minimize deadlocks and the subsequent error handling required in ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-compatibility.html
This section describes these checks, how you can control them, and error and warning conditions that might arise. This mechanism lets you take advantage of some new features of an InnoDB release (such as performance improvements and bug fixes), and ... InnoDB incorporates several checks to guard against the possible crashes and data corruptions that might occur if you run an old release of the MySQL server on InnoDB data files that use a newer file ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-limits.html
This section describes limits for InnoDB tables, indexes, tablespaces, and other aspects of the InnoDB storage engine. For example, you might hit this limit with a column prefix index of more than 255 characters on a TEXT or VARCHAR column, ...A ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-ddl.html
If this option is set to a value greater than 1, use READ UNCOMMITTED queries to find rows that were just inserted. If this option is set to a value greater than 1, changes made to the table using SQL are not immediately visible to memcached ... You ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-replication.html
The primary advantage of this configuration is increased write throughput on the source. 2013-09-24T13:04:38.639684Z 49 [Note] Slave I/O thread: connected to master 'root@localhost:13000', replication started in log '0.000001' at position 114 ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-multi-versioning.html
This information is stored in the system tablespace or undo tablespaces in a data structure called a rollback segment. You can use this information to calculate the space needed for your rollback segment. This removal operation is called a purge, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-read_ahead.html
Before this parameter was added, InnoDB would only calculate whether to issue an asynchronous prefetch request for the entire next extent when it read the last page of the current extent. You can set the value of this parameter in the MySQL ... A ...