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/full-table.html
The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. If a table-full error occurs, it may be that the disk is full or that the table has reached its ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-search.html
Constraints on full-text searching are listed in Section 12.9.5, “Full-Text Restrictions”. MATCH (col1,col2,...) AGAINST (expr [search_modifier]) search_modifier: { IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION | IN ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-deploying-in-multi-primary-or-single-primary-mode.html
If a transaction executes against a table that has foreign keys with cascading constraints, then the transaction fails to commit when synchronizing itself with the group. Group Replication operates in the following different modes: single-primary ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-system-variables.html
If a transaction executes against a table that has foreign keys with cascading constraints, then the transaction fails to commit when synchronizing itself with the group. This section lists the system variables that are specific to the Group ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html
It is not true for names of columns, constraints, databases, partitions, statements prepared with PREPARE, tables, triggers, users, and user-defined variables. In MySQL, databases correspond to directories within the data directory. Each table ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-indexes-table.html
Examples: PRIMARY for a primary key index, GEN_CLUST_INDEX for the index representing a primary key when one is not specified, and ID_IND, FOR_IND, and REF_IND for foreign key constraints. The INNODB_SYS_INDEXES table provides metadata about InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-benefits.html
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 database.
https://dev.mysql.com/doc/refman/5.7/en/innodb-disk-management.html
Within these constraints, InnoDB tries to optimize the database work and the organization of disk files to minimize the amount of disk I/O. As a DBA, you must manage disk I/O to keep the I/O subsystem from becoming saturated, and manage disk space ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locking.html
In this case, gap locking is disabled for searches and index scans and is used only for foreign-key constraint checking and duplicate-key checking. Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-migration.html
IMPORT TABLESPACE feature does not enforce foreign key constraints on imported data. This section describes techniques for moving or copying some or all InnoDB tables to a different server or instance. For example, you might move an entire MySQL ...