NobleBlocks

Research indexBook chapter

Caching

Krogh

Apress eBooks1 Jan 2020

NobleIDark:/48914/w1/20260521/434A5390DOI10.1007/978-1-4842-5584-1_27

Paywalled

The full text is at the publisher

You can read the abstract here, or open it at the publisher.

Read at the publisher

Abstract

The cheapest queries are those you do not execute at all. This chapter investigates how you can use caching to avoid executing queries or to reduce the complexity of queries. First, it will be discussed how caching exists everywhere and how there are different types of caching. Then it is covered how you can use caching inside MySQL using cache tables and approximate values. The two next sections consider the two popular products that offer caching: Memcached and ProxySQL. Finally, some caching tips are discussed.

Discussion

Topics

More

Suggest a correction or report