PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-auto-increment-handling.html
The exception is for “mixed-mode inserts”, where the user provides explicit values for an AUTO_INCREMENT column for some, but not all, rows in a multiple-row “simple insert”. Specifying NULL or 0 for the AUTO_INCREMENT column In all lock ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-what-is-new-7-6.html
For this reason, the program must be able to connect as a MySQL user having the SELECT privilege on tables in the ndbinfo database. This should help resolve issues with page and extent handling that were visible to the user as problems with rapid ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-functions.html
When database db2 is copied to server1, the GTIDs of the transactions committed on server2, which are not in the binary log files on server1, must be added to gtid_purged for server1 to make the set complete. This section provides examples of ...
https://dev.mysql.com/doc/refman/5.7/en/string-type-syntax.html
Column definitions for character string data types CHAR, VARCHAR, the TEXT types, ENUM, SET, and any synonyms) can specify the column character set and collation: CHARACTER SET specifies the character set. If desired, a collation for the character ... The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and ...In some cases, MySQL may change a ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-current-user.html
In some cases, such as statements that change passwords, the function reference is expanded before it is written to the binary log, so that the statement includes the user name. For all other cases, the name of the current user on the source is ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-file-io-type.html
Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. total The total number of occurrences of the file I/O event for the user.
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-stages.html
Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. total The total number of occurrences of the stage event for the user. By ...
https://dev.mysql.com/doc/refman/5.7/en/binary-installation.html
Create a mysql User and Group If your system does not already have a user and group to use for running mysqld, you may need to create them. The syntax for useradd and groupadd may differ slightly on different versions of Unix/Linux, or they may have ...The following commands add the mysql group and the mysql ...These include generic binary distributions in the form of compressed tar files (files with a .tar.gz extension) for a number of platforms, and ...
https://dev.mysql.com/doc/refman/5.7/en/sql-prepared-statements.html
Typically, database applications process large volumes of almost-identical statements, with only changes to literal or variable values in clauses such as WHERE for queries and deletes, SET for updates, and VALUES for inserts. For example, the C API ...Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is ...
https://dev.mysql.com/doc/refman/5.7/en/sys-waits-by-user-by-latency.html
total The total number of occurrences of the event for the user. total_latency The total wait time of timed occurrences of the event for the user. avg_latency The average wait time per timed occurrence of the event for the user. max_latency The ...