PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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 ...
https://dev.mysql.com/doc/refman/5.7/en/limit-optimization.html
If you need only a specified number of rows from a result set, use a LIMIT clause in the query, rather than fetching the whole result set and throwing away the extra data. MySQL sometimes optimizes a query that has a LIMIT row_count clause and no ...