We are testing our database performance using JMeter. Our test call to a web service starting with 10 to 600 users on a time range of 15 minutes. The process adds them in a linear increase.
At some moment, the number of threads growth dramatically, coinciding with high consumption of CPU. We are not sure if this is a normal situation… We already review some indicators, but we couldn’t see anything relevant. Do any of you have this situation before?
In the attached image, you can see this situation.
The system is configured in this way:
Percona MySQL Server 5.7.25.
Mainly innodb engine.
innodb_flush_method = O_DIRECT
sql-mode = “”
key_buffer_size = 512M
max_allowed_packet = 512M
[/LIST]Virtual Machine (MySQL)
8 GB Memory
50 GB SSD
OS: CentOS Linux release 7
I hope someone can give us a hand. If you need other graphs, do not hesitate to asking for them.