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/mysql-cluster-config-starting.html
LockPagesInMainMemory=1 # On Linux and Solaris systems, setting this parameter locks data node # processes into memory. Changes in configuration are also likely to be indicated when changes are made in the platform on which the cluster is run, or in ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-counters.html
The counters table provides running totals of events such as reads and writes for specific kernel blocks and data nodes. The counters table contains the following columns: node_id The data node ID block_name Name of the associated NDB kernel block ...Counts are kept from the most recent node start or restart; a node start or restart resets all counters on that ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-privilege-synchronization.html
Beginning with NDB 8.0.27, an SQL node performing a change to user privileges takes a global lock before doing so, which prevents deadlocks by concurrent ACL operations on different SQL nodes. Prior to NDB 8.0.27, changes to users with ... NDB 8.0 ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-select-count.html
ndb_select_count prints the number of rows in one or more NDB tables. With a single table, the result is equivalent to that obtained by using the MySQL statement SELECT COUNT(*) FROM tbl_name. Usage ndb_select_count [-c connection_string] -ddb_name ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndbd.html
It also functions as a lock file to avoid the starting of nodes with the same identifier. It is recommended not to use a directory mounted through NFS because in some environments this can cause problems whereby the lock on the .pid file remains in ... The ndbd binary provides the single-threaded version of the process that is used to handle all the data in tables employing the NDBCLUSTER storage ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-overview.html
As you work on database performance, you start by learning the high-level rules and guidelines for the software side, and measuring performance using wall-clock time. Does the application use an appropriate locking strategy? For example, by allowing ... Database performance depends on several factors at the database level, such as tables, queries, and configuration ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html
An exclusive table lock is only taken briefly during the prepare phase and the commit phase of the operation. Otherwise, MySQL locks the table during the time OPTIMIZE TABLE is running. OPTIMIZE TABLE reorganizes the physical storage of table data ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations.html
Generally, the process executing a partitioning operation on a table takes a write lock on the table. This section discusses current restrictions and limitations on MySQL partitioning support. The following constructs are not permitted in ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-waits-current-table.html
For example, if a mutex or lock is being blocked, you can check the context in which this occurs. For a synchronization object (cond, mutex, rwlock): OBJECT_SCHEMA, OBJECT_NAME, and OBJECT_TYPE are NULL. For example, it can be used with GROUP BY ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-object-filtering.html
TABLE filtering affects table I/O events (wait/io/table/sql/handler instrument) and table lock events (wait/lock/table/sql/handler instrument). The setup_objects table controls whether the Performance Schema monitors particular table and stored ...