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/thread-pool-operation.html
While a thread executes a statement from a user connection, Performance Schema instrumentation accounts thread activity to the user connection. For guidelines on setting this variable, see Section 5.5.3.4, “Thread Pool Tuning”. The default time ... The thread pool consists of a number of thread groups, each of which manages a set of client ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-table-import.html
If a ROW_FORMAT option is not defined explicitly in the table definition or ROW_FORMAT=DEFAULT is used, the innodb_default_row_format setting must be the same on the source and destination instances. A convenient way to accomplish this is to add ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-nodes-groups.html
(You should be aware that the number of LDM threads increases with the value of this parameter, but not in a strictly linear fashion, and that there are additional constraints on setting it; see the description of MaxNoOfExecutionThreads for more ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-system-variables.html
These conditions apply to the following system variables: group_replication_single_primary_mode group_replication_enforce_update_everywhere_checks group_replication_gtid_assignment_block_size default_table_encryption lower_case_table_names ...Most ... This section lists the system variables that are specific to the Group Replication ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-unexpected-replica-halt.html
As a table, updates to the applier metadata repository are committed together with the transactions, meaning that the replica's progress information recorded in that repository is always consistent with what has been applied to the database, even in ... In order for replication to be resilient to unexpected halts of the server (sometimes described as crash-safe) it must be possible for the replica to recover its state before ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-configuration.html
See Section 16.1.3.4, “Setting Up Replication Using GTIDs” for how to configure a source using GTID-based replication. See Section 16.1.2.1, “Setting the Replication Source Configuration” for how to configure a source using file position ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-innodb-cluster-introduction.html
For more information on these technologies, see the user documentation linked in the descriptions. In addition to this user documentation, there is developer documentation for all AdminAPI methods in the MySQL Shell JavaScript API Reference or MySQL ...Advanced users can also take advantage of a multi-primary mode, where all instances are ... This chapter introduces MySQL InnoDB Cluster, which combines MySQL technologies to ...
https://dev.mysql.com/doc/refman/5.7/en/commit.html
Rolling back can be a slow operation that may occur implicitly without the user having explicitly asked for it (for example, when an error occurs). SET autocommit disables or enables the default autocommit mode for the current session. To disable ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-enterprise-security.html
Users who have logged in to Windows can connect from MySQL client programs to the server based on the information in their environment without specifying an additional password. LDAP Authentications supports user name and password, SASL, and ...PAM ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-table.html
if the user ID of the owner of the .frm, .MYD, or .MYI file is different from the user ID of the mysqld process, OPTIMIZE TABLE generates a "cannot change ownership of the file" error unless mysqld is started by the root user. The table and indexes ...OPTIMIZE TABLE reorganizes the physical storage of table data and associated index data, to reduce storage space and improve I/O efficiency when accessing the ...