PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 255.5Kb
Man Pages (Zip)
- 360.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/partitioning-selection.html
You can also use aggregate functions with HAVING and GROUP BY options. MySQL 5.7 supports explicit selection of partitions and subpartitions that, when executing a statement, should be checked for rows matching a given WHERE condition. Partition ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-filtering-names.html
Names given for filtering operations can be as specific or general as required. For example, to select all file I/O instruments, it is better to use a pattern that includes the entire instrument name prefix: ... WHERE NAME LIKE 'wait/io/file/%'; ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-reference.html
The following table summarizes all available Performance Schema tables. For greater detail, see the individual table descriptions. Table 25.1 Performance Schema Tables Table Name Description Deprecated accounts Connection statistics per client ...
https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html
CREATE TABLESPACE Enables use of statements that create, alter, or drop tablespaces and log file groups. Enables the account to start and stop replication, including Group Replication. The privileges granted to a MySQL account determine which ...
https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html
group_replication_primary_member Shows the primary member's UUID when the group is operating in single-primary mode. If the group is operating in multi-primary mode, shows an empty string. The MySQL server maintains many status variables that ...
https://dev.mysql.com/doc/refman/5.7/en/start-slave.html
The replication channels for Group Replication (group_replication_applier and group_replication_recovery) are managed automatically by the server instance. The only Group Replication channel that you can interact with is the ... START SLAVE ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-installation.html
This section describes how to install or uninstall MySQL Enterprise Audit, which is implemented using the audit log plugin and related elements described in Section 6.4.5.1, “Elements of MySQL Enterprise Audit”. For general information about ...
https://dev.mysql.com/doc/refman/5.7/en/backup-and-recovery.html
A group of MySQL servers can be configured to create a cluster using MySQL Shell. It is important to back up your databases so that you can recover your data and be up and running again in case problems occur, such as system crashes, hardware ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log.html
To prevent this, enable the sync_binlog system variable to synchronize the binary log to disk after every N commit groups. The binary log contains “events” that describe database changes such as table creation operations or changes to table ...
https://dev.mysql.com/doc/refman/5.7/en/changing-mysql-user.html
To start the server as the given user automatically at system startup time, specify the user name by adding a user option to the [mysqld] group of the /etc/my.cnf option file or the my.cnf option file in the server's data directory. On Windows, you ...