Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

We have 3 servers running in a percona mysql cluster. Two of the servers in the cluster are running on older hardware specs. The third is a real monster with a lot of RAM and SSD hard drives and so on.

The problem I'm facing is that queries are very slow on the new more powerful server. A test query I've been using takes ~70s to perform on the older servers and ~177s on the new server so it is significant.

Does anyone have any clues to why this happens? Any points of directions and/or suggestions on how to solve this problem would be most welcomed.

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.