PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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/refman/8.0/en/information-schema-introduction.html
Other terms that are sometimes used for this information are data dictionary and system catalog. Performance Considerations INFORMATION_SCHEMA queries that search for information from more than one database might take a long time and impact ...They ... INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-sql-statements.html
This section discusses several SQL statements that can prove useful in managing and monitoring a MySQL server that is connected to an NDB Cluster, and in some cases provide information about the cluster itself. SHOW ENGINE NDB STATUS, SHOW ENGINE ...However, you can use LIKE to filter queries against the Information Schema ENGINES table, as discussed in the next ...
https://dev.mysql.com/doc/refman/8.0/en/query-attributes.html
Examples of the ways query attributes may be used: A web application produces pages that generate database queries, and for each query must track the URL of the page that generated it. Defining and Accessing Query Attributes Prerequisites for Using ... The most visible part of an SQL statement is the text of the ...
https://dev.mysql.com/doc/refman/8.0/en/data-size.html
Indexes are good for retrieval, but slow down insert and update operations. This can result in huge improvements by reducing the amount of data written to and read from disk. MySQL supports many different storage engines (table types) and row ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-optimization.html
The most general way to satisfy a GROUP BY clause is to scan the whole table and create a new temporary table where all rows from each group are consecutive, and then use this temporary table to discover groups and apply aggregate functions (if ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-failure-detection.html
In that case, the suspect member is marked for expulsion from the group in a coordinated decision, and is expelled after the waiting period set by the group_replication_member_expel_timeout system variable expires and the expelling mechanism detects ... Group Replication’s failure detection mechanism is a distributed service which is able to identify that a server in the group is not communicating with the others, and is therefore suspected of being out of ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-multi-primary-mode.html
Any member that is compatible with the other group members is set to read/write mode when joining the group, and can process write transactions, even if they are issued concurrently. Group Replication does not handle client-side failover itself, so ... In multi-primary mode (group_replication_single_primary_mode=OFF) no member has a special ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-benefits.html
You can stop and start the memcached server without losing updates made to cached data. Because you can access the underlying data through SQL, you can produce reports, search or update across multiple keys, and call functions such as AVG() and ...
https://dev.mysql.com/doc/refman/8.0/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 ...