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-locking.html
As a result, both T1 and T2 hold an S lock on r. 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 Locks InnoDB implements ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-developing.html
Both queries (read) and DML (write) operations can be substantially faster when performed through the InnoDB memcached interface. Typically, writing an application for the InnoDB memcached plugin involves some degree of rewriting or adapting ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-intro.html
Both mysqld and memcached run in the same process space, with very low latency access to data. The InnoDB memcached plugin implements memcached as a MySQL plugin daemon that accesses the InnoDB storage engine directly, bypassing the MySQL SQL layer. The following diagram illustrates how an application accesses data through the daemon_memcached plugin, compared with ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-porting-mysql.html
Consider these aspects of memcached applications when adapting an existing MySQL schema or application to use the daemon_memcached plugin: memcached keys cannot contain spaces or newlines, because these characters are used as separators in the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-tuning.html
Depending on the type of application, you might increase one or both of these settings to reduce the overhead of frequent commit operations. Because using InnoDB in combination with memcached involves writing all data to disk, whether immediately ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached.html
The combination of memcached simplicity and InnoDB reliability and consistency provides users with the best of both worlds, as explained in Section 17.20.1, “Benefits of the InnoDB memcached Plugin”. Important The InnoDB memcached plugin was ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-performance.html
LOCK=DEFAULT: Permits as much concurrency as possible (concurrent queries, DML, or both). Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl.html
For example: To avoid accidentally making the table unavailable for reads, writes, or both, during an in-place ALTER TABLE operation, specify a clause on the ALTER TABLE statement such as LOCK=NONE (permit reads and writes) or LOCK=SHARED (permit ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-page-compression.html
Page-compressed tablespaces can be copied between Linux and Windows servers if the compression algorithm that was used is available on both servers. InnoDB supports page-level compression for tables that reside in file-per-table tablespaces. Page ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-compression-oltp.html
Because working with compressed data sometimes involves keeping both compressed and uncompressed versions of a page in memory at the same time, when using compression with an OLTP-style workload, be prepared to increase the value of the ...