PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-locking.html
They do not conflict with each other, and they perform the same function. Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks Predicate Locks for Spatial Indexes Shared and Exclusive ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-developing.html
You can perform the conversion on the application side, or by using the CAST() function in queries. Typically, writing an application for the InnoDB memcached plugin involves some degree of rewriting or adapting existing code that uses MySQL or the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-multiple-buffer-pools.html
Each page that is stored in or read from the buffer pool is assigned to one of the buffer pools randomly, using a hashing function. For systems with buffer pools in the multi-gigabyte range, dividing the buffer pool into separate instances can ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-page-compression.html
Better page compression may be achieved on Fusion-io hardware with NVMFS than on other platforms, as NVMFS is designed to take advantage of punch hole functionality. InnoDB supports page-level compression for tables that reside in file-per-table ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-use_sys_malloc.html
If set to ON or 1 (the default), InnoDB uses the malloc and free functions of the underlying system rather than manage memory pools itself. When InnoDB was developed, the memory allocators supplied with operating systems and run-time libraries were ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-restrictions-limitations.html
For information about how InnoDB processes SELECT COUNT(*) statements, refer to the COUNT() description in Section 12.19.1, “Aggregate Function Descriptions”. This section describes restrictions and limitations of the InnoDB storage engine. You ...
https://dev.mysql.com/doc/refman/5.7/en/internal-locking.html
This section discusses internal locking; that is, locking performed within the MySQL server itself to manage contention for table contents by multiple sessions. This type of locking is internal because it is performed entirely by the server and ...
https://dev.mysql.com/doc/refman/5.7/en/kill.html
The value for the current thread is returned by the CONNECTION_ID() function. KILL [CONNECTION | QUERY] processlist_id Each connection to mysqld runs in a separate thread. Thread processlist identifiers can be determined from the ID column of the ...
https://dev.mysql.com/doc/refman/5.7/en/libmysqld-compiling.html
The correct flags for compiling and linking a threaded program must be used, even if you do not directly call any thread functions in your code. In precompiled binary MySQL distributions that include libmysqld, the embedded server library, MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/libmysqld-restrictions.html
The embedded server has the following limitations: No loadable functions. You cannot set this up as a source or a replica (no replication). Very large result sets may be unusable on low memory systems. You cannot connect to an embedded server from ...