PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/index-statistics.html
When a given index value yields a large number of rows, the index is less useful and MySQL is less likely to use it. The SHOW INDEX statement displays a cardinality value based on N/S, where N is the number of rows in the table and S is the average ... Storage engines collect statistics about tables for use by the ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-character.html
When you use a randomly generated value as a primary key in an InnoDB table, prefix it with an ascending value such as the current date and time if possible. For character and string columns, follow these guidelines: Use binary collation order for ...You can use the BINARY operator to use binary collation within a particular ...
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/mysql-cluster-security-mysql-security-procedures.html
In this section, we discuss MySQL standard security procedures as they apply to running NDB Cluster. In general, any standard procedure for running MySQL securely also applies to running a MySQL Server as part of an NDB Cluster. First and foremost, ...Fortunately, this is the default behavior for a new MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-types.html
However, you can use other date and time functions that return an integer or NULL, such as WEEKDAY(), DAYOFYEAR(), or MONTH(). See Section 14.7, “Date and Time Functions”, for more information about such functions. However, it is not difficult ...This type of partitioning is similar to partitioning by HASH, except that only one or more columns to be evaluated are supplied, and the MySQL server provides its own hashing ...
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 ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-drop-index.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. --connect-retry-delay Command-Line Format --connect-retry-delay=# Type ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-select-all.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. This does not affect the output of numerals contained in strings or ...