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/ignoring-user.html
You have specified a password in the user table without using the PASSWORD() function. Use mysql to update the account in the user table with a new password, making sure to use the PASSWORD() function: mysql> UPDATE user SET ... If you get the ...
https://dev.mysql.com/doc/refman/5.7/en/index-condition-pushdown-optimization.html
Index Condition Pushdown (ICP) is an optimization for the case where MySQL retrieves rows from a table using an index. Without ICP, the storage engine traverses the index to locate rows in the base table and returns them to the MySQL server which ...
https://dev.mysql.com/doc/refman/5.7/en/install-plugin.html
A plugin is initialized by executing its initialization function, which handles any setup that the plugin must perform before it can be used. When the server shuts down, it executes the deinitialization function for each plugin that is loaded so ...
https://dev.mysql.com/doc/refman/5.7/en/libmysqld-options.html
To specify an option file for a C program, use the --defaults-file option as one of the elements of the second argument of the mysql_library_init() function. Any options that may be given with the mysqld server daemon, may be used with an embedded ...
https://dev.mysql.com/doc/refman/5.7/en/loop.html
Within a stored function, RETURN can also be used, which exits the function entirely. [begin_label:] LOOP statement_list END LOOP [end_label] LOOP implements a simple loop construct, enabling repeated execution of the statement list, which consists ...
https://dev.mysql.com/doc/refman/5.7/en/manual-info.html
This manual is not intended for use with older versions of the MySQL software due to the many functional and other differences between MySQL 5.7 and previous versions. Text in this style is used to indicate a program option that affects how the ...
https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-optimization-tips.html
Similarly, if your application computes a single result based on several column values or large volumes of data, combining the computation into a loadable function can help performance. See Section 23.2, “Using Stored Routines” and Adding ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-transactions.html
(In any case, this operation is rolled back when the copy is deleted.) Transactions and the COUNT() function. When using NDB Cluster Replication, it is not possible to guarantee the transactional consistency of the COUNT() function on the replica.
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-memory-per-fragment.html
Since the tree contains references rather than actual data, the T-tree storage cost is not dependent on the size or number of indexed columns, but is rather a function of the number of rows. memory_per_fragment Table: Notes memory_per_fragment ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-overview.html
Backing up and restoring NDB Cluster databases can be done using the NDB-native functionality found in the NDB Cluster management client and the ndb_restore program included in the NDB Cluster distribution. You can also use the standard MySQL ...