mysql Database server debugging
Budget: $30 – $250 USD
We have a mysql server running on centos7. We need to solve three problems:
1. The cpu usage rate is too high (often over 30%), please help us find the problematic query statement.
2. The memory cannot be released automatically, and it will return to normal after restarting, but after about 2~3 days, the memory usage will reach 100%, and it will not work normally.
3. We only have one primary server now, and we plan to set up another server as a backup to ensure that the data on the two servers is completely consistent. The sync interval can be set to sync every hour.
1. The cpu usage rate is too high (often over 30%), please help us find the problematic query statement.
2. The memory cannot be released automatically, and it will return to normal after restarting, but after about 2~3 days, the memory usage will reach 100%, and it will not work normally.
3. We only have one primary server now, and we plan to set up another server as a backup to ensure that the data on the two servers is completely consistent. The sync interval can be set to sync every hour.