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/mysql-nutshell.html
If older client software cannot be upgraded immediately, the new named_pipe_full_access_group system variable can be used to give a Windows group the necessary permissions to open a named pipe connection. Implementation for the ONLY_FULL_GROUP_BY ...
https://dev.mysql.com/doc/refman/5.7/en/drop-tablespace.html
mysql> CREATE TABLESPACE myts -> ADD DATAFILE 'mydata-1.dat' -> USE LOGFILE GROUP mylg -> ENGINE=NDB; You must remove all data files from the tablespace using ALTER TABLESPACE, as shown here, before it can be dropped: mysql> ALTER TABLESPACE myts -> ... DROP TABLESPACE tablespace_name [ENGINE [=] engine_name] This statement drops a tablespace that was previously created using CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-perror.html
ndb_perror shows information about an NDB error, given its error code. This includes the error message, the type of error, and whether the error is permanent or temporary. Added to the MySQL NDB Cluster distribution in NDB 7.6, it is intended as a ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-innodb-cluster-introduction.html
MySQL Server, and Group Replication, which enables a set of MySQL instances to provide high-availability. InnoDB Cluster provides an alternative, easy to use programmatic way to work with Group Replication. The following diagram shows an overview of ... This chapter introduces MySQL InnoDB Cluster, which combines MySQL technologies to enable you to deploy and administer a complete integrated high availability solution for ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-descriptions.html
Tables in the performance_schema database can be grouped as follows: Setup tables. These tables contain information aggregated over groups of events, including those that have been discarded from the history tables. These do not fall into any of ...
https://dev.mysql.com/doc/refman/5.7/en/counting-rows.html
The use of COUNT() in conjunction with GROUP BY is useful for characterizing your data under various groupings. Counting the total number of animals you have is the same question as “How many rows are in the pet table?” because there is one ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-config-editor.html
The unobfuscated format of the .mylogin.cnf login path file consists of option groups, similar to other option files. Each option group in .mylogin.cnf is called a “login path,” which is a group that permits only certain options: host, user, ...
https://dev.mysql.com/doc/refman/5.7/en/change-replication-filter.html
Note Replication filters cannot be set on a MySQL server instance that is configured for Group Replication, because filtering transactions on some servers would make the group unable to reach agreement on a consistent state. Filters set using this ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 24.1 INFORMATION_SCHEMA Tables Table Name Description Introduced Deprecated CHARACTER_SETS Available character ...
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-tuning.html
If a long-running statement was permitted to block a thread group, all other connections assigned to the group would be blocked and unable to start execution until the long-running statement completed. Assuming that the TP_THREAD_GROUP_STATS table ... This section provides guidelines on setting thread pool system variables for best performance, measured using a metric such as transactions per ...