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/performance-schema-quick-start.html
Tables in the performance_schema database can be grouped according to the type of information in them: Current events, event histories and summaries, object instances, and setup (configuration) information. For detailed information about the tables ... This section briefly introduces the Performance Schema with examples that show how to use ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-summary-tables.html
The tables in this group summarize event data in different ways. Each summary table has grouping columns that determine how to group the data to be aggregated, and summary columns that contain the aggregated values. Tables that summarize events in ... Summary tables provide aggregated information for terminated events over ...
https://dev.mysql.com/doc/refman/5.7/en/server-plugins.html
Group Replication enables you to create a highly available distributed MySQL service across a group of MySQL server instances, with data consistency, conflict detection and resolution, and group membership services all built-in. MySQL supports an ...
https://dev.mysql.com/doc/refman/5.7/en/stop-slave.html
Note that the Group Replication applier channel (group_replication_applier) has no replication I/O thread, only a replication SQL thread. If the current replication event group has modified one or more nontransactional tables, STOP SLAVE waits for ...] thread_type: IO_THREAD | SQL_THREAD channel_option: FOR CHANNEL channel Stops the replication ...
https://dev.mysql.com/doc/refman/5.7/en/upgrading-from-previous-series.html
Implementation of the ONLY_FULL_GROUP_BY SQL mode has been made more sophisticated, to no longer reject deterministic queries that previously were rejected. In consequence, ONLY_FULL_GROUP_BY is now enabled by default, to prohibit nondeterministic ... Before upgrading to MySQL 5.7, review the changes described in this section to identify those that apply to your current MySQL installation and ...
https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization.html
Either create the account if it does not exist (see Create a mysql User and Group), or substitute the name of a different existing login account that you plan to use for running the server. Also make sure to specify as necessary other parameters ...
https://dev.mysql.com/doc/refman/5.7/en/extensions-to-ansi.html
You don't need to name all selected columns in the GROUP BY clause. You can specify ASC and DESC with GROUP BY, not just with ORDER BY. MySQL Server supports some extensions that are likely not to be found in other SQL DBMSs. Be warned that if you ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-mysql-cluster.html
For this reason, if you do run multiple data nodes on a single machine, it is extremely important that they be set up in such a way that the failure of this machine does not cause the loss of all the data nodes in a given node group. When all data ... In the following section, we answer questions that are frequently asked about NDB Cluster and the NDB storage ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-init-startup-configuration.html
You can place InnoDB settings in the [mysqld] group of any option file that your server reads when it starts. The following options can be used to modify the default configuration: innodb_log_group_home_dir defines directory path to the InnoDB log ... The first decisions to make about InnoDB configuration involve the configuration of data files, log files, page size, and memory buffers, which should be configured before initializing ...
https://dev.mysql.com/doc/refman/5.7/en/join.html
index_hint: { USE {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] ([index_list]) | {IGNORE|FORCE} {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] (index_list) } index_list: index_name [, index_name] ... MySQL supports the following JOIN syntax for the ...