Comments - Phenomenon of read-only queries performance

8 years, 2 months ago Nirbhay Choubey

The performance gain in the first scenario on switch from R/W to R/O could be due to usual database "warm-up".

When compared to standalone server, galera node (assuming that the test was run against a galera cluster with a single node) should perform as good as standalone if not worse. So, I suspect the two servers were run with different configurations. One option would be to compare servers' system and status variables using SHOW VARIABLES & SHOW STATUS respectively.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.