PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-tde-setup.html
Start the management server with either --initial or --reload to cause it to read the updated configuration file. Perform a rolling initial start (or restart) of all the data nodes (see Section 25.6.5, “Performing a Rolling Restart of an NDB ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-indexes.html
Indexes are used to find rows with specific column values quickly. Without an index, MySQL must begin with the first row and then read through the entire table to find the relevant rows. If the table has an index for the columns in question, MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-installer-workflow.html
Windows requires a newly added member to first log out and then log in again to join a local group. MySQL Installer provides a wizard-like tool to install and configure new MySQL products for Windows. Unlike the initial setup, which runs only once, ...
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-attributes.html
If you store values larger than the display width in an integer column that has the ZEROFILL attribute, you may experience problems when MySQL generates temporary tables for some complicated joins. MySQL supports an extension for optionally ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-blob.html
For a table with several columns, to reduce memory requirements for queries that do not use the BLOB column, consider splitting the BLOB column into a separate table and referencing it with a join query when needed. When storing a large blob ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-character.html
If a table contains string columns such as name and address, but many queries do not retrieve those columns, consider splitting the string columns into a separate table and using join queries with a foreign key when necessary. For character and ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-features-to-trace.html
They are: Greedy search: With an N-table join, this could explore factorial(N) plans. dynamic_range: Only the first call to the range optimizer on this JOIN_TAB::SQL_SELECT is traced. Some features in the optimizer can be invoked many times during ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-queries-myisam.html
(For unique indexes, this is always 1.) MySQL uses this to decide which index to choose when you join two tables based on a nonconstant expression. Some general tips for speeding up queries on MyISAM tables: To help MySQL better optimize queries, ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-asynchronous-connection-failover-table.html
When asynchronous connection failover is enabled for a group of replicas managed by Group Replication, the source lists are broadcast to all group members when they join, and also when the lists change. This table holds the replica's source lists ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-group-members-table.html
RECOVERING: The server has joined a group from which it is retrieving data. This table shows network and status information for replication group members. The network addresses shown are the addresses used to connect clients to the group, and ...