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/replication-configuration.html
This section describes how to configure the different types of replication available in MySQL and includes the setup and configuration required for a replication environment, including step-by-step instructions for creating a new replication ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-log-statistics.html
Counters providing information about the state of the cluster are updated at 5-second reporting intervals by the transaction coordinator (TC) and the local query handler (LQH), and written to the cluster log. Because some transactions committed in ... The NDB management client's CLUSTERLOG STATISTICS command can provide a number of useful statistics in its ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-invalid-data.html
Invalid values for ENUM and SET columns are handled as described in Section 1.6.3.4, “ENUM and SET Constraints”. You can select stricter treatment of input values by using the STRICT_TRANS_TABLES or STRICT_ALL_TABLES SQL modes: SET sql_mode = ...
https://dev.mysql.com/doc/refman/5.7/en/external-locking.html
External locking is the use of file system locking to manage contention for MyISAM database tables by multiple processes. Do not start the server with the delay_key_write system variable set to ALL or use the DELAY_KEY_WRITE=1 table option for any ...Here are some examples: If you run multiple servers that use the same database directory (not recommended), each server must have external locking ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-statistics-table.html
Take this into account when specifying a prefix length for a nonbinary string column that uses a multibyte character set. TABLE_SCHEMA The name of the schema (database) to which the table containing the index belongs. INDEX_SCHEMA The name of the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-benefits.html
If you split up related data into different tables, you can set up foreign keys that enforce referential integrity. When you design a database with appropriate primary key columns for each table, operations involving those columns are automatically ... InnoDB tables have the following benefits: If the server unexpectedly exits because of a hardware or software issue, regardless of what was happening in the database at the time, you don't need to do anything special after restarting the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-indexes-table.html
For full-text indexes, the PAGE_NO column is unused and set to -1 (FIL_NULL) because the full-text index is laid out in several B-trees (auxiliary tables). The INNODB_SYS_INDEXES table provides metadata about InnoDB indexes, equivalent to the ...
https://dev.mysql.com/doc/refman/5.7/en/myisampack.html
--character-sets-dir=dir_name Command-Line Format --character-sets-dir=dir_name Type Directory name The directory where character sets are installed. When the table is used later, the server reads into memory the information needed to decompress ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-single-primary-mode.html
In this mode the group has a single-primary server that is set to read-write mode. All the other members in the group are set to read-only mode (with super-read-only=ON ). The primary is typically the first server to bootstrap the group, all other ...Upon primary member failure, an automatic primary election mechanism chooses the new primary ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-porting-memcached.html
If you store several different classes of information using memcached, consider setting up a separate InnoDB table for each type of data. Preferably, configure a stable set of table definitions for use with the daemon_memcached plugin, and leave the ...This is because InnoDB performs best for large-scale insertions if primary key values are added in sorted order (as they are with auto-increment ...