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/innodb-information-schema-system-tables.html
Traditionally, you would get this type of information using the techniques from Section 14.18, “InnoDB Monitors”, setting up InnoDB monitors and parsing the output from the SHOW ENGINE INNODB STATUS statement. The MODIFIED_COUNTER value shows ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-replication.html
The following sections show how to use the binary log capability when using the daemon_memcached plugin with MySQL replication. source $> mysqldump --all-databases --lock-all-tables > dbdump.db replica $> mysql < dbdump.db On the source server, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-setup.html
mysql> USE innodb_memcache; mysql> SHOW TABLES; +---------------------------+ | Tables_in_innodb_memcache | +---------------------------+ | cache_policies | | config_options | | containers | +---------------------------+ mysql> USE test; mysql> SHOW ... This section describes how to set up the daemon_memcached plugin on a MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-statistics-estimation.html
Running SHOW TABLE STATUS, SHOW INDEX, or querying the Information Schema TABLES or STATISTICS tables with the innodb_stats_on_metadata option enabled. Values much larger than 8 (say, 100), can cause a significant slowdown in the time it takes to ...
https://dev.mysql.com/doc/refman/5.7/en/json-modification-functions.html
mysql> SELECT JSON_MERGE('[1, 2]', '[true, false]'); +---------------------------------------+ | JSON_MERGE('[1, 2]', '[true, false]') | +---------------------------------------+ | [1, 2, true, false] | +---------------------------------------+ 1 ...
https://dev.mysql.com/doc/refman/5.7/en/json-utility-functions.html
JSON_STORAGE_SIZE() shows the amount of storage space used by a given JSON value. This section documents utility functions that act on JSON values, or strings that can be parsed as JSON values. JSON_PRETTY() prints out a JSON value in a format that ...
https://dev.mysql.com/doc/refman/5.7/en/ldap-pluggable-authentication.html
The following tables show the plugin and library file names for simple and SASL-based LDAP authentication. For examples showing how to set up MySQL accounts to use specific LDAP authentication plugins, see Using LDAP Pluggable Authentication. To ...
https://dev.mysql.com/doc/refman/5.7/en/macos-installation-prefpane.html
Figure 2.24 MySQL Preference Pane: Location Figure 2.25 MySQL Preference Pane: Usage The MySQL Preference Pane shows the current status of the MySQL server, showing stopped (in red) if the server is not running and running (in green) if the server ... The MySQL Installation Package includes a MySQL preference pane that enables you to start, stop, and control automated startup during boot of your MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-config-nodes.html
The config_nodes table shows nodes configured in an NDB Cluster config.ini file. The node_hostname column shows the node host as specified in the config.ini file. For each node, the table displays a row containing the node ID, the type of node ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-operations-per-fragment.html
This currently has the following formats: Base table: DbName/def/TblName BLOB table: DbName/def/NDB$BLOB_BaseTblId_ColNo Ordered index: sys/def/BaseTblId/IndexName Unique index: sys/def/BaseTblId/IndexName$unique The $unique suffix shown for unique ... The operations_per_fragment table provides information about the operations performed on individual fragments and fragment replicas, as well as about some of the results from these ...