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/replication-gtids-howto.html
This is a “cold start” procedure that assumes either that you are starting the replication source server for the first time, or that it is possible to stop it; for information about provisioning replicas using GTIDs from a running source, see ...
https://dev.mysql.com/doc/refman/5.7/en/install-plugin.html
A plugin is initialized by executing its initialization function, which handles any setup that the plugin must perform before it can be used. When the server shuts down, it executes the deinitialization function for each plugin that is loaded so ...
https://dev.mysql.com/doc/refman/5.7/en/command-line-options.html
For example, the following command tells mysqladmin to ping the server 1024 times, sleeping 10 seconds between each ping: mysqladmin --count=1K --sleep=10 ping When specifying file names as option values, avoid the use of the ~ shell metacharacter.
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-what-is-new-7-6.html
Previously, it was sometimes the case that increasing the number of LDM threads could lead to index memory exhaustion while large amounts of DataMemory remained available. A system name based on the time the management server was started is ... New ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache.html
If an identical statement is received later, the server retrieves the results from the query cache rather than parsing and executing the statement again. Note The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL 8.0. The query ...
https://dev.mysql.com/doc/refman/5.7/en/set-transaction.html
If executed between transactions, the statement overrides any preceding statement that sets the next-transaction value of the named characteristics. The statement is not permitted within transactions: mysql> START TRANSACTION; Query OK, 0 rows ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-locks-table.html
Although LOCK_ID currently contains TRX_ID, the format of the data in LOCK_ID is subject to change at any time. Secondary index values of the locked record are shown for a lock placed on a unique secondary index. Secondary index values are shown ...
https://dev.mysql.com/doc/refman/5.7/en/charset-applications.html
Specify character settings at configuration time, if you build MySQL from source. If most or all applications use the same character set, specifying character settings at server startup or configuration time may be most convenient. Applications that ... For applications that store data using the default MySQL character set and collation (latin1, latin1_swedish_ci), no special configuration should be ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-metrics-table.html
(The _RESET columns act like the lap counter on a stopwatch: you can measure the activity during some time interval, while the cumulative figures are still available in COUNT, MAX_COUNT, and so on.) MAX_COUNT_RESET The maximum counter value since it ...row *************************** NAME: dml_inserts SUBSYSTEM: dml COUNT: 3 MAX_COUNT: 3 MIN_COUNT: NULL AVG_COUNT: 0.046153846153846156 COUNT_RESET: 3 MAX_COUNT_RESET: 3 MIN_COUNT_RESET: NULL AVG_COUNT_RESET: NULL TIME_ENABLED: 2014-12-04 14:18:28 TIME_DISABLED: NULL TIME_ELAPSED: 65 TIME_RESET: NULL STATUS: enabled TYPE: status_counter COMMENT: Number of rows inserted Notes You must have the PROCESS privilege to query this ...
https://dev.mysql.com/doc/refman/5.7/en/show-columns.html
The data types may differ from what you expect them to be based on a CREATE TABLE statement because MySQL sometimes changes data types when you create or alter a table. Key Whether the column is indexed: If Key is empty, the column either is not ...