Search Results
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-compliance-administration-standard-rules.html
The binary log enables point-in-time recovery, preventing data loss during a disaster recovery situation. It also enables you to review all alterations made to your database. When enabled, it causes a MySQL server to write informational log events ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-data-load-prerequisites.html
Identify all of the tables that your queries access to ensure that you load all of them into MySQL HeatWave. To minimize the number of MySQL HeatWave nodes required for your data, exclude table columns that are not accessed by your queries. To save ... This topic describes how to prepare your data for loading into MySQL ...
https://dev.mysql.com/doc/internals/en/files-in-innodb-sources.html
After all, no disk i/o can be saved by using an index lookup, if there's no disk. The InnoDB source files are the best place to look for information about internals of the file structure that MySQLers can optionally use for transaction support. But ...
https://dev.mysql.com/doc/refman/8.4/en/explain-extended.html
<cache>(expr) The expression (such as a scalar subquery) is executed once and the resulting value is saved in memory for later use. The EXPLAIN statement produces extra (“extended”) information that is not part of EXPLAIN output but can be ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-failover.html
You can use the following query to obtain the needed records from the ndb_binlog_index table on the source: mysqlS'> SELECT -> @file:=SUBSTRING_INDEX(next_file, '/', -1), -> @pos:=next_position -> FROM mysql.ndb_binlog_index -> WHERE epoch = ... In ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-source.html
In the event of source failure, all transactions committed on the source have been replicated to the replica (saved to its relay log). This section describes the server options and system variables that you can use on replication source servers.
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-conf-options.html
If enabled, read-only queries are directed to read-only servers, and read-write queries are directed to read-write servers. wait_for_my_writes Type Integer Default Value 1 Minimum Value 0 Maximum Value 1 Read-only queries wait for the last written ... When started, MySQL Router reads a list of configuration files that together make up the configuration of the ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-mysqlscript.html
script.Error += new MySqlScriptErrorEventHandler(script_Error); script.ScriptCompleted += new EventHandler(script_ScriptCompleted); script.StatementExecuted += new MySqlStatementExecutedEventHandler(script_StatementExecuted); In VisualStudio, you ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-mysqlscript.html
script.Error += new MySqlScriptErrorEventHandler(script_Error); script.ScriptCompleted += new EventHandler(script_ScriptCompleted); script.StatementExecuted += new MySqlStatementExecutedEventHandler(script_StatementExecuted); In VisualStudio, you ...
https://dev.mysql.com/doc/refman/8.4/en/function-optimization.html
A function is nondeterministic if, given fixed values for its arguments, it can return different results for different invocations. If a function is tagged nondeterministic, a reference to it in a WHERE clause is evaluated for every row (when ...