PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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 ...
https://dev.mysql.com/doc/refman/5.7/en/out-of-range-and-overflow.html
If no restrictive modes are enabled, MySQL clips the value to the appropriate endpoint of the column data type range and stores the resulting value instead. When an out-of-range value is assigned to an integer column, MySQL stores the value ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-linear-hash.html
We call this value V; it can be calculated as: V = POWER(2, CEILING(LOG(2, num))) (Suppose that num is 13. MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-connection-tables.html
Summary tables that depend on the connection table are implicitly truncated, as described later in this section. When a client connects to the MySQL server, it does so under a particular user name and from a particular host. They differ in that, ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-instrument-filtering.html
This affects primarily mutexes, conditions, and rwlocks in the server, although there may be other instruments for which this is true. The setup_instruments table lists the available instruments: mysql> SELECT * FROM ...