Search Results
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-statementprocessing-category.html
Big Selects Enabled If set to 0, MySQL aborts SELECT statements that are likely to take a very long time to execute (that is, statements for which the optimizer estimates that the number of examined rows exceeds the value of max_join_size). Max ...
https://dev.mysql.com/doc/internals/en/replication-correct.html
(rpl-missing-slave-columns) binlog_format=ROW and the master has extra columns after the columns of the slave, as long as the following rules apply: The slave cannot have both missing columns and extra columns (see above) at the same time. In ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-replication.html
When the replication SQL thread executes an event read from the source, it modifies its own time to the event timestamp. (This is why TIMESTAMP is well replicated.) In the Time column in the output of SHOW PROCESSLIST, the number of seconds ...Must ... In the following section, we provide answers to questions that are most frequently asked about MySQL ...
https://dev.mysql.com/doc/internals/en/strings-directory.html
Many of the files in this subdirectory are equivalent to well-known functions that appear in most C string libraries. On the other hand, some of the files are MySQL additions or improvements. Often the MySQL changes are attempts to optimize the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-responses-failure-expel.html
You can specify an expel timeout up to a maximum of 3600 seconds (1 hour). group_replication_member_expel_timeout specifies the period of time in seconds, called the expel timeout, that a group member waits between creating a suspicion, and ... You ...A suspicion is created when one server does not receive messages from another server, as explained in Section 20.1.4.2, “Failure ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-query-analyzer-ref.html
The Query Analyzer provides a point-in-time snapshot of queries on the monitored database, enabling you to monitor SQL statements executed on a MySQL server and see details of each query, number of executions, and execution times. Selecting a query ...Error Count The total number of errors produced by occurrences of the ...Each row ...
https://dev.mysql.com/doc/ndbapi/en/ndb-start-mysql-data-types.html
The “new” versions of these types are reflected in the NDB API as Time2, Datetime2, and Timestamp2, respectively, each supporting fractional seconds with up to 6 digits of precision. The integer part is encoded as shown in the following table: ...The storage space required for a MySQL CHAR column is determined by the maximum number of characters and the column's character ... This section provides information about the ...
https://dev.mysql.com/doc/refman/8.4/en/information-functions.html
The intended use is from within the mysql client, which reports query execution times: mysql> SELECT BENCHMARK(1000000,AES_ENCRYPT('hello','goodbye')); +---------------------------------------------------+ | ...It may be used to time how quickly ...
https://dev.mysql.com/doc/workbench/en/wb-database-synchronization.html
Note Be aware that backward incompatible MySQL syntax changes are introduced over time, so for this reason it is important to set the Default Target MySQL Version modeling preference according to your needs. For example, exporting results from a ...
https://dev.mysql.com/doc/ndbapi/en/mgm-functions-cluster-log.html
A severity level is stored at position ndb_mgm_clusterlog_level; for example the error level is stored at position NDB_MGM_EVENT_SEVERITY_ERROR. Return value The number of returned severities, or -1 in the event of an error. Return value This ...