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/environment-variables.html
The AND operation may remove read and write permissions from the directory mode, but not execute permissions. This section lists environment variables that are used directly or indirectly by MySQL. Most of these can also be found in other places in ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-ip-address-permissions.html
A host name that cannot be resolved is not considered for allowlist validation, and a warning message is written to the error log. The Group Replication plugin has a configuration option to determine from which hosts an incoming Group Communication ...
https://dev.mysql.com/doc/refman/5.7/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. For ...(By contrast, the index file descriptor is shared between all sessions.) The table_open_cache and max_connections system variables affect the maximum number of files the server keeps ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-reading.html
The plugin opens each remaining candidate file, verifies that the file actually contains JSON audit events, and sorts the files using the timestamps from the first event of each file. For example: [ { "timestamp": "2020-05-18 13:39:33", "id": 0, ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-wait-summary-tables.html
COUNT_STAR, SUM_TIMER_WAIT, MIN_TIMER_WAIT, AVG_TIMER_WAIT, MAX_TIMER_WAIT These columns aggregate all I/O operations. COUNT_READ, SUM_TIMER_READ, MIN_TIMER_READ, AVG_TIMER_READ, MAX_TIMER_READ These columns aggregate all read operations. The ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlocks-handling.html
It explains how to organize database operations to minimize deadlocks and the subsequent error handling required in applications. You can cope with deadlocks and reduce the likelihood of their occurrence with the following techniques: At any time, ... This section builds on the conceptual information about deadlocks in Section 14.7.5.2, “Deadlock ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-mapping.html
(On a case-insensitive file system, both letters are treated as the same.) For some blocks, such as Cyrillic, the second byte determines lettercase. There is a correspondence between database and table identifiers and names in the file system. For ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-transaction-management.html
For example, an application might encounter performance issues if it commits thousands of times per second, and different performance issues if it commits only every 2-3 hours. When each change is followed by a commit (as with the default autocommit ... To optimize InnoDB transaction processing, find the ideal balance between the performance overhead of transactional features and the workload of your ...
https://dev.mysql.com/doc/refman/5.7/en/processlist-access.html
For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the replica host. If a thread stays in a given state for many seconds, there might be a problem that needs to be ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-provision-replica.html
If the sources in the multi-source replication topology have existing data, it can save time to provision the replica with the relevant data before starting replication. This statement transfers the GTIDs for the transactions executed on the source ...In a multi-source replication topology, copying the data directory cannot be used to provision the replica with data from all of the sources, and you might also want to replicate only specific databases from each ...