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-limitations-performance.html
See Section 8.9.4, “Index Hints”, for more information on how to do this. The following performance issues are specific to or especially pronounced in NDB Cluster: Range scans. There are query performance issues due to sequential access to the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndb-transporter-errors.html
This section lists error codes, names, and messages that are written to the cluster log in the event of transporter errors. 0x00 TE_NO_ERROR No error 0x01 TE_ERROR_CLOSING_SOCKET Error found during closing of socket 0x02 ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-move-data.html
--ndb-nodeid Command-Line Format --ndb-nodeid=# Type Integer Default Value [none] Set node ID for this node, overriding any ID set by --ndb-connectstring. Usage The program is invoked with the names of the source and target tables; either or both of ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-print-backup-file.html
This can be any of the files (.Data, .ctl, or .log file) found in a cluster backup directory. Because it does not make use of the management server, this utility can be used when the management server is not running, and even when the cluster has ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-print-sys-file.html
Cluster system files are located in a data node's data directory (DataDir); the path under this directory to system files matches the pattern ndb_#_fs/D#/DBDIH/P#.sysfile. Because it does not make use of the management server, this utility can be ...
https://dev.mysql.com/doc/refman/5.7/en/mysqld.html
Invoke this version instead of mysqld for debugging support, memory allocation checking, and trace file support (see Section 5.8.1.2, “Creating Trace Files”). For a complete list of options, run this command: mysqld --verbose --help MySQL Server ... mysqld, also known as MySQL Server, is a single multithreaded program that does most of the work in a MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-upgrade-testing.html
(This is also useful for testing downgrades.) On the production server: $> mysqldump --all-databases --no-data --routines --events > dump-defs.sql On the upgraded server: $> mysql < dump-defs.sql Because the dump file does not contain table data, it ... When contemplating a MySQL upgrade, it is prudent to install the newer version separately from your current production ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-many-tables.html
This step can take significant time on systems that partition the data into many tables. Since this overhead only applies to the initial table open operation, to “warm up” a table for later use, access it immediately after startup by issuing a ... If you have configured non-persistent optimizer statistics (a non-default configuration), InnoDB computes index cardinality values for a table the first time that table is accessed after startup, instead of storing such values in the ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-storage-layout.html
This is a straightforward technique that can improve performance when other techniques such as improving index usage or tuning application code are not practical. This operation can be slow if the table is large or if the indexes being rebuilt do ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-server.html
This section discusses optimization techniques for the database server, primarily dealing with system configuration rather than tuning SQL statements. The information in this section is appropriate for DBAs who want to ensure performance and ...