PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/table-cache.html
When you execute a mysqladmin status command, you should see something like this: Uptime: 426 Running threads: 1 Questions: 11082 Reloads: 1 Open tables: 12 The Open tables value of 12 can be somewhat puzzling if you have fewer than 12 tables. (By ...MySQL is multithreaded, so there may be many clients issuing queries for a given table ...
https://dev.mysql.com/doc/refman/8.0/en/backup-policy.html
The incremental backups are smaller and take less time to produce. A full backup (a snapshot of the data at a point in time) can be done in MySQL with several tools. For example, MySQL Enterprise Backup can perform a physical backup of an entire ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-show-tables.html
--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving up. By default, this includes not only both user-created tables and NDB system ... ndb_show_tables displays a list of all NDB database objects in the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-metadata-locks-table.html
Lock requests that have timed out and are waiting for the requesting session's lock request to be discarded. When a pending lock request times out (ER_LOCK_WAIT_TIMEOUT), its row status is updated from PENDING to TIMEOUT. The VICTIM, TIMEOUT, and ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema.html
An “event” is anything the server does that takes time and has been instrumented so that timing information can be collected. This enables you to determine how many times instrumented activities were performed and how much time they took. The ...
https://dev.mysql.com/doc/refman/8.0/en/monitor-innodb-mutex-waits-performance-schema.html
The ENABLED and TIMED columns should be set to YES for the instruments that you enabled. The following query returns the instrument name (EVENT_NAME), the number of wait events (COUNT_STAR), and the total wait time for the events for that instrument ... A mutex is a synchronization mechanism used in the code to enforce that only one thread at a given time can have access to a common ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-components.html
Typically, a sink processes log events into log messages that have a particular format and writes these messages to its associated output, such as a file or the system log. The following sections describe individual log components, grouped by ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-config-starting.html
TimeBetweenGlobalCheckpoints=1000 TimeBetweenEpochs=200 RedoBuffer=32M # CompressedLCP=1 # CompressedBackup=1 # Enabling CompressedLCP and CompressedBackup causes, respectively, local checkpoint files and backup files to be compressed, which can ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-upgrading-member.html
Note The longer it takes to upgrade a server, the more time that member is offline and therefore the more time it takes for the server to catch up when added back to the group. The process of upgrading a member of a group is common to all methods ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-operations-per-fragment.html
Since NDB does not use single-key access for ordered indexes, the counts for tot_key_reads, tot_key_inserts, tot_key_updates, tot_key_writes, and tot_key_deletes are not incremented by ordered index operations. Note When using tot_key_writes, you ...