Search Results
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-partitioning.html
Replication is supported between partitioned tables as long as they use the same partitioning scheme and otherwise have the same structure, except where an exception is specifically allowed (see Section 19.5.1.9, “Replication with Differing Table ...DROP PARTITION) that act directly on partitions in such cases might produce different results on the source and the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-source.html
On the source and each replica, you must set the server_id system variable to establish a unique replication ID. If their values have already been modified from the default, Group Replication does not alter them. It is not possible to restrict the ... This section describes the server options and system variables that you can use on replication source ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-mcmd.html
Invoking this executable starts the MySQL Cluster Manager Agent, to which you can connect using the mcm client (see Section 4.3, “Starting the MySQL Cluster Manager Client” and Chapter 5, MySQL Cluster Manager Client Commands for more ...You can ...
https://dev.mysql.com/doc/workbench/en/wb-forward-engineering-sql-scripts.html
You may export a script to alter an existing database or create a new database. Generate DROP SCHEMA Sort Tables Alphabetically When this option is unchecked, tables are sorted according to foreign-key references. Generate USE statements Generate ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-importing-data.html
You may also wish to do this when performing bulk DELETE or UPDATE operations on NDB Cluster tables. If a data import operation does not complete successfully, for whatever reason, you should be prepared to perform any necessary cleanup including ...
https://dev.mysql.com/doc/workbench/en/wb-tutorial-visual-explain-dbt3.html
The initial report shows a Visual Explain image with information that appears when you move your pointer device over the orders table in full table scan. Figure 7.9 DBT-3 Explain Tutorial: Visual Explain with Full Table Scan Optionally, you can ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-programming-net.html
5.6.7.2.1 Using Connector/ODBC with ODBC.NET and C# (C sharp) The following sample creates a table my_odbc_net and demonstrates its use in C#. This section contains simple examples that demonstrate the use of Connector/ODBC drivers with ODBC.NET.
https://dev.mysql.com/doc/internals/en/caching.html
Uses hashing and reverse linked lists for quick caching of the most recently used blocks and quick flushing of changed entries for a specific table. (mysys/mf_keycash.c) Record Cache This is used for quick scanning of all records in a table. (Note ...
https://dev.mysql.com/doc/internals/en/handler-instantiation.html
Here is an example from the CSV engine: static handler* tina_create_handler(TABLE *table); As you can see, the method accepts a pointer to the table the handler is intended to manage, and returns a handler object. Here is an example of the MyISAM ...