PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/nested-join-optimization.html
As a result, the execution time for the query may improve immensely. The following discussion refers to the join syntax described in Section 15.2.13.2, “JOIN Clause”. The syntax of table_factor is extended in comparison with the SQL Standard.
https://dev.mysql.com/doc/refman/8.0/en/programs-development.html
This section describes some utilities that you may find useful when developing MySQL programs. This works well for programs that use the last instance of an option that is specified multiple times. Check the source code of any of the standard MySQL ...In shell scripts, you can use the my_print_defaults program to parse option files and see what options would be used by a given ...
https://dev.mysql.com/doc/refman/8.0/en/recovery-from-backups.html
| mysql For more information about using mysqlbinlog to process binary log files, see Section 9.5, “Point-in-Time (Incremental) Recovery”. The full backup file is just a set of SQL statements, so restoring it is very easy: $> mysql < ... Now, ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-show-disabled.html
Displays all currently disabled Performance Schema configuration. Parameters in_show_instruments BOOLEAN: Whether to display disabled instruments. This might be a long list. in_show_threads BOOLEAN: Whether to display disabled threads. Example ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-functions.html
To avoid unexpected results when replicating between MySQL servers in different time zones, set the time zone on both source and replica. To explain the potential problems when replicating between servers which are in different time zones, suppose ... Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and LOAD_FILE() functions are replicated without change and thus do not work reliably on the replica unless row-based replication is ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-instruments-table.html
The setup_instruments table lists classes of instrumented objects for which events can be collected: mysql> SELECT * FROM performance_schema.setup_instruments\G *************************** 1. row *************************** NAME: ...At this point, ...
https://dev.mysql.com/doc/refman/8.0/en/adding-collation-simple-8bit.html
This section describes how to add a simple collation for an 8-bit character set by writing the <collation> elements associated with a <charset> character set description in the MySQL Index.xml file. You can check the variable value as follows, ...
https://dev.mysql.com/doc/refman/8.0/en/binary-varbinary.html
Note Within the mysql client, binary strings display using hexadecimal notation, depending on the value of the --binary-as-hex. For more information about that option, see Section 6.5.1, “mysql — The MySQL Command-Line Client”. The BINARY and ...
https://dev.mysql.com/doc/refman/8.0/en/blackhole-storage-engine.html
To examine the source for the BLACKHOLE engine, look in the sql directory of a MySQL source distribution. The maximum key length is 3072 bytes as of MySQL 8.0.27. The “dummy” mysqld process acts as a replica, applying the desired combination of ... The BLACKHOLE storage engine acts as a “black hole” that accepts data but throws it away and does not store ...
https://dev.mysql.com/doc/refman/8.0/en/component-loading.html
MySQL supports manual component loading at runtime and automatic loading during server startup. For example: INSTALL COMPONENT 'file://component_validate_password'; UNINSTALL COMPONENT 'file://component_validate_password'; A loader service handles ... Components must be loaded into the server before they can be ...