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/data-size.html
Smaller tables normally require less main memory while their contents are being actively processed during query execution. With ROW_FORMAT=REDUNDANT, CHAR(N) occupies N × the maximum byte length of the character set. With the compact family of rows ... Design your tables to minimize their space on the ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-types.html
However, it is not difficult in MySQL to create partitioning schemes based on DATE, TIME, or DATETIME columns, or based on expressions making use of such columns. When partitioning by KEY or LINEAR KEY, you can use a DATE, TIME, or DATETIME column ... This section discusses the types of partitioning which are available in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/sha256-pluggable-authentication.html
For example: $> mysql --ssl-mode=DISABLED -u sha256user -p Enter password: password For this connection attempt by sha256user, the server determines that sha256_password is the appropriate authentication plugin and invokes it (because that was the ... MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: sha256_password: Implements basic SHA-256 ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-configuration.html
In this case, the server does not acquire the query cache mutex at all, which means that the query cache cannot be enabled at runtime and there is reduced overhead in query execution. Note You can set the maximum size that can be specified for the ...For example, a client can disable use of the query cache for its own queries like this: mysql> SET SESSION query_cache_type = OFF; If you set query_cache_type at server startup (rather than at runtime with a SET statement), only the numeric values are ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndbmtd.html
This can be done by setting an appropriate value in the config.ini file for the MaxNoOfExecutionThreads configuration parameter or the ThreadConfig configuration parameter. Trace files are generated by critical errors in ndbmtd processes in a ...
https://dev.mysql.com/doc/refman/5.7/en/ndb-restore-different-number-nodes.html
This needs to be done once for each data node in the original cluster, each time using that data node's node ID. Recreating the indexes avoids errors due to the restore not being consistent at all points. To rebuild the indexes, execute the ... It ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-setting.html
Some statements require a lot of execution time on the source, but result in just a few rows being modified. It is possible to change the logging format to STATEMENT, but doing so at runtime leads very rapidly to errors because InnoDB can no longer ...The logging format also can be switched at runtime, although note that there are a number of situations in which you cannot do this, as discussed later in this ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-configuration-variables.html
Different settings work best for servers with light, predictable loads, versus servers that are running near full capacity all the time, or that experience spikes of high activity. Preventing one-time operations such as table scans from interfering ...Because the InnoDB storage engine performs many of its optimizations automatically, many performance-tuning tasks involve monitoring to ensure that the database is performing well, and changing configuration options when performance ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer.html
Note If the first-time or subsequent manifest download is unsuccessful, an error is logged and you may have limited access to MySQL products during your session. It is downloaded with and supports the following MySQL products: MySQL Servers MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-backups.html
In this case, the backup can be started by executing this statement on the replication source: shellS> ndb_mgm -e "START BACKUP" Method B. Important A CREATE DATABASE (or CREATE SCHEMA) statement corresponding to each database to be replicated must ... This section discusses making backups and restoring from them using NDB Cluster ...