PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.7Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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 ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-connection-attribute-tables.html
For applications based on the C API implemented by the libmysqlclient client library, the mysql_options() and mysql_options4() functions define the connection attribute set. Connection attributes are key-value pairs that application programs can ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-consumer-configurations.html
The configuration descriptions occur in order of increasing functionality and overhead. The consumer settings in the setup_consumers table form a hierarchy from higher levels to lower. The following discussion describes how consumers work, showing ...