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/connection-compression-control.html
Because enabling compression decreases performance, its benefits occur primarily when there is low network bandwidth, network transfer time dominates the cost of compression and decompression operations, and result sets are large. Compressed ...
https://dev.mysql.com/doc/refman/5.7/en/events-status-info.html
For statements that may retrieve multiple rows, another strategy is to use LIMIT 1 to limit the result set to a single row. The Event Scheduler writes information about event execution that terminates with an error or warning to the MySQL Server's ...INTO var_list statements, if the query returns no rows, a warning with error code 1329 occurs (No data), and the variable values remain ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-group-membership.html
In MySQL Group Replication, a set of servers forms a replication group. A group has a name, which takes the form of a UUID. If a server leaves the group, for instance it was taken down for maintenance, the remaining servers notice that it has left ...The group is dynamic and servers can leave (either voluntarily or involuntarily) and join it at any ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-limitations.html
The ALTER TABLE clause LOCK=NONE is not permitted if there are ON...CASCADE or ON...SET NULL constraints on the table. Before an online DDL operation can finish, it must wait for transactions that hold metadata locks on the table to commit or roll ... The following limitations apply to online DDL operations: The table is copied when creating an index on a TEMPORARY ...
https://dev.mysql.com/doc/refman/5.7/en/view-algorithms.html
The optional ALGORITHM clause for CREATE VIEW or ALTER VIEW is a MySQL extension to standard SQL. For MERGE, the text of a statement that refers to the view and the view definition are merged such that parts of the view definition replace ...It ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-pitr.html
To perform point-in-time recovery of NDB Cluster, it is necessary to follow the steps shown here: Back up all NDB databases in the cluster, using the START BACKUP command in the ndb_mgm client (see Section 21.6.8, “Online Backup of NDB Cluster”). Point-in-time recovery—that is, recovery of data changes made since a given point in time—is performed after restoring a full backup that returns the server to its state when the backup was ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-native.html
During installation, the initial database is created, and you are prompted for the MySQL root password (and confirmation). The database tables are automatically created for you, if they do not already exist. You should, however, run ... Many Linux ...Important Native packages are often several versions behind the currently available ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-qualifiers.html
For example, this statement creates a table using the unqualified name t1: CREATE TABLE t1 (i INT); Because t1 includes no qualifier to specify a database, the statement creates the table in the default database. The permitted qualifiers for object ...This statement creates a table using the qualified name db1.t1: CREATE TABLE db1.t1 (i INT); Because db1.t1 includes a database qualifier db1, the statement creates t1 in the database named db1, regardless of the default ...
https://dev.mysql.com/doc/refman/5.7/en/union.html
Use of ORDER BY for individual SELECT statements implies nothing about the order in which the rows appear in the final result because UNION by default produces an unordered set of rows. Therefore, ORDER BY in this context typically is used in ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-autocommit-commit-rollback.html
If autocommit mode is enabled, each SQL statement forms a single transaction on its own. By default, MySQL starts the session for each new connection with autocommit enabled, so MySQL does a commit after each SQL statement if that statement did not ...If a statement returns an error, the commit or rollback behavior depends on the ...