Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-diffengines.html
Configuring different engines on the source and replica depends on how you set up the initial replication process: If you used mysqldump to create the database snapshot on your source, you could edit the dump file text to change the engine type used ... It does not matter for the replication process whether the original table on the source and the replicated table on the replica use different storage engine ...
https://dev.mysql.com/doc/refman/8.4/en/resource-groups.html
MySQL supports creation and management of resource groups, and permits assigning threads running within the server to particular groups so that threads execute according to the resources available to the group. Group attributes enable control over ...
https://dev.mysql.com/doc/refman/8.4/en/semijoins-antijoins.html
EXPLAIN output indicates the use of semijoin strategies as follows: For extended EXPLAIN output, the text displayed by a following SHOW WARNINGS shows the rewritten query, which displays the semijoin structure. A semijoin is a preparation-time ...
https://dev.mysql.com/doc/refman/8.4/en/server-plugins.html
The plugins supported by this interface include, but are not limited to, storage engines, INFORMATION_SCHEMA tables, full-text parser plugins, and server extensions. MySQL supports an plugin API that enables creation of server plugins. Plugins can ...
https://dev.mysql.com/doc/refman/8.4/en/setting-environment-variables.html
If your shell is tcsh, add the following line to your .tcshrc file: setenv PATH ${PATH}:/usr/local/mysql/bin If the appropriate startup file does not exist in your home directory, create it with a text editor. Environment variables can be set at ...
https://dev.mysql.com/doc/refman/8.4/en/show-binlog-events.html
As an alternative to SHOW BINLOG EVENTS, use the mysqlbinlog utility to save the binary log to a text file for later examination and analysis. SHOW BINLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] Shows the events in the binary ...
https://dev.mysql.com/doc/refman/8.4/en/show-index.html
However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary string types (BINARY, ... SHOW [EXTENDED] {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index ...
https://dev.mysql.com/doc/refman/8.4/en/slow-query-log.html
Passwords in statements written to the slow query log are rewritten by the server not to occur literally in plain text. The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least ...
https://dev.mysql.com/doc/refman/8.4/en/source-configuration-options.html
The CMake program provides a great deal of control over how you configure a MySQL source distribution. Typically, you do this using options on the CMake command line. For information about options supported by CMake, run either of these commands in ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-geohash-functions.html
Geohash is a system for encoding latitude and longitude coordinates of arbitrary precision into a text string. mysql> SET @gh = ST_GeoHash(45,-20,10); mysql> SELECT ST_AsText(ST_PointFromGeoHash(@gh,0)); +---------------------------------------+ | ...Geohash values are strings that contain only characters chosen from ...