Search Results
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-logs-event-buffer.html
PARTIALLY_BUFFERING: The buffer free percentage following the gap has risen to the threshold, which can be set in the mysql client using the ndb_eventbuffer_free_percent server system variable or in NDB API applications by calling ...The threshold ... NDB uses one or more memory buffers for events received from the data ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-replication-tables.html
Note The following two components provide information relating to replication performance: The Group Replication Flow Control Statistics component enables several server status variables which provide information on Group Replication flow control ...
MySQL 9.7 Reference Manual :: 19.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging
https://dev.mysql.com/doc/refman/9.7/en/replication-rbr-safe-unsafe.html
Most system variables are not replicated correctly using the statement-based format. Statements with the following characteristics are considered unsafe: Statements containing system functions that may return a different value on the replica. These ... The “safeness” of a statement in MySQL replication refers to whether the statement and its effects can be replicated correctly using statement-based ...
https://dev.mysql.com/doc/refman/9.7/en/identifiers.html
mysql> SET sql_mode='ANSI_QUOTES'; mysql> CREATE TABLE "test" (col INT); Query OK, 0 rows affected (0.00 sec) The ANSI_QUOTES mode causes the server to interpret double-quoted strings as identifiers. The server SQL mode is controlled as described in ... Certain objects within MySQL, including database, table, index, column, alias, view, stored procedure, partition, tablespace, resource group and other object names are known as ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-persistent-stats.html
The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given query.
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-accounts-table.html
To set the table size explicitly, set the performance_schema_accounts_size system variable at server startup. The accounts table contains a row for each account that has connected to the MySQL server. For each account, the table counts the current ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-hosts-table.html
To set the table size explicitly, set the performance_schema_hosts_size system variable at server startup. The hosts table contains a row for each host from which clients have connected to the MySQL server. For each host name, the table counts the ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-ndb-cluster-tables.html
This is done by default in the background at regular intervals as determined by the ndb_metadata_check_interval system variable, unless disabled using ndb_metadata_check or overridden by setting ndb_metadata_sync. Historically, information about the ...Automatic synchronization in NDB attempts to detect and synchronize automatically all mismatches in metadata between the NDB Cluster's internal dictionary and the MySQL Server's ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-users-table.html
To set the table size explicitly, set the performance_schema_users_size system variable at server startup. The users table contains a row for each user who has connected to the MySQL server. For each user name, the table counts the current and ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-temptables.html
In statement-based replication mode, CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE statements cannot be used inside a transaction, procedure, function, or trigger when GTIDs are in use on the server (that is, when the enforce_gtid_consistency ...