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/group-replication-bootstrap.html
mysql> CREATE DATABASE test; mysql> USE test; mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 TEXT NOT NULL); mysql> INSERT INTO t1 VALUES (1, 'Luis'); Check the content of table t1 and the binary log. The process of starting a group for the first ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-events-table.html
EVENT_DEFINITION The text of the SQL statement making up the event's DO clause; in other words, the statement executed by this event. EVENT_COMMENT The text of the comment, if the event has one. The EVENTS table provides information about Event ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-routines-table.html
ROUTINE_DEFINITION The text of the SQL statement executed by the routine. ROUTINE_COMMENT The text of the comment, if the routine has one. The ROUTINES table provides information about stored routines (stored procedures and stored functions). The ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-tuning.html
Character strings often compress well, whether defined in CHAR, VARCHAR, TEXT or BLOB columns. If a high percentage of compression operations complete successfully, the table might be a good candidate for compression. Compressing in the Application ... Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed ...
https://dev.mysql.com/doc/refman/5.7/en/insert.html
The following statement is invalid because it contains one list of nine values, rather than three lists of three values each: INSERT INTO tbl_name (a,b,c) VALUES(1,2,3,4,5,6,7,8,9); VALUE is a synonym for VALUES in this context. The trailing ...
https://dev.mysql.com/doc/refman/5.7/en/installing-source-distribution.html
To install MySQL from a standard source distribution: Verify that your system satisfies the tool requirements listed at Section 2.8.2, “Source Installation Prerequisites”. Obtain a distribution file using the instructions in Section 2.1.3, ...
https://dev.mysql.com/doc/refman/5.7/en/internal-temporary-tables.html
Some query conditions prevent the use of an in-memory temporary table, in which case the server uses an on-disk table instead: Presence of a BLOB or TEXT column in the table. This includes user-defined variables having a string value because they ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-okv-plugin.html
As of MySQL 5.7.20, if the key file is password-protected, the ssl directory can contain a single-line text file named password.txt containing the password needed to decrypt the key file. For example, use a command like this, and enter the ... Note ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-example-data.html
Note The information in this section applies to NDB Cluster running on both Unix and Windows platforms. Working with database tables and data in NDB Cluster is not much different from doing so in standard MySQL. There are two key points to keep in ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndb-innodb-engines.html
The NDB storage engine is implemented using a distributed, shared-nothing architecture, which causes it to behave differently from InnoDB in a number of ways. For those unaccustomed to working with NDB, unexpected behaviors can arise due to its ...