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/ndb-restore-different-number-nodes.html
It is possible to restore from an NDB backup to a cluster having a different number of data nodes than the original from which the backup was taken. The following two sections discuss, respectively, the cases where the target cluster has a lesser ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-numeric.html
You also save code in your application because you can avoid parsing the text file to find line and column boundaries. For unique IDs or other values that can be represented as either strings or numbers, prefer numeric columns to string columns.
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-logging.html
Thus, if you have transactions that update, insert, or delete many rows, making the log buffer larger saves disk I/O. Consider the following guidelines for optimizing redo logging: Make your redo log files big, even as big as the buffer pool. When ...
https://dev.mysql.com/doc/refman/5.7/en/password-security-user.html
If your command interpreter is configured to maintain a history, any file in which the commands are saved contains MySQL passwords entered on the command line. MySQL users should use the following guidelines to keep passwords secure. When you run a ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-monitoring.html
A value of Performance_schema_mutex_classes_lost greater than 0 can happen in two cases: To save a few bytes of memory, you start the server with --performance_schema_max_mutex_classes=N, where N is less than the default value. Names for these ...
https://dev.mysql.com/doc/refman/5.7/en/point-in-time-recovery-binlog.html
To view events from the log, send mysqlbinlog output into a paging program: $> mysqlbinlog binlog_files | more Alternatively, save the output in a file and view the file in a text editor: $> mysqlbinlog binlog_files > tmpfile $> ... This section ...
https://dev.mysql.com/doc/refman/5.7/en/repair-table-optimization.html
REPAIR TABLE for MyISAM tables is similar to using myisamchk for repair operations, and some of the same performance optimizations apply: myisamchk has variables that control memory allocation. You may be able to its improve performance by setting ...
https://dev.mysql.com/doc/refman/5.7/en/replication-bugs.html
When you have determined that there is no user error involved, and replication still either does not work at all or is unstable, it is time to send us a bug report. We need to obtain as much information as possible from you to be able to track down ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-provision-replica.html
If the sources in the multi-source replication topology have existing data, it can save time to provision the replica with the relevant data before starting replication. In a multi-source replication topology, copying the data directory cannot be ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options.html
If data_dir/auto.cnf is not found, generate a new UUID and save it to this file, creating the file if necessary. The following sections contain information about mysqld options and server variables that are used in replication and for controlling ...