Performance tuning
The first thing you may have noticed is the slowness involved by the network in a sharding mode. This is absolutely normal, you can't expect to have the same speed compared to one local server if your requests are basic. So how to deal with those problems? Let's see how.
Spider parameters
Spider includes a large set of parameters by default. Like most of the engines, you can change the default parameters to speed up the query time.
The bgs mode
One of the most important settings is spider_bgs_mode
. By default, it is disabled to optimize memory usage. However, you can change its value if your Spider servers have enough RAM to support it. If you change the default value, you can perform a read query in parallel when the plan prunes ...
Get MariaDB High Performance now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.