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/mysql-logging.html
This is the same as the CONNECTION_ID() function value within the session. The mysql client can do these types of logging for statements executed interactively: On Unix, mysql writes the statements to a history file. By default, this file is named ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-shell-userguide.html
In addition to the provided SQL functionality, similar to mysql, MySQL Shell provides scripting capabilities for JavaScript and Python and includes APIs for working with MySQL. MySQL Shell is an advanced client and code editor for MySQL Server. For ...
https://dev.mysql.com/doc/refman/5.7/en/mysql.html
This is done by returning the result set using the mysql_use_result() C API function in the client/server library rather than mysql_store_result(). mysql is a simple SQL shell with input line editing capabilities. When used interactively, query ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-tips.html
This section surveys techniques that enable you to use mysqldump to solve specific problems: How to make a copy a database How to copy a database from one server to another How to dump stored programs (stored procedures and functions, triggers, and ...
https://dev.mysql.com/doc/refman/5.7/en/optimizer-hints.html
Statements that are not read only are those that invoke a stored function that modifies data as a side effect. One means of control over optimizer strategies is to set the optimizer_switch system variable (see Section 8.9.2, “Switchable ...
https://dev.mysql.com/doc/refman/5.7/en/out-of-memory.html
This causes it to use the mysql_use_result() C API function to retrieve the result set, which places less of a load on the client (but more on the server). Is it reasonable that it should return so many rows? If not, correct the query and try again.
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-storage-engines.html
You should also be aware that this functionality is now deprecated and subject to removal without further notice in a future release of NDB Cluster. The following limitations apply to the use of storage engines with user-defined partitioning of ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-linear-hash.html
MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm whereas regular hashing employs the modulus of the hashing function's value. We call this value V; it can be ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-selection.html
You can also use aggregate functions with HAVING and GROUP BY options. MySQL 5.7 supports explicit selection of partitions and subpartitions that, when executing a statement, should be checked for rows matching a given WHERE condition. Partition ...
https://dev.mysql.com/doc/refman/5.7/en/password-logging.html
Passwords can be written as plain text in SQL statements such as CREATE USER, GRANT, SET PASSWORD, and statements that invoke the PASSWORD() function. If such statements are logged by the MySQL server as written, passwords in them become visible to ...