Search Results
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-replication-group-communication-information-table.html
For a group in single-primary mode with the group_replication_paxos_single_leader system variable set to ON and the communication protocol version set to 8.0.27 or later, the single consensus leader is the group's primary. This is set to accommodate ... This table shows group configuration options for the whole replication ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-setup-objects-table.html
To change the table size, modify the performance_schema_setup_objects_size system variable at server startup. The setup_objects table controls whether the Performance Schema monitors particular objects. This table has a maximum size of 100 rows by ...
https://dev.mysql.com/doc/refman/9.7/en/precision-math-expressions.html
Inserts into numeric columns are affected by the SQL mode, which is controlled by the sql_mode system variable. (See Section 7.1.11, “Server SQL Modes”.) The following discussion mentions strict mode (selected by the STRICT_ALL_TABLES or ...
https://dev.mysql.com/doc/refman/9.7/en/replica-io-thread-states.html
Set the terminology_use_previous system variable with session scope to support individual functions, or global scope to be a default for all new sessions. The following list shows the most common states you see in the State column for a replication ...This state also appears in the Replica_IO_State column displayed by SHOW REPLICA STATUS, so you can get a good view of what is happening by using that ...
https://dev.mysql.com/doc/refman/9.7/en/reset.html
For information about the RESET PERSIST statement that removes persisted global system variables, see Section 15.7.8.7, “RESET PERSIST Statement”. reset_option: { BINARY LOGS AND GTIDS | REPLICA } The RESET statement is used to clear the state ...The following list describes the permitted RESET statement reset_option values: RESET BINARY LOGS AND GTIDS Deletes all binary logs listed in the index file, resets the binary log index file to be empty, and creates a new binary log ...
https://dev.mysql.com/doc/refman/9.7/en/scheduler-component.html
Purpose: Implements the component_scheduler.enabled system variable that controls whether the scheduler is actively executing tasks. For example, the audit_log server plugin calls the scheduler component at its initialization and configures a ...
https://dev.mysql.com/doc/refman/9.7/en/set-names.html
SET NAMES {'charset_name' [COLLATE 'collation_name'] | DEFAULT} This statement sets the three session system variables character_set_client, character_set_connection, and character_set_results to the given character set. Setting ...
https://dev.mysql.com/doc/refman/9.7/en/show-create-database.html
SHOW CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name Shows the CREATE DATABASE statement that creates the named database. If the SHOW statement includes an IF NOT EXISTS clause, the output too includes such a clause. row ...
https://dev.mysql.com/doc/refman/9.7/en/show-create-table.html
SHOW CREATE TABLE tbl_name Shows the CREATE TABLE statement that creates the named table. To use this statement, you must have some privilege for the table. row *************************** Table: t Create Table: CREATE TABLE `t` ( `id` int NOT NULL ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-metadata.html
Additional information relating to the MLE component which provides JavaScript stored program functionality can be obtained by checking the values of server system and status variables which this component makes available. You can obtain metadata ...