MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 81 to 90 of 92 total results

14.6.1.6 AUTO_INCREMENT Handling in InnoDB

https://dev.mysql.com/doc/refman/5.7/en/innodb-auto-increment-handling.html

InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL statements that add rows to tables with AUTO_INCREMENT columns. To use the AUTO_INCREMENT mechanism with an InnoDB table, an ...

14.9.1.3 Tuning Compression for InnoDB Tables

https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-tuning.html

Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed data. However, because the efficiency of compression depends on the nature of your data, you can make decisions ...

14.16.4 InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables

https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-fulltext_index-tables.html

INNODB_FT_BEING_DELETED: Provides a snapshot of the INNODB_FT_DELETED table; it is used only during an OPTIMIZE TABLE maintenance operation. When OPTIMIZE TABLE is run, the INNODB_FT_BEING_DELETED table is emptied, and DOC_ID values are removed from ...

14.21.3 Setting Up the InnoDB memcached Plugin

https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-setup.html

mysql> CREATE TABLE city ( city_id VARCHAR(32), name VARCHAR(1024), state VARCHAR(1024), country VARCHAR(1024), flags INT, cas BIGINT UNSIGNED, expiry INT, primary key(city_id) ) ENGINE=InnoDB; Add an entry to the innodb_memcache.containers table so ... This section describes how to set up the daemon_memcached plugin on a MySQL ...

14.22.3 Troubleshooting InnoDB Data Dictionary Operations

https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html

Information about table definitions is stored both in the .frm files, and in the InnoDB data dictionary. If you move .frm files around, or if the server crashes in the middle of a data dictionary operation, these sources of information can become ...

11.5 The JSON Data Type

https://dev.mysql.com/doc/refman/5.7/en/json.html

The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON columns. JSON documents stored in JSON columns are converted to an internal format that permits ...

9.3 Keywords and Reserved Words

https://dev.mysql.com/doc/refman/5.7/en/keywords.html

Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Reserved words are permitted as ...

B.3.7 Known Issues in MySQL

https://dev.mysql.com/doc/refman/5.7/en/known-issues.html

You should try to avoid using unsigned long long values if they resolve to be larger than 63 bits (9223372036854775807) for anything other than bit fields. This section lists known issues in recent versions of MySQL. For information about ...

5.5.6.1 The Locking Service

https://dev.mysql.com/doc/refman/5.7/en/locking-service.html

Source files that use the locking service should include this header file: #include <mysql/service_locking.h> To acquire one or more locks, call this function: int mysql_acquire_locking_service_locks(MYSQL_THD opaque_thd, const char* lock_namespace, ... MySQL distributions provide a locking interface that is accessible at two levels: At the SQL level, as a set of loadable functions that each map onto calls to the service ...

21.6.11.1 NDB Cluster Disk Data Objects

https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-disk-data-objects.html

NDB Cluster Disk Data storage is implemented using a number of Disk Data objects. These include the following: Tablespaces act as containers for other Disk Data objects. One or more undo log files are assigned to a log file group, which is then ...

Displaying 81 to 90 of 92 total results