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/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/testing-server.html
For example: $> bin/mysqld_safe --user=mysql & If mysqld_safe fails, see Section 2.9.2.1, “Troubleshooting Problems Starting the MySQL Server”. If you have assigned a password for the root account already, you'll also need to specify -p on the ... After the data directory is initialized and you have started the server, perform some simple tests to make sure that it works ...This section assumes that ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-configuring-io-capacity.html
It should be set to approximately the number of I/O operations that the system can perform per second (IOPS). When innodb_io_capacity is set, InnoDB estimates the I/O bandwidth available for background tasks based on the set value. For busy systems ... The InnoDB master thread and other threads perform various tasks in the background, most of which are I/O related, such as flushing dirty pages from the buffer pool and writing changes from the change buffer to the appropriate secondary ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-summary-tables.html
Summary tables provide aggregated information for terminated events over time. Tables that summarize events in similar ways often have similar sets of summary columns and differ only in the grouping columns used to determine how events are ...The ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-logging-configuration.html
For best security, write the audit log to a directory accessible only to the MySQL server and to users with a legitimate reason to view the log. Encryption is based on a user-defined password (with the exception of the initial password, which the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-security.html
memcp --servers=localhost:11211 --binary --username=testname --password=password myfile.txt memcat --servers=localhost:11211 --binary --username=testname --password=password myfile.txt If you specify an incorrect user name or password, the operation ...Password-Protecting memcached Using SASL SASL support provides the capability to protect your MySQL database from unauthenticated access through memcached ... Caution ...Because memcached does not use an authentication mechanism by default, and the optional SASL authentication is not as strong as traditional DBMS security ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-storage-engines.html
The following limitations apply to the use of storage engines with user-defined partitioning of tables. Exception (not for production): It is possible to override this restriction by setting the new system variable on NDB Cluster SQL nodes to ON.
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-performance.html
row *************************** Id: 5 User: root Host: localhost db: test Command: Query Time: 44 State: Waiting for table metadata lock Info: ALTER TABLE t1 ADD COLUMN x INT, ALGORITHM=INPLACE, LOCK=NONE ... When evaluating the techniques for ...
https://dev.mysql.com/doc/refman/5.7/en/server-option-variable-reference.html
Please see the corresponding item descriptions for details on setting and using the options and variables. If a server option set on the command line or in an option file differs from the name of the corresponding system variable, the variable name ... The following table lists all command-line options, system variables, and status variables applicable within ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-backup-using-management-client.html
The first node to complete its part in aborting the backup reports that the reason for the abort was due to a request by the user. Error: 1321 - Backup aborted by user request: Permanent error: User defined error Node 3: Backup 3 started from 5 has ... Before starting a backup, make sure that the cluster is properly configured for performing ...If an ...