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/innodb-create-table-external.html
Attempting to access a table when the associated data file is missing causes a serious error that requires a server restart. There are different reasons for creating InnoDB tables externally; that is, creating tables outside of the data directory.
https://dev.mysql.com/doc/refman/8.0/en/innodb-data-encryption.html
It uses Electronic Codebook (ECB) block encryption mode for tablespace key encryption and Cipher Block Chaining (CBC) block encryption mode for data encryption. Failing to do so results in errors when starting the server and during InnoDB recovery.
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlock-detection.html
The same error may also occur if the locking thread must look at more than 1,000,000 locks owned by transactions on the wait-for list. When deadlock detection is enabled (the default), InnoDB automatically detects transaction deadlocks and rolls ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking.html
If a lock request conflicts with an existing lock and cannot be granted because it would cause deadlock, an error occurs. Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-internals.html
You cannot make a covering index for memcached lookups; InnoDB returns an error if you try to define a composite secondary index over both the key and value columns. InnoDB API for the InnoDB memcached Plugin The InnoDB memcached engine accesses ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-intro.html
For example, you can change the port that memcached listens on, reduce the maximum number of simultaneous connections, change the maximum memory size for a key-value pair, or enable debugging messages for the error log. The InnoDB memcached plugin ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-replication.html
mysql> START SLAVE; Or from MySQL 8.0.22: mysql> START REPLICA; If the error log prints output similar to the following, the replica is ready for replication. Because the daemon_memcached plugin supports the MySQL binary log, source server through ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-security.html
memcp --servers=localhost:11211 --binary --username=testname --password=password myfile.txt memcat --servers=localhost:11211 --binary --username=testname --password=password myfile.txt If you specify an incorrect user name or password, the operation ... Caution Consult this section before deploying the daemon_memcached plugin on a production server, or even on a test server if the MySQL instance contains sensitive ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-tuning.html
In case of an outage, a maximum of 100 records are lost, which may be an acceptable margin of error. Because using InnoDB in combination with memcached involves writing all data to disk, whether immediately or sometime later, raw performance is ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-monitor-types.html
There are two types of InnoDB monitor: The standard InnoDB Monitor displays the following types of information: Work done by the main background thread Semaphore waits Data about the most recent foreign key and deadlock errors Lock waits for ...