Search Results
https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/news-8-2-0.html
NDB Client Programs: When ndb_select_all failed to read all data from the table, it always tried to re-read it. Now when ndb_select_all is unsuccessful at reading all the table data, its behavior is as follows: When the result is non-empty, ... Bugs ...
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/refman/8.4/en/window-functions-named-windows.html
Windows can be defined and given names by which to refer to them in OVER clauses. If present in a query, the WINDOW clause falls between the positions of the HAVING and ORDER BY clauses, and has this syntax: WINDOW window_name AS (window_spec) [, ...
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 ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-_query.html
Table 4.37 deletePersistentAll() Parameter Description return the number of instances deleted 4.3.1.19.9 execute(Map<String, ?>) public abstract Results<E> execute(Map<String, ?> parameters); Execute the query with one or more named parameters. A ...