Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-multi-source.html
This does not automatically create binary logs on the second NDB Cluster's SQL node acting as the replica; in order to cause the binary logs to be created, you must issue a SHOW TABLES statement on that SQL node; this should be done prior to running ... It is possible to use NDB Cluster for bidirectional replication between two clusters, as well as for circular replication between any number of ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema.html
In general, an event could be a function call, a wait for the operating system, a stage of an SQL statement execution such as parsing or sorting, or an entire statement or group of statements. These tables can be queried using SELECT statements like ... The MySQL Performance Schema is a feature for monitoring MySQL Server execution at a low ...
https://dev.mysql.com/doc/refman/8.4/en/replication-binlog-encryption-key-rotation.html
The BINLOG_ENCRYPTION_ADMIN privilege is required to issue ALTER INSTANCE ROTATE BINLOG MASTER KEY, and the statement cannot be used if the binlog_encryption system variable is set to OFF. For example, this might be the case if a file listed in a ...
https://dev.mysql.com/doc/refman/8.4/en/server-shutdown.html
Threads that currently are processing statements check their state periodically and take longer to die. For additional information about thread termination, see Section 15.7.8.4, “KILL Statement”, in particular for the instructions about killed ... The server shutdown process takes place as follows: The shutdown process is ...
https://dev.mysql.com/doc/refman/8.4/en/sys-innodb-lock-waits.html
sql_kill_blocking_query The KILL statement to execute to kill the blocking statement. sql_kill_blocking_connection The KILL statement to execute to kill the session running the blocking statement. These views summarize the InnoDB locks that ...
https://dev.mysql.com/doc/c-api/8.4/en/getting-unique-id.html
You can check from your C applications whether a value was stored in an AUTO_INCREMENT column by executing the following code (which assumes that you've checked that the statement succeeded). Each client will receive the last inserted ID for the ...
https://dev.mysql.com/doc/internals/en/tracing-example.html
The statement's execution is naturally made of "steps": "steps": [ { "join_preparation": { This is a join's preparation "select#": 1, for the first SELECT of the statement (which has only one, here). "rest_of_plan": [ { "database": "test", "table": ...}, { "access_type": "scan", "using_join_cache": true, "records": 75, "cost": 7.4917, "chosen": false But not table scan, because its amount of records (75) is far greater than that of ref access ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlshow.html
The mysqlshow client can be used to quickly see which databases exist, their tables, or a table's columns or indexes. The same information can be obtained by using those statements directly. For example, you can issue them from the mysql client ...
https://dev.mysql.com/doc/refman/8.4/en/programs-overview.html
MySQL client programs that connect to the MySQL server: mysql The command-line tool for interactively entering SQL statements or executing them from a file in batch mode. mysqlshow A client that displays information about databases, tables, columns, ...Later sections provide a more detailed description of each one, with the exception of NDB Cluster ...
https://dev.mysql.com/doc/refman/8.4/en/windows-restrictions.html
DATA DIRECTORY and INDEX DIRECTORY The DATA DIRECTORY clause of the CREATE TABLE statement is supported on Windows for InnoDB tables only, as described in Section 17.6.1.2, “Creating Tables Externally”. This facility is often used to move the ...