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/innodb-fulltext-index.html
When incoming documents are tokenized, the individual words (also referred to as “tokens”) are inserted into the index tables along with position information and an associated DOC_ID. By default, two threads tokenize, sort, and insert words and ... Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those ...
https://dev.mysql.com/doc/refman/5.7/en/json.html
One way to insert this as a JSON object into the facts table is to use the MySQL JSON_OBJECT() function. If this mode is set, a single backslash instead of double backslashes can be used to insert the JSON object literal, and the backslashes are ...
https://dev.mysql.com/doc/refman/5.7/en/populating-spatial-columns.html
For example: Inserting a POINT(1 1) value with hex literal syntax: INSERT INTO geom VALUES (ST_GeomFromWKB(X'0101000000000000000000F03F000000000000F03F')); An ODBC application can send a WKB representation, binding it to a placeholder using an ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-functions.html
For this reason, if you select from the replica's copy of mytable after the CREATE TABLE and INSERT statements just shown have been replicated, you might expect mycol to contain the value 2009-09-01 18:00:00. Therefore, these functions should not be ... Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and LOAD_FILE() functions are replicated without change and thus do not work reliably on the replica unless row-based replication is ...
https://dev.mysql.com/doc/refman/5.7/en/sorted-index-builds.html
InnoDB performs a bulk load instead of inserting one index record at a time when creating or rebuilding indexes. In the third and final phase, the sorted entries are inserted into the B-tree. Prior to the introduction of sorted index builds, index ...This method of index creation is also known as a sorted index ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filter-definitions.html
Table 6.26 Event Class and Subclass Combinations Event Class Event Subclass Description connection connect Connection initiation (successful or unsuccessful) connection change_user User re-authentication with different user/password during session ...For information about using JSON data in MySQL, see Section 11.5, “The JSON Data ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-change-buffer.html
The buffered changes, which may result from INSERT, UPDATE, or DELETE operations (DML), are merged later when the pages are loaded into the buffer pool by other read operations. Figure 14.3 Change Buffer Unlike clustered indexes, secondary indexes ... The change buffer is a special data structure that caches changes to secondary index pages when those pages are not in the buffer ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-setup.html
The innodb_memcached_config.sql script inserts a single entry in the containers table that provides a mapping for the demo_test table. It also inserts a single row of data into the demo_test table. get AA VALUE AA 8 12 HELLO, HELLO END Insert data ... This section describes how to set up the daemon_memcached plugin on a MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/load-data.html
For information about the efficiency of INSERT versus LOAD DATA and speeding up LOAD DATA, see Section 8.2.4.1, “Optimizing INSERT Statements”. If there are BEFORE INSERT or AFTER INSERT triggers for the table, they are activated before or after ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-selection.html
SQL statements supporting explicit partition selection are listed here: SELECT DELETE INSERT REPLACE UPDATE LOAD DATA. For statements that insert rows, the behavior differs in that failure to find a suitable partition causes the statement to fail.