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/mysql-cluster-logs-event-buffer.html
NDB uses one or more memory buffers for events received from the data nodes. There is one such buffer for each Ndb object subscribing to table events, which means that there are usually two buffers for each mysqld performing binary logging (one ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-monitoring.html
row *************************** CHANNEL_NAME: source_1 GROUP_NAME: SOURCE_UUID: 046e41f8-a223-11e4-a975-0811960cc264 THREAD_ID: 24 SERVICE_STATE: ON COUNT_RECEIVED_HEARTBEATS: 0 LAST_HEARTBEAT_TIMESTAMP: 0000-00-00 00:00:00 RECEIVED_TRANSACTION_SET: ... To monitor the status of replication channels the following options exist: Using the replication Performance Schema ...
https://dev.mysql.com/doc/refman/5.7/en/install-plugin.html
For example, set its value in a my.cnf file: [mysqld] plugin_dir=/path/to/plugin/directory If the value of plugin_dir is a relative path name, it is taken to be relative to the MySQL base directory (the value of the basedir system variable). A ...It ... INSTALL PLUGIN plugin_name SONAME 'shared_library_name' This statement installs a server ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-instruments-table.html
The setup_instruments table lists classes of instrumented objects for which events can be collected: mysql> SELECT * FROM performance_schema.setup_instruments; +---------------------------------------------------+---------+-------+ | NAME | ENABLED ...| wait/io/file/sql/binlog | YES | YES | | wait/io/file/sql/binlog_index | YES | YES | | wait/io/file/sql/casetest | YES | YES | | wait/io/file/sql/dbopt | YES | YES | ...
https://dev.mysql.com/doc/refman/5.7/en/replica-sql-thread-states.html
Making temporary file (create) before replaying LOAD DATA INFILE The thread is executing a LOAD DATA statement and is creating a temporary file containing the data from which the replica reads rows. Slave has read all relay log; waiting for more ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema.html
It is implemented using the PERFORMANCE_SCHEMA storage engine and the performance_schema database. Performance Schema configuration can be modified dynamically by updating tables in the performance_schema database through SQL statements. Note The ...
https://dev.mysql.com/doc/refman/5.7/en/mrr-optimization.html
With the Disk-Sweep Multi-Range Read (MRR) optimization, MySQL tries to reduce the number of random disk access for range scans by first scanning the index only and collecting the keys for the relevant rows. The motivation for Disk-sweep MRR is to ... Reading rows using a range scan on a secondary index can result in many random disk accesses to the base table when the table is large and not stored in the storage engine's ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-config.html
The options returned are tied to the specific compiler that was used when the library was created and might clash with the settings for your own compiler. mysql_config provides you with useful information for compiling your MySQL client and ...It ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-transactions-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored transaction event, so there is no system variable for configuring the table size. For example: mysql> SELECT * FROM ...Other tables that contain ...
https://dev.mysql.com/doc/refman/5.7/en/replica-io-thread-states.html
The thread is sleeping for the number of seconds set by the CHANGE MASTER TO statement (default 60) before attempting to reconnect. The following list shows the most common states you see in the State column for a replica server I/O thread. When ...