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/mysql-install-db.html
If this option is not given, mysql_install_db searches for mysqld in these locations: In the bin directory under the --basedir option value, if that option was given. Until this is done, the administrative account cannot be used for anything else.
https://dev.mysql.com/doc/refman/5.7/en/outer-join-optimization.html
MySQL implements an A LEFT JOIN B join_specification as follows: Table B is set to depend on table A and all tables on which A depends. Table A is set to depend on all tables (except B) that are used in the LEFT JOIN condition. The LEFT JOIN ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-info.html
row *************************** id: 1 select_type: SIMPLE table: trb1 partitions: p0,p1,p2,p3 type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 10 Extra: Using filesort In this case, all four partitions are searched. This ...
https://dev.mysql.com/doc/refman/5.7/en/perl-support.html
You can obtain the necessary modules from http://search.cpan.org for Unix, or by using the ActiveState ppm program on Windows. The Perl DBI module provides a generic interface for database access. You can write a DBI script that works with many ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html
binlog_gtid_simple_recovery Command-Line Format --binlog-gtid-simple-recovery[={OFF|ON}] System Variable binlog_gtid_simple_recovery Scope Global Dynamic No Type Boolean Default Value ON This variable controls how binary log files are iterated ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-geohash-functions.html
The functions in this section enable manipulation of geohash values, which provides applications the capabilities of importing and exporting geohash data, and of indexing and searching geohash values. Geohash is a system for encoding latitude and ...
https://dev.mysql.com/doc/refman/5.7/en/storage-engines.html
For advanced users, this chapter also contains a description of the pluggable storage engine architecture (see Section 15.11, “Overview of MySQL Storage Engine Architecture”). NDB (also known as NDBCLUSTER): This clustered database engine is ...
https://dev.mysql.com/doc/refman/5.7/en/tracing-example.html
row *************************** QUERY: SELECT SUM(alias2.col_varchar_nokey) AS c1, alias2.pk AS c2 FROM t1 AS alias1 STRAIGHT_JOIN t2 AS alias2 ON alias2.pk = alias1.col_int_key WHERE alias1.pk GROUP BY c2 ORDER BY alias1.col_int_key, alias2.pk This ...Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G ...
https://dev.mysql.com/doc/refman/5.7/en/file-permissions.html
If this is unsuitable, create the error file manually with the desired access mode prior to executing mysqld_safe. If you have problems with file permissions, the UMASK or UMASK_DIR environment variable might be set incorrectly when mysqld starts.
https://dev.mysql.com/doc/refman/5.7/en/group-replication-user-credentials.html
This process can be captured in the binary log and then you can rely on distributed recovery to replicate the statements used to create the user. Alternatively, you can disable binary logging using SET SQL_LOG_BIN=0; and then create the user ...