PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-internals.html
flags The InnoDB table columns that are used as flags (a user-defined numeric value that is stored and retrieved along with the main value) for memcached. mysql> USE innodb_memcache; Database changed mysql> SHOW TABLES; +---------------------------+ ... InnoDB API for the InnoDB memcached Plugin The InnoDB memcached engine accesses InnoDB through InnoDB APIs, most of which are directly adopted from embedded ...
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/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/group-replication-secure-socket-layer-support-ssl.html
However, a user that requires an SSL connection must have been created before the server joining the group connects to the donor. new_member> SET GLOBAL group_replication_recovery_use_ssl=1; new_member> SET GLOBAL group_replication_recovery_ssl_ca= ...Configuring SSL for Group Replication Recovery Recovery is performed through a regular asynchronous replication ...
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 ...
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/innodb-persistent-stats.html
To override these system-wide settings and configure optimizer statistics parameters for individual tables, you can define STATS_PERSISTENT, STATS_AUTO_RECALC, and STATS_SAMPLE_PAGES clauses in CREATE TABLE or ALTER TABLE statements. The value ...
https://dev.mysql.com/doc/refman/5.7/en/invoking-programs.html
For example, the mysql program interprets the first nonoption argument as a database name, so the command mysql --user=root test indicates that you want to use the test database. The most frequently used of these are the --host (or -h), --user (or ...$> mysql --user=root test $> mysqladmin extended-status variables $> mysqlshow --help $> mysqldump -u root personnel Arguments that begin with a single or double dash (-, --) specify program ... To invoke a MySQL ...
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/create-table-foreign-keys.html
InnoDB does not currently support foreign keys for tables with user-defined partitioning. This restriction does not apply for NDB tables that are partitioned by KEY or LINEAR KEY (the only user partitioning types supported by the NDB storage ...For ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...