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/mysql-cluster-ndbinfo-operations-per-fragment.html
The type column shows the schema object type used for this fragment, which can take any one of the values System table, User table, Unique hash index, or Ordered index. This currently has the following formats: Base table: DbName/def/TblName BLOB ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-table-reference.html
The following table summarizes INFORMATION_SCHEMA InnoDB tables. For greater detail, see the individual table descriptions. Table 24.3 INFORMATION_SCHEMA InnoDB Tables Table Name Description Deprecated INNODB_BUFFER_PAGE Pages in InnoDB buffer pool ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-state-table.html
0 means no statement is executing, 1 means it is in the first 10ms, and so forth. The xxx_WAIT columns of the TP_THREAD_GROUP_STATS table accumulate counts for each wait type. The TP_THREAD_STATE table has one row per thread created by the thread ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-prerequisites.html
Before using the sys schema, the prerequisites described in this section must be satisfied. Because the sys schema provides an alternative means of accessing the Performance Schema, the Performance Schema must be enabled for the sys schema to work.
https://dev.mysql.com/doc/refman/5.7/en/migrating-from-year2.html
This section describes problems that can occur when using the 2-digit YEAR(2) data type and provides information about converting existing YEAR(2) columns to 4-digit year-valued columns, which can be declared as YEAR with an implicit display width ...If you reload the table from the dump file, all resulting rows have internal value 2012 and display value 12, thus losing the distinctions between ...
https://dev.mysql.com/doc/refman/5.7/en/call.html
To get back a value from a procedure using an OUT or INOUT parameter, pass the parameter by means of a user variable, and then check the value of the variable after the procedure returns. When the procedure returns, a client program can also obtain ... CALL sp_name([parameter[,...]]) CALL sp_name[()] The CALL statement invokes a stored procedure that was defined previously with CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/triggers.html
Additional Resources You may find the MySQL User Forums helpful when working with triggers. A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the table. A trigger can be set ...Some uses for triggers are to perform checks of values to be inserted into a table or to perform calculations on values involved in an ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-consistent-read.html
A consistent read does not set any locks on the tables it accesses, and therefore other sessions are free to modify those tables at the same time a consistent read is being performed on the table. SELECT that do not specify FOR UPDATE or LOCK IN ...
https://dev.mysql.com/doc/refman/5.7/en/checking-gpg-signature.html
Setting up a web of trust is one method for trusting them. Otherwise, see http://www.gnupg.org/ for more information about GnuPG and how to obtain and install it. To verify the signature for a specific package, you first need to obtain a copy of our ... Another method of verifying the integrity and authenticity of a package is to use cryptographic ...
https://dev.mysql.com/doc/refman/5.7/en/preventing-use-of-optimizer-trace.html
If, for some reason, you wish to prevent users from seeing traces of their queries, start the server with the options shown here: --maximum-optimizer-trace-max-mem-size=0 --optimizer-trace-max-mem-size=0 This sets the maximum size to 0 and prevents ...