I have installed MySQL HA kubernetes pod following the guideline below.
https://portworx.com/run-ha-mysql-rancher-kubernetes-engine/ which use Portworx storage.
The deployment is successful and I have created databases and tables inside the pod, however, the query speed is super slow like on average one query takes 45 seconds. I am not so sure if it is related to the volume read-write speed. Could I know if there is configuration set to speed up the process. The cpu and ram setting is set as best effort as there is no cpu and ram limit set at the deployment yaml.
Hope can gather some insight from you guys. Thanks in advance.