Search Results
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-statement-summary-tables.html
For example, the SUM_LOCK_TIME and SUM_ERRORS columns in statement summary tables are the aggregates of the LOCK_TIME and ERRORS columns in events_statements_current table. The Performance Schema maintains tables for collecting current and recent ...
https://dev.mysql.com/doc/refman/9.7/en/perl-support-problems.html
If you get the following errors from DBD::mysql, you are probably using gcc (or using an old binary compiled with gcc): /usr/bin/perl: can't resolve symbol '__moddi3' /usr/bin/perl: can't resolve symbol '__divdi3' Add -L/usr/lib/gcc-lib/... If Perl ...
https://dev.mysql.com/doc/refman/9.7/en/precision-math-rounding.html
Such truncation is not an error, even in strict SQL mode (see Section 14.25.3, “Expression Handling”). This section discusses precision math rounding for the ROUND() function and for inserts into columns with exact-value types (DECIMAL and ...
https://dev.mysql.com/doc/refman/9.7/en/problems-with-float.html
The following example uses DOUBLE to demonstrate how calculations that are done using floating-point operations are subject to floating-point error. Floating-point numbers sometimes cause confusion because they are approximate and not stored as ...
https://dev.mysql.com/doc/refman/9.7/en/proxy-users.html
The plugin that authenticates a given connection may request that the connecting (external) user be treated as a different user for privilege-checking purposes. This enables the external user to be a proxy for the second user; that is, to assume the ...
https://dev.mysql.com/doc/refman/9.7/en/range-optimization.html
For UPDATE and DELETE statements, if the optimizer falls back to a full table scan and the sql_safe_updates system variable is enabled, an error occurs rather than a warning because, in effect, no key is used to determine which rows to modify. The ...
https://dev.mysql.com/doc/refman/9.7/en/rebuilding-tables.html
For example, an error in a collation might have been corrected, necessitating a table rebuild to update the indexes for character columns that use the collation. This section describes how to rebuild or repair tables or indexes, which may be ...
https://dev.mysql.com/doc/refman/9.7/en/replica-io-thread-states.html
Waiting to reconnect after a failed master event read Waiting to reconnect after a failed source event read An error occurred while reading (due to disconnection). The following list shows the most common states you see in the State column for a ...
https://dev.mysql.com/doc/refman/9.7/en/replica-logs-relaylog.html
If a replica uses the default host-based relay log file names, changing a replica's host name after replication has been set up can cause replication to fail with the errors Failed to open the relay log and Could not find target log during relay log ... The relay log, like the binary log, consists of a set of numbered files containing events that describe database changes, and an index file that contains the names of all used relay log ...
https://dev.mysql.com/doc/refman/9.7/en/replication-asynchronous-connection-failover.html
When the feature is disabled, you do not need to configure the replication channel on the secondary group members, but if the primary goes offline or into an error state, replication stops for the channel. You can use the asynchronous connection ...