PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 255.5Kb
Man Pages (Zip)
- 360.4Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/general-thread-states.html
Copying to group table If a statement has different ORDER BY and GROUP BY criteria, the rows are sorted by group and copied to a temporary table. Sorting for group The thread is doing a sort to satisfy a GROUP BY. The following list describes ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-linux-binary.html
This section covers the steps necessary to install the correct executables for each type of Cluster node from precompiled binaries supplied by Oracle. For setting up a cluster using precompiled binaries, the first step in the installation process ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-params-ndbd.html
InitialLogFileGroup: Describes log file group that is created during initial start. NodeGroup: Node group to which data node belongs; used only during initial start of cluster. StartNoNodeGroupTimeout: Time to wait for nodes without nodegroup before ... The listings in this section provide information about parameters used in the [ndbd] or [ndbd default] sections of a config.ini file for configuring NDB Cluster data ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-server.html
To run the server as some specific user, add an appropriate user option to the [mysqld] group of the global /etc/my.cnf option file, as shown later in this section. The PID file value passed to mysqld_safe overrides any value specified in the ...
https://dev.mysql.com/doc/refman/5.7/en/reset-slave.html
To use RESET SLAVE on a Group Replication group member, the member status must be OFFLINE, meaning that the plugin is loaded but the member does not currently belong to any group. A group member can be taken offline by using a STOP GROUP REPLICATION ... RESET SLAVE [ALL] [channel_option] channel_option: FOR CHANNEL channel RESET SLAVE makes the replica forget its replication position in the source's binary ...
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
Setting the SQL Mode The default SQL mode in MySQL 5.7 includes these modes: ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, and NO_ENGINE_SUBSTITUTION. These modes were added ... The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system ...
https://dev.mysql.com/doc/refman/5.7/en/case-sensitivity.html
Simple comparison operations (>=, >, =, <, <=, sorting, and grouping) are based on each character's “sort value.” Characters with the same sort value are treated as the same character. For nonbinary strings (CHAR, VARCHAR, TEXT), string ...
https://dev.mysql.com/doc/refman/5.7/en/create-function-loadable.html
The AGGREGATE keyword, if given, signifies that the function is an aggregate (group) function. CREATE [AGGREGATE] FUNCTION function_name RETURNS {STRING|INTEGER|REAL|DECIMAL} SONAME shared_library_name This statement loads the loadable function ...
https://dev.mysql.com/doc/refman/5.7/en/file-permissions.html
For example, to give group access to all new directories, start mysqld_safe as follows: UMASK_DIR=504 # = 770 in octal export UMASK_DIR mysqld_safe & For additional details, see Section 4.9, “Environment Variables”. If you have problems with ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-single-multi.html
Operations all using the same specific LOCK clause, that you want to either succeed or fail as a group. Before the introduction of online DDL, it was common practice to combine many DDL operations into a single ALTER TABLE statement. Because each ...