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/performance-schema-transaction-tables.html
The cost of transaction instrumentation can be reduced various ways, such as enabling or disabling transaction instrumentation according to user, account, host, or thread (client connection). CREATE TABLE t2 (a INT) ENGINE = MyISAM; -- Transaction 1 ...Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within transaction ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-yum-repo.html
A password for the superuser is set and stored in the error log file. Before You Start As a popular, open-source software, MySQL, in its original or re-packaged form, is widely installed on many systems from various sources, including different ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema.html
mysql_upgrade returns an error if a sys schema exists but has no version view, on the assumption that absence of this view indicates a user-created sys schema. Use of the dedicated mysql.sys account avoids problems that occur if a DBA renames or ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-installation.html
To install functions from the library file, use the CREATE FUNCTION statement. The CREATE FUNCTION and DROP FUNCTION statements require the INSERT and DROP privilege, respectively, for the mysql database. MySQL Enterprise Encryption functions are ...
https://dev.mysql.com/doc/refman/5.7/en/string-type-syntax.html
In some cases, MySQL may change a string column to a type different from that given in a CREATE TABLE or ALTER TABLE statement. Specifying the CHARACTER SET binary attribute for a character string data type causes the column to be created as the ...
https://dev.mysql.com/doc/refman/5.7/en/windows-server-first-start.html
Note The initial root account in the MySQL grant tables has no password. After starting the server, you should set up a password for it using the instructions in Section 2.9.4, “Securing the Initial MySQL Account”. This section gives a general ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-usage.html
Masking functions provide strict and relaxed masking of Primary Account Numbers. Because it cannot be guaranteed that the number generated is not assigned to a legitimate payment account, the result of gen_rnd_pan() should never be displayed, other ... Before using MySQL Enterprise Data Masking and De-Identification, install it according to the instructions provided at Section 6.5.2, “Installing or Uninstalling MySQL Enterprise Data Masking and ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-functions.html
The string must be a suitable length for the Primary Account Number, but is not otherwise checked. The string must be a suitable length for the Primary Account Number, but is not otherwise checked. Example: mysql> SELECT gen_rnd_email(); ...If a ...
https://dev.mysql.com/doc/refman/5.7/en/adding-character-set.html
The range of IDs from 1024 to 2047 is reserved for user-defined collations. For a simple character set, create a configuration file, MYSET.xml, that describes the character set properties. For a complex character set, create a C source file that ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-sets.html
For example, utf8_unicode_ci works fine for German dictionary order and French, so there is no need to create special utf8 collations. In Japan, since the supplementary characters are obscure Kanji ideographs, the typical user does not care what ...