How To Optimize MySQL Queries with ProxySQL Caching on Ubuntu 16.04
ProxySQL is a SQL-aware proxy server that can be positioned between your application and your database to create a caching layer to optimize MySQL queries. In this tutorial, you will use ProxySQL to set up transparent caching for a MySQL server on Ubuntu 16.04. You will then test its performance using mysqlslap with and without caching to demonstrate the effect of caching and how much time it can save when executing many similar queries.