Search Results
https://dev.mysql.com/doc/refman/8.4/en/generated-column-index-optimizations.html
For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as the expression f1 + 1. row *************************** id: 1 select_type: SIMPLE table: t1 partitions: NULL type: range ...The ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-relation-functions-object-shapes.html
Unless otherwise specified, functions handle their unit argument as follows: A unit is supported if it is found in the INFORMATION_SCHEMA ST_UNITS_OF_MEASURE table. The OpenGIS specification defines the following functions to test the relationship ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-before-you-begin.html
The backup should include the mysql system database, which contains the MySQL data dictionary tables and system tables. Important Downgrade from MySQL 8.4 to MySQL 8.3, or from a MySQL 8.4 release to a previous MySQL 8.4 release, is not supported.
https://dev.mysql.com/doc/refman/8.4/en/pluggable-authentication.html
When a client connects to the MySQL server, the server uses the user name provided by the client and the client host to select the appropriate account row from the mysql.user system table. Pluggable authentication makes it possible for clients to ...The server then authenticates the client, determining from the account row which authentication plugin applies to the client: If the server cannot find the plugin, an error occurs and the connection attempt is ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-functions.html
For this reason, if you select from the replica's copy of mytable after the CREATE TABLE and INSERT statements just shown have been replicated, you might expect mycol to contain the value 2009-09-01 18:00:00. Therefore, these functions should not be ... 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/workbench/en/dbdoc-templates-custom.html
The copy can be given any suitable name; for example, Custom_Basic.tpl. This is done using a suitable command-line tool, and there are also free online tools that generate GUIDs. In the simplest case, a template consists of two files: a template ...
https://dev.mysql.com/doc/workbench/en/wb-migration-overview-steps.html
"Schema Name Mapping Method" options while migrating Microsoft SQL Server: Keep schemas as they are: Catalog.Schema.Table -> Schema.Table: This will create multiple databases, one per schema. Only one schema: Catalog.Schema.Table -> Catalog.Table: ... This example migrates a Microsoft SQL Server database to MySQL and includes an image for each ...
https://dev.mysql.com/doc/workbench/en/wb-performance-explain.html
No usable indexes were found for the table, which forces the optimizer to search every row. The visual explain feature generates and displays a visual representation of the MySQL EXPLAIN statement by using extended information available in the ...
https://dev.mysql.com/doc/internals/en/event-flags.html
LOG_EVENT_THREAD_SPECIFIC_F = 0x4 (New in 4.1.0) Used only by mysqlbinlog (not by the replication code at all) to be able to deal properly with temporary tables. mysqlbinlog displays events from the binary log in printable format, so that you can ...
https://dev.mysql.com/doc/internals/en/myisam-files.html
Some notes about MyISAM file handling: If a table is never updated, MySQL will never touch the table files, so it would never be marked as closed or corrupted. If a table is marked readonly by the OS, it will only be opened in readonly mode. When a ...