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/group-replication-adding-instances.html
20.2.1.6.1 Adding a Second Instance In order to add a second instance, server s2, first create the configuration file for it. If you did not have binary logging enabled when you configured the user credentials on s1, and a remote cloning operation ... At this point, the group has one member in it, server s1, which has some data in ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-status-monitoring.html
When the server cannot create a mutex instrument, these results occur: No row for the instrument is inserted into the setup_instruments table. Performance_schema_xxx_instances_lost indicates how many instances of object type xxx could not be created. If the server cannot create a given instrumented mutex instance, it increments ...Names for these variables have several forms: ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-restrictions.html
Full-text searches are supported for InnoDB and MyISAM tables only. A character-based ngram full-text parser that supports Chinese, Japanese, and Korean (CJK), and a word-based MeCab parser plugin that supports Japanese are provided for use with ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-requirements.html
Convert any tables in other storage engines to use InnoDB before using the instance with Group Replication. Every table that is to be replicated by the group must have a defined primary key, or primary key equivalent where the equivalent is a ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-key-cache.html
It employs a cache mechanism to keep the most frequently accessed table blocks in memory: For index blocks, a special structure called the key cache (or key buffer) is maintained. You can set up multiple key caches and assign table indexes to ... To ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-disk-data-storage-requirements.html
The following items apply to Disk Data storage requirements: Variable-length columns of Disk Data tables take up a fixed amount of space. You can obtain an estimate the amount of space available in data files and undo log files by querying the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-sql-statements.html
SHOW ENGINE NDB STATUS, SHOW ENGINE NDBCLUSTER STATUS The output of this statement contains information about the server's connection to the cluster, creation and usage of NDB Cluster objects, and binary logging for NDB Cluster replication. However, ... This section discusses several SQL statements that can prove useful in managing and monitoring a MySQL server that is connected to an NDB Cluster, and in some cases provide information about the cluster ...
https://dev.mysql.com/doc/refman/8.0/en/outer-join-simplification.html
Table expressions in the FROM clause of a query are simplified in many cases. When the optimizer evaluates plans for outer join operations, it takes into consideration only plans where, for each such operation, the outer tables are accessed before ...At the parser stage, queries with right outer join operations are converted to equivalent queries containing only left join ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-atom-molecule-events.html
For a table I/O event, there are usually two rows in events_waits_current, not one. For example, a row fetch might result in rows like this: Row# EVENT_NAME TIMER_START TIMER_END ---- ---------- ----------- --------- 1 wait/io/file/myisam/dfile ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-query-profiling.html
The setup_actors table can be used to limit the collection of historical events by host, user, or account to reduce runtime overhead and the amount of data collected in history tables. For example: mysql> SELECT * FROM employees.employees WHERE ...