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-online-add-node-example.html
In this section we provide a detailed example illustrating how to add new NDB Cluster data nodes online, starting with an NDB Cluster having 2 data nodes in a single node group and concluding with a cluster having 4 data nodes in 2 node groups.
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-params-ndbd.html
IndexStatSaveScale: Scaling factor used in determining size of stored index statistics. MaxNoOfSavedMessages: Maximum number of error messages to write in error log and maximum number of trace files to retain. The listings in this section provide ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-restore.html
The option checks before attempting to log whether all the tables being restored have explicitly defined primary keys; queries on a table having only the hidden primary key implemented by NDB cannot be converted to valid SQL. It requires as its ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication.html
These counters are implemented as NDB statistics _slave status variables, as seen in the output of SHOW STATUS, or in the results of queries against the SESSION_STATUS or GLOBAL_STATUS table in a mysql client session connected to a MySQL Server that ... NDB Cluster supports asynchronous replication, more usually referred to simply as ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html
If --set-gtid-purged=ON is required, it can be used with --lock-all-tables, but this can prevent parallel queries while mysqldump is being run. The mysqldump client utility performs logical backups, producing a set of SQL statements that can be ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-system-variables.html
This variable should not be changed, unless to set it to 0 to disable all statement instrumentation and save all memory associated with it. This implementation queries active thread data from the Performance Schema rather than the thread manager and ...The Performance Schema automatically sizes the values of several of its parameters at server startup if they are not set ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-timing.html
Events are collected by means of instrumentation added to the server source code. Instruments time events, which is how the Performance Schema provides an idea of how long events take. It is also possible to configure instruments not to collect ...
https://dev.mysql.com/doc/refman/5.7/en/adding-collation-choosing-id.html
| | 247 | +-----+ Warning Before upgrading, you should save the configuration files that you change. To add a collation, you must choose an ID value that is not currently used. The range of IDs from 1024 to 2047 is reserved for user-defined ...
https://dev.mysql.com/doc/refman/5.7/en/backup-policy.html
To make incremental backups, we need to save the incremental changes. A full backup (a snapshot of the data at a point in time) can be done in MySQL with several tools. For example, MySQL Enterprise Backup can perform a physical backup of an entire ...
https://dev.mysql.com/doc/refman/5.7/en/caching-sha2-pluggable-authentication.html
A client user who can connect to the server some other way can use a SHOW STATUS LIKE 'Caching_sha2_password_rsa_public_key' statement and save the returned key value in a file. MySQL provides two authentication plugins that implement SHA-256 ...