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/sys-schema-index-statistics.html
select_latency The total wait time of timed reads using the index. insert_latency The total wait time of timed inserts into the index. update_latency The total wait time of timed updates in the index. delete_latency The total wait time of timed ...
https://dev.mysql.com/doc/refman/5.7/en/replication-semisync.html
Fully synchronous replication means failover from the source to any replica is possible at any time. The source does not wait for all replicas to acknowledge receipt, and it requires only an acknowledgement from the replicas, not that the events ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-group-membership.html
The group is dynamic and servers can leave (either voluntarily or involuntarily) and join it at any time. Every server in the group has a consistent view of which servers are the members participating actively in the group at a given moment in time.
https://dev.mysql.com/doc/refman/5.7/en/ndb-restore-different-number-nodes.html
This needs to be done once for each data node in the original cluster, each time using that data node's node ID. Recreating the indexes avoids errors due to the restore not being consistent at all points. To rebuild the indexes, execute the ... It ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-prepared-statements-instances-table.html
These columns can be used to find stored programs that leak prepared statements: SELECT OWNER_OBJECT_TYPE, OWNER_OBJECT_SCHEMA, OWNER_OBJECT_NAME, STATEMENT_NAME, SQL_TEXT FROM performance_schema.prepared_statements_instances WHERE OWNER_OBJECT_TYPE ...C API Function Corresponding Server Command mysql_stmt_prepare() COM_STMT_PREPARE mysql_stmt_execute() COM_STMT_EXECUTE mysql_stmt_close() COM_STMT_CLOSE The text ...
https://dev.mysql.com/doc/refman/5.7/en/json.html
A maximum of 3 JSON columns per NDB table is supported. MySQL parses any string used in a context that requires a JSON value, and produces an error if it is not valid as JSON. Positions for “at position N” in such error messages are 0-based, but ...The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-backups.html
In this case, the backup can be started by executing this statement on the replication source: shellS> ndb_mgm -e "START BACKUP" Method B. Important A CREATE DATABASE (or CREATE SCHEMA) statement corresponding to each database to be replicated must ... This section discusses making backups and restoring from them using NDB Cluster ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-failover.html
Important You must ensure that the replica mysqld is started with --slave-skip-errors=ddl_exist_errors before executing START SLAVE. In the event that the primary Cluster replication process fails, it is possible to switch over to the secondary ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-functions.html
MySQL Enterprise Encryption functions have these general characteristics: For arguments of the wrong type or an incorrect number of arguments, each function returns an error. (OpenSSL imposes its own key-length limits, and server administrators can ...If the arguments are not suitable to permit a function to perform the requested operation, it returns NULL or 0 as ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-filtering.html
The setup_instruments table lists the instruments for which events can be collected, whether they are enabled, and (for enabled instruments) whether to collect timing information: mysql> SELECT * FROM performance_schema.setup_instruments; ... Events ...