PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/locking-issues.html
MySQL manages contention for table contents using locking: Internal locking is performed within the MySQL server itself to manage contention for table contents by multiple threads. External locking occurs when the server and other programs lock ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-logging-management-commands.html
The following table describes the default setting (for all data nodes) of the cluster log category threshold. Table 25.54 Cluster log categories, with default threshold setting Category Default threshold (All data nodes) STARTUP 7 SHUTDOWN 7 ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndb-innodb-engines.html
For those unaccustomed to working with NDB, unexpected behaviors can arise due to its distributed nature with regard to transactions, foreign keys, table limits, and other characteristics. The NDB storage engine is implemented using a distributed, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-nodes-groups.html
However, it is also possible to employ user-defined partitioning with NDBCLUSTER tables. This is subject to the following limitations: Only the KEY and LINEAR KEY partitioning schemes are supported in production with NDB tables. The maximum number ... This section discusses the manner in which NDB Cluster divides and duplicates data for ...
https://dev.mysql.com/doc/refman/8.0/en/obtaining-plugin-information.html
There are several ways to determine which plugins are installed in the server: The Information Schema PLUGINS table contains a row for each loaded plugin. The mysql.plugin table shows which plugins have been registered with INSTALL PLUGIN. The ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-blob.html
Do not use this technique when the entire table is compressed by InnoDB or MyISAM. For a table with several columns, to reduce memory requirements for queries that do not use the BLOB column, consider splitting the BLOB column into a separate table ... When storing a large blob containing textual data, consider compressing it ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-queries.html
If the event tables contain both file and nonfile information, post-filtering is another way to see information only for file events. These indexes also improve performance for related objects, such as sys schema views that use those tables.
https://dev.mysql.com/doc/refman/8.0/en/pluggable-storage.html
Unplugging a Storage Engine To unplug a storage engine, use the UNINSTALL PLUGIN statement: UNINSTALL PLUGIN example; If you unplug a storage engine that is needed by existing tables, those tables become inaccessible, but are still present on disk ... MySQL Server uses a pluggable storage engine architecture that enables storage engines to be loaded into and unloaded from a running MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/replication-administration-status.html
The Performance Schema has replication tables that provide this information in a more accessible form. The replication heartbeat information shown in the Performance Schema replication tables lets you check that the replication connection is active ... The most common task when managing a replication process is to ensure that replication is taking place and that there have been no errors between the replica and the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-functions-async-failover.html
Source lists are stored in the mysql.replication_asynchronous_connection_failover and mysql.replication_asynchronous_connection_failover_managed tables, and can be viewed in the Performance Schema replication_asynchronous_connection_failover table.