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/trace-general-structure.html
A trace follows the actual execution path very closely; for each join, there is a join preparation object, a join optimization object, and a join execution object. Query transformations (IN to EXISTS, outer join to inner join, and so on), ...
https://dev.mysql.com/doc/refman/5.7/en/traceable-statements.html
For statements which are prepared and executed in separate steps, preparation and execution are traced separately. Statements which are traceable are listed here: SELECT INSERT REPLACE UPDATE DELETE EXPLAIN with any of the preceding statements SET ...
https://dev.mysql.com/doc/refman/5.7/en/drop-procedure.html
(If the automatic_sp_privileges system variable is enabled, that privilege and EXECUTE are granted automatically to the routine creator when the routine is created and dropped from the creator when the routine is dropped. It prevents an error from ... DROP {PROCEDURE | FUNCTION} [IF EXISTS] sp_name These statements are used to drop a stored routine (a stored procedure or ...
https://dev.mysql.com/doc/refman/5.7/en/macos-installation-pkg.html
From the Installation Type page you can either click Install to execute the installation wizard using all defaults, click Customize to alter which components to install (MySQL server, Preference Pane, Launchd Support -- all enabled by default). The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-configuration.html
Important Once you have started a mysqld process with the ndbcluster and ndb-connectstring parameters in the [mysqld] and [mysql_cluster] sections of the my.cnf file as shown previously, you cannot execute any CREATE TABLE or ALTER TABLE statements ... In this section, we discuss manual configuration of an installed NDB Cluster by creating and editing configuration ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-mgm-client-commands.html
The list must contain no duplicate IDs; beginning with NDB 7.5.23 and NDB 7.6.19, the presence of any duplicates causes the command to return an error. For testing and diagnostics work, the client supports a DUMP command which can be used to execute ... In addition to the central configuration file, a cluster may also be controlled through a command-line interface available through the management client ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning.html
In MySQL 5.7.17 through 5.7.20, the server automatically performs a check at startup to identify tables that use nonnative partitioning; for any that are found, the server writes a message to its error log. Note As of MySQL 5.7.17, the generic ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-variables.html
sql_mode is also replicated except for the NO_DIR_IN_CREATE mode; the replica always preserves its own value for NO_DIR_IN_CREATE, regardless of changes to it on the source. However, when mysqlbinlog parses a SET @@sql_mode = mode statement, the ...
https://dev.mysql.com/doc/refman/5.7/en/set-global-sql-slave-skip-counter.html
SET GLOBAL sql_slave_skip_counter = N This statement skips the next N events from the master. This is useful for recovering from replication stops caused by a statement. This statement is valid only when the slave threads are not running. When ...
https://dev.mysql.com/doc/refman/5.7/en/cannot-initialize-character-set.html
You might see an error like this if you have character set problems: MySQL Connection Failed: Can't initialize character set charset_name This error can have any of the following causes: The character set is a multibyte character set and you have ...In this case, you need to recompile the client by running CMake with the -DDEFAULT_CHARSET=charset_name or -DWITH_EXTRA_CHARSETS=charset_name ...