Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-entityframework60.html
Set the DbConfiguration type in the configuration file: <entityFramework codeConfigurationType="MySql.Data.Entity.MySqlEFConfiguration, MySql.Data.EntityFramework"> It is also possible to create a custom DbConfiguration class and add the dependency ...To configure Connector/NET 6.9 or 6.10 for use with EF6, substitute the assembly and package names in this section with the following: Assembly: MySql.Data.Entity.EF6 NuGet package: MySql.Data.Entity For more information about the MySql.Data.Entity NuGet package and its uses, see ...
https://dev.mysql.com/doc/internals/en/optimizer-index-merge-join-type.html
See the get_index_merge_params function in the same file for Index Merge cost calculation algorithm. OR cond_N The conditions for conversion are that each cond_i can be used for a range scan, and no pair (cond_i, cond_j) uses the same index. When ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-table-info.html
Datafile parts For dynamic-row format, this indicates how many data blocks there are. Datafile pointer The size of the data file pointer, in bytes. Max datafile length How long the table data file can become, in bytes. Deleted data How many bytes in ...If you start the MySQL server with external locking disabled, myisamchk may report an error for a table that is updated while it ...
https://dev.mysql.com/doc/workbench/en/wb-model-overview-privileges.html
The Schema Privileges panel has the following sections, used to create users for your schemas and to define roles: Users Roles The following figure displays the Schema Privileges section of the MySQL Model tab. Figure 9.7 Roles and Privileges ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-main-menu.html
Stop Script Execution On Errors: If enabled, MySQL Workbench stops executing the a query if errors are found. Collect Performance Schema Stats: Provides data to the Query Stats result set view, which includes statement specific information about ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-basics.html
In addition, to provide a single point of configuration, all configuration data for the cluster as a whole is located in one configuration file. For more information about the files and directories created by local checkpoints and global ...NDB ...
https://dev.mysql.com/doc/refman/8.4/en/backup-types.html
Physical (Raw) Versus Logical Backups Physical backups consist of raw copies of the directories and files that store database contents. Physical backup methods have these characteristics: The backup consists of exact copies of database directories ...Logical backups save information represented as logical database structure (CREATE DATABASE, CREATE TABLE statements) and content (INSERT statements or delimited-text ...
https://dev.mysql.com/doc/mysql-em-plugin/en/ui-myoem-homepage-regions.html
The following regions are available: Availability History Configuration Summary Connections Transaction Activity Row Activity InnoDB Buffer Pool Usage (pages) Response Time (ms) Statement Activity Incidents and Problems Availability History The ...
https://dev.mysql.com/doc/refman/8.4/en/server-status-variables.html
InnoDB writes data to the redo log buffer inside the MySQL process before requesting that the operating system write the data to the current redo log file. Handler_read_rnd_next The number of requests to read the next row in the data file. For ...
https://dev.mysql.com/doc/internals/en/binary-log-overview.html
[Some information in this section is derived from Chapter 20, The Binary Log, in the MySQL Reference Manual.] The binary log is a set of log files that contain information about data modifications made to a MySQL server instance. The binary log ...