Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-metadata-locks-table.html
It is autosized by default; to configure the table size, set the performance_schema_max_metadata_locks system variable at server startup. The PRE_ACQUIRE_NOTIFY and POST_RELEASE_NOTIFY status values are brief and signify that the metadata locking ...
https://dev.mysql.com/doc/refman/8.4/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. Table 29.3 Performance Schema NDB ... The following table shows all Performance Schema tables relating to the NDBCLUSTER storage ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-actors-table.html
To change the table size, modify the performance_schema_setup_actors_size system variable at server startup. The setup_actors table contains information that determines whether to enable monitoring and historical event logging for new foreground ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-descriptions.html
To change the sizes of the history tables, set the appropriate system variables at server startup. An instrumented object, when used by the server, produces an event. Tables in the performance_schema database can be grouped as follows: Setup tables. The events_waits_current table contains the most recent event for each ...
https://dev.mysql.com/doc/refman/8.4/en/problems-with-null.html
Under certain conditions, if you insert NULL into a TIMESTAMP column, the current date and time is inserted; this behavior depends in part on the server SQL mode (see Section 7.1.11, “Server SQL Modes”) as well as the value of the ... The ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-transaction-inconsistencies.html
The global setting for the system variable rpl_stop_replica_timeout is unrelated to the process of stopping the replication threads. This ensures it never leaves gaps or source binary log position lag, unless any of the cases above applies, in other ... Inconsistencies in the sequence of transactions that have been executed from the relay log can occur depending on your replication ...
https://dev.mysql.com/doc/refman/8.4/en/set-character-set.html
SET CHARACTER SET sets three session system variables: character_set_client and character_set_results are set to the given character set, and character_set_connection to the value of character_set_database. SET {CHARACTER SET | CHARSET} ...The ...
https://dev.mysql.com/doc/refman/8.4/en/table-corruption.html
If you have started mysqld with the myisam_recover_options system variable set, MySQL automatically checks and tries to repair MyISAM tables if they are marked as 'not closed properly' or 'crashed'. When the server detects MyISAM table corruption, ...If this happens, MySQL writes an entry in the hostname.err file 'Warning: Checking table ...' which is followed by Warning: Repairing table if the table needs to be ...
https://dev.mysql.com/doc/refman/8.4/en/xa-states.html
Disabling detached XA transactions is not recommended for a MySQL server instance used in group replication; see Server Instance Configuration, for more information. An XA transaction progresses through the following states: Use XA START to start ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-bind-param.html
Query attribute names are transmitted using the character set indicated by the character_set_client system variable. bool mysql_bind_param(MYSQL *mysql, unsigned n_params, MYSQL_BIND *bind, const char **name) Description mysql_bind_param(), ...For ...