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/table-locking.html
In this case, the second SELECT statement in the preceding scenario would execute before the UPDATE statement, and would not wait for the first SELECT to finish. But because only one session can write to a table at any one time, for best performance ... InnoDB tables use row-level locking so that multiple sessions and applications can read from and write to the same table simultaneously, without making each other wait or producing inconsistent ...
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/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/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-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/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/data-types.html
fsp applies to the TIME, DATETIME, and TIMESTAMP types and represents fractional seconds precision; that is, the number of digits following the decimal point for fractional parts of seconds. MySQL supports SQL data types in several categories: ...
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 ...