Description

MySQL has long shipped with the Query Cache feature but its actual performance has been abismal. In fact, it can even slow queries down when misused. Though keep in mind that the Query Cache has been deprecated as of MySQL 5.7.x. This is where the QueryBoost plugin comes in. It not only obliterates the Query Cache in terms of performance, QueryBoost is just in its own league.

Technology

QueryBoost is a service that runs in two modes: caching and non-caching. In caching mode it's able to seamlessly identify any and all queries you've selected to cache and accelerate. You can select as many queries as needed via cPanel (see screen shots). You can also set the duration of time after which the query cache will expire. Each query can have its own expiry time.

In the next feature that is being developed, you can instruct QueryBoost's compact AI engine to selectively cache SELECT queries that it deems most optimal for your website. You can then give it autonomy to take the best decision while you're unavailable or too busy to attend to your website.