Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-rolling-restart.html
This is often done as part of a rolling upgrade or rolling downgrade, where high availability of the cluster is mandatory and no downtime of the cluster as a whole is permissible. This section discusses how to perform a rolling restart of an NDB ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-transaction-summary-tables.html
COUNT_READ_WRITE, SUM_TIMER_READ_WRITE, MIN_TIMER_READ_WRITE, AVG_TIMER_READ_WRITE, MAX_TIMER_READ_WRITE These are similar to the COUNT_STAR and xxx_TIMER_WAIT columns, but summarize read-write transactions only. COUNT_READ_ONLY, ... The Performance ...Section 29.12.7, “Performance Schema Transaction Tables” describes the events on which transaction summaries are ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks.html
You can create a user account with the appropriate privileges to apply the transactions that are normally replicated on a channel, and specify this as the PRIVILEGE_CHECKS_USER account for the replication applier, using a CHANGE REPLICATION SOURCE ... By default, MySQL replication (including Group Replication) does not carry out privilege checks when transactions that were already accepted by another server are applied on a replica or group ...
https://dev.mysql.com/doc/refman/8.4/en/show-warnings.html
Warnings are generated for DML statements such as INSERT, UPDATE, and LOAD DATA as well as DDL statements such as CREATE TABLE and ALTER TABLE. SHOW WARNINGS [LIMIT [offset,] row_count] SHOW COUNT(*) WARNINGS SHOW WARNINGS is a diagnostic statement ...The LIMIT clause has the same syntax as for the SELECT ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-incremental-options.html
For an overview of incremental backups and usage examples for these options, see Section 4.3.3, “Making a Differential or Incremental Backup” and Section 5.1.3, “Restoring an Incremental Backup”. If page tracking cannot be used (see ...To ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-interface-usage.html
To prepare and execute a statement, an application follows these steps: Create a prepared statement handler with mysql_stmt_init(). To prepare the statement on the server, call mysql_stmt_prepare() and pass it a string containing the SQL statement.
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-reporting-run.html
Built-in reports and user-defined reports that have been registered with MySQL Shell can be run in any interactive MySQL Shell mode (JavaScript, Python, or SQL) using the \show or \watch command, or called using the shell.reports object from ...You ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-mysqlai-ml-explain.html
Running the ML_EXPLAIN routine on a model and dataset trains a prediction explainer and model explainer, and adds a model explanation to the model catalog. See Generate Model Explanations and Generate Prediction Explanations to learn more. Required ...
https://dev.mysql.com/doc/refman/8.4/en/internal-locking.html
Table-Level Locking MySQL uses table-level locking for MyISAM, MEMORY, and MERGE tables, permitting only one session to update those tables at a time. At times, it may be more efficient to disable deadlock detection and rely on the ...This type of ... This section discusses internal locking; that is, locking performed within the MySQL server itself to manage contention for table contents by multiple ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-query-analyzer-queries.html
Date and time range: displays the statement's time range, as selected on the Query Analyzer page. Example Statements: (Displayed only if Example Query is enabled) distribution chart of the statement by Execution Time, in milliseconds, and time and ...Graphs: displays the average execution time, number of executions, and number of rows affected by the statement within the selected time ...