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/ndb-restore-different-number-nodes.html
The files created by the backup on each data node are listed here, where N is the node ID and B is the backup ID. BACKUP-B-0.N.Data BACKUP-B.N.ctl BACKUP-B.N.log These files are found under BackupDataDir/BACKUP/BACKUP-B, on each data node. Have all ... It is possible to restore from an NDB backup to a cluster having a different number of data nodes than the original from which the backup was ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-developing.html
The data stored through the daemon_memcached plugin goes into VARCHAR, TEXT, or BLOB columns, and must be converted to do numeric operations. Typically, writing an application for the InnoDB memcached plugin involves some degree of rewriting or ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-multi-versioning.html
Internally, InnoDB adds three fields to each row stored in the database: A 6-byte DB_TRX_ID field indicates the transaction identifier for the last transaction that inserted or updated the row. Update undo logs are used also in consistent reads, but ...InnoDB uses the information in the rollback segment to perform the undo operations needed in a transaction ...It keeps ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlocks.html
If frequent deadlocks highlight a problem with transaction structure or application error handling, enable innodb_print_all_deadlocks to print information about all deadlocks to the mysqld error log. When deadlock detection is enabled (the default) ... A deadlock is a situation in which multiple transactions are unable to proceed because each transaction holds a lock that is needed by another ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached.html
The InnoDB memcached plugin (daemon_memcached) provides an integrated memcached daemon that automatically stores and retrieves data from InnoDB tables, turning the MySQL server into a fast “key-value store”. You can also access the same InnoDB ... Important The InnoDB memcached plugin was removed in MySQL 8.3.0, and was deprecated in MySQL ...Instead of formulating queries in SQL, you can use simple get, set, and incr operations that ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool-optimization.html
InnoDB maintains a storage area called the buffer pool for caching data and indexes in memory. Knowing how the InnoDB buffer pool works, and taking advantage of it to keep frequently accessed data in memory, is an important aspect of MySQL tuning.
https://dev.mysql.com/doc/refman/8.0/en/innodb-and-mysql-replication.html
For example, you can replicate modifications to an InnoDB table on the source to a MyISAM table on the replica. MySQL replication is based on the binary log where MySQL writes SQL statements that modify data. Cascading actions for InnoDB tables on ... It is possible to use replication in a way where the storage engine on the replica is not the same as the storage engine on the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-porting-memcached.html
This is because InnoDB performs best for large-scale insertions if primary key values are added in sorted order (as they are with auto-increment values). If you store several different classes of information using memcached, consider setting up a ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-analyze-table-complexity.html
ANALYZE TABLE complexity for InnoDB tables is dependent on: The number of pages sampled, as defined by innodb_stats_persistent_sample_pages. Using these parameters, an approximate formula for estimating ANALYZE TABLE complexity would be: The value ...The number of indexed columns in a table The number of ...For more information, see Section 17.8.10.1, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndb-innodb-workloads.html
A number of major differences in behavior between the NDB and InnoDB storage engines with regard to some common types of database-driven application workloads are shown in the following table:: Table 25.3 Differences between InnoDB and NDB storage ... NDB Cluster has a range of unique attributes that make it ideal to serve applications requiring high availability, fast failover, high throughput, and low ...