PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/monitor-mysql-memory-use.html
The TIMED column in the setup_instruments table is ignored for memory instruments because memory operations are not timed. The following example demonstrates how to use Performance Schema and sys schema to monitor MySQL memory usage. Instruments ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbinfo-locks-per-fragment.html
This table also shows the total time spent waiting for locks successfully and unsuccessfully since fragment or table creation, or since the most recent restart. This is also true for the time values shown in the wait_ok_millis and wait_fail_millis ... The locks_per_fragment table provides information about counts of lock claim requests, and the outcomes of these requests on a per-fragment basis, serving as a companion table to operations_per_fragment and ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-config.html
(To obtain configuration data from the management node instead, simply omit this option.) --connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-sign-keys.html
--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value -1 Maximum Value 12 Set the number of times that ndb_sign_keys attempts to connect to the cluster. --connect-retry-delay Command-Line Format ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-waiter.html
ndb_waiter repeatedly (each 100 milliseconds) prints out the status of all cluster data nodes until either the cluster reaches a given status or the --timeout limit is exceeded, then exits. --connect-retries Command-Line Format --connect-retries=# ...By default, it waits for the cluster to achieve STARTED status, in which all nodes have started and connected to the ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-replication-schema.html
This works for these algorithms since they both map a WRITE_ROW event to an insert or update depending on whether the row already exists, and the required metadata (the “after” image for the timestamp column) is present in the “WRITE_ROW” ...
https://dev.mysql.com/doc/refman/9.7/en/mysqladmin.html
Thus, the next time you invoke mysqladmin (or any other client program) using the same account, you must specify the new password. Slow queries The number of queries that have taken more than long_query_time seconds. --connect-timeout=value ...You ...
https://dev.mysql.com/doc/refman/9.7/en/mysqlcheck.html
If you use the --databases or --all-databases option to process all tables in one or more databases, an invocation of mysqlcheck might take a long time. --extended, -e Command-Line Format --extended If you are using this option to check tables, it ... The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes ...
https://dev.mysql.com/doc/refman/9.7/en/nested-loop-joins.html
Nested-Loop Join Algorithm Nested-Loop Join Algorithm A simple nested-loop join (NLJ) algorithm reads rows from the first table in a loop one at a time, passing each row to a nested loop that processes the next table in the join. This process is ...
https://dev.mysql.com/doc/refman/9.7/en/optimize-table.html
To keep the index maintenance period to a reasonable time, set the innodb_ft_num_word_optimize option to specify how many words to update in the search index, and run a sequence of OPTIMIZE TABLE statements until the search index is fully updated.