PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/view-algorithms.html
It prefers MERGE over TEMPTABLE if possible, because MERGE is usually more efficient and because a view cannot be updated if a temporary table is used. The optional ALGORITHM clause for CREATE VIEW or ALTER VIEW is a MySQL extension to standard SQL. For MERGE, the text of a statement that refers to the view and the view definition are merged such that parts of the view definition replace corresponding parts of the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-group-membership.html
The group is dynamic and servers can leave (either voluntarily or involuntarily) and join it at any time. In this situation, Group Replication's failure detection mechanism recognizes after a short period of time that the member has left, and a ...
https://dev.mysql.com/doc/refman/8.0/en/sys-processlist.html
By default, rows are sorted by descending process time and descending wait time. They provide more complete information than the SHOW PROCESSLIST statement and the INFORMATION_SCHEMA PROCESSLIST table, and are also nonblocking. The processlist and ... The MySQL process list indicates the operations currently being performed by the set of threads executing within the ...
https://dev.mysql.com/doc/refman/8.0/en/show-table-status.html
For example, InnoDB stores multiple tables in its system tablespace and the data file timestamp does not apply. Even with file-per-table mode with each InnoDB table in a separate .ibd file, change buffering can delay the write to the data file, so ...You can also get this list using the mysqlshow --status db_name ... SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works likes SHOW ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-autocommit-commit-rollback.html
A session that has autocommit enabled can perform a multiple-statement transaction by starting it with an explicit START TRANSACTION or BEGIN statement and ending it with a COMMIT or ROLLBACK statement. A COMMIT or ROLLBACK statement ends the ...If ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-benchmarking.html
If InnoDB is not the default storage engine, you can determine if your database server and applications work correctly with InnoDB by restarting the server with --default-storage-engine=InnoDB defined on the command line or with ...If a table ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-configuration-overview.html
All tables include the data type for the parameter, option, or variable, as well as its default, minimum, and maximum values as applicable. For node parameters, these tables also indicate what type of restart is required (node restart or system ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-privilege-synchronization.html
NDB 8.0 introduces a new mechanism for sharing and synchronizing users, roles, and privileges between SQL nodes connected to an NDB Cluster. A statement granting the NDB_STORED_USER privilege, such as GRANT NDB_STORED_USER ON *.* TO ...Whenever an ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-redo-log-reader.html
ndb_redo_log_reader is intended for use primarily by NDB Cluster developers and Support personnel in debugging and diagnosing problems. This utility remains under development, and its syntax and behavior are subject to change in future NDB Cluster ... Reads a redo log file, checking it for errors, printing its contents in a human-readable format, or ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features.html
The following sections provide information about what is supported and what is not in MySQL replication, and about specific issues and situations that may occur when replicating certain statements. Statement-based replication depends on ...If you ...