Research indexBook chapter
Caching
Krogh
Apress eBooks1 Jan 2020
NobleIDark:/48914/w1/20260521/434A5390DOI10.1007/978-1-4842-5584-1_27
Caching
Krogh · Apress eBooks · 2020 · Subscription
NobleIDark:/48914/w1/20260521/434A5390DOI10.1007/978-1-4842-5584-1_27
The full text is at the publisher
You can read the abstract here, or open it 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.