Search Results
https://dev.mysql.com/doc/refman/9.7/en/partitioning-limitations-functions.html
The value returned by the EXTRACT() function, when used as EXTRACT(WEEK FROM col), depends on the value of the default_week_format system variable. This section discusses limitations in MySQL Partitioning relating specifically to functions used in ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-events-stages-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored stage event, so there is no system variable for configuring the table size. Of the tables that contain stage event rows, events_stages_current is ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-events-transactions-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored transaction event, so there is no system variable for configuring the table size. For example: mysql> SELECT * FROM ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-events-waits-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored wait event, so there is no system variable for configuring the table size. Of the tables that contain wait event rows, events_waits_current is the ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-replication-applier-status-table.html
The maximum number of retries for a given transaction is set by the system variable replica_transaction_retries. This table shows the current general transaction execution status on the replica. The table provides information about general aspects ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-replication-group-member-actions-table.html
CRITICAL means that the member moves into ERROR state, and takes the action specified by the group_replication_exit_state_action system variable. This table lists the member actions that are included in the member actions configuration for ...
https://dev.mysql.com/doc/refman/9.7/en/precision-math-examples.html
Consider the following stored procedure, which adds .0001 to a variable 1,000 times. This section provides some examples that show precision math query results in MySQL. These examples demonstrate the principles described in Section 14.25.3, ...
https://dev.mysql.com/doc/refman/9.7/en/replication-bugs.html
Ensure that the replica is running with binary logging enabled (the log_bin system variable), and with the --log-replica-updates option enabled, which causes the replica to log the updates that it receives from the source into its own binary logs.
https://dev.mysql.com/doc/refman/9.7/en/replication-privilege-checks-gr.html
Rather than using the checks carried out by the sql_require_primary_key system variable, Group Replication has its own built-in set of checks for primary keys or primary key equivalents. You can also use a PRIVILEGE_CHECKS_USER account to secure ...
https://dev.mysql.com/doc/refman/9.7/en/replication-threads-monitor-worker.html
This system variable sets the maximum amount of memory (in bytes) available to applier worker thread queues holding events not yet applied. On a multithreaded replica, the Performance Schema tables replication_applier_status_by_coordinator and ...