PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/document-store-setting-up.html
Invoke the mysql command-line client: mysql -u user -p Issue the following statement: mysql> INSTALL PLUGIN mysqlx SONAME 'mysqlx.so'; Replace mysqlx.so with mysqlx.dll for Windows. To use MySQL 5.7 as a document store, the X Plugin needs to be ...
https://dev.mysql.com/doc/refman/5.7/en/explain-extended.html
SHOW WARNINGS displays an empty result for other explainable statements (DELETE, INSERT, REPLACE, and UPDATE). For SELECT statements, the EXPLAIN statement produces extra (“extended”) information that is not part of EXPLAIN output but can be ...
https://dev.mysql.com/doc/refman/5.7/en/function-optimization.html
In the original statement, replace the expression with a reference to the variable, which the optimizer can treat as a constant value: SET @keyval = FLOOR(1 + RAND() * 49); UPDATE t SET col_a = some_expr WHERE id = @keyval; Assign the random value ...A function is nondeterministic if, given fixed values for its arguments, it can return different results for different ...
https://dev.mysql.com/doc/refman/5.7/en/general-thread-states.html
rename result table The thread is processing an ALTER TABLE statement, has created the new table, and is renaming it to replace the original table. The following list describes thread State values that are associated with general query processing ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-optimization.html
Whether use of temporary tables can be replaced by index access also depends on which parts of an index are used in a query, the conditions specified for these parts, and the selected aggregate functions. The most general way to satisfy a GROUP BY ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-user-credentials.html
Issue the following, replacing rpl_user and password with the values used when creating the user. Group Replication uses the asynchronous replication protocol to achieve Section 17.9.5, “Distributed Recovery”, synchronizing group members before ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-optimization.html
For an explanation of the inner workings of the InnoDB buffer pool, an overview of its LRU replacement algorithm, and general configuration information, see Section 14.5.1, “Buffer Pool”. InnoDB maintains a storage area called the buffer pool ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-enabling-monitors.html
If you are using the mysql interactive client, the output is more readable if you replace the usual semicolon statement terminator with \G: mysql> SHOW ENGINE INNODB STATUS\G SHOW ENGINE INNODB STATUS output also includes InnoDB Lock Monitor data if ... When InnoDB monitors are enabled for periodic output, InnoDB writes the output to mysqld server standard error output (stderr) every 15 seconds, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-use_sys_malloc.html
On Unix-like systems that use dynamic linking, replacing the memory allocator may be as easy as making the environment variable LD_PRELOAD or LD_LIBRARY_PATH point to the dynamic library that implements the allocator. When InnoDB was developed, the ...
https://dev.mysql.com/doc/refman/5.7/en/insert-delayed.html
The DELAYED option for the INSERT statement is a MySQL extension to standard SQL. The server recognizes but ignores the DELAYED keyword, handles the insert as a nondelayed insert, and generates an ER_WARN_LEGACY_SYNTAX_CONVERTED warning: INSERT ...