(mysql.info) shared-key-cache
Info Catalog
(mysql.info) myisam-key-cache
(mysql.info) myisam-key-cache
(mysql.info) multiple-key-caches
7.4.6.1 Shared Key Cache Access
...............................
Threads can access key cache buffers simultaneously, subject to the
following conditions:
* A buffer that is not being updated can be accessed by multiple
threads.
* A buffer that is being updated causes threads that need to use it
to wait until the update is complete.
* Multiple threads can initiate requests that result in cache block
replacements, as long as they do not interfere with each other
(that is, as long as they need different index blocks, and thus
cause different cache blocks to be replaced).
Shared access to the key cache enables the server to improve throughput
significantly.
Info Catalog
(mysql.info) myisam-key-cache
(mysql.info) myisam-key-cache
(mysql.info) multiple-key-caches
automatically generated byinfo2html