panelfront
New Pleskian
Hello , I have a issue with mysql performance , mysql cpu time multiplied by x3 , this started suddenly. I didn't changed any config , didnt update server , it just started suddenly.
My server with problem is 32 core . I have lot of free ram.
For test purposes I added 1000 row to empty mysql table in php foreach loop. It took 0.6 seconds.
I did same test with 8 core server and it took 0.2 seconds.
When I performed these tests there were no traffic at all on both servers , load averages were 1.0
When I perform test on 32 core server iowait suddenly jumps to (between 0.2 - 0.8 )
I attached mysql cpu time graphic. It started suddenly like this. I have same traffic , same iops , same everything..
How should I track this issue and what can cause this kind of issue ?
thank you
My server with problem is 32 core . I have lot of free ram.
For test purposes I added 1000 row to empty mysql table in php foreach loop. It took 0.6 seconds.
I did same test with 8 core server and it took 0.2 seconds.
When I performed these tests there were no traffic at all on both servers , load averages were 1.0
When I perform test on 32 core server iowait suddenly jumps to (between 0.2 - 0.8 )
I attached mysql cpu time graphic. It started suddenly like this. I have same traffic , same iops , same everything..
How should I track this issue and what can cause this kind of issue ?
thank you