Im running AWS aurora 5.7. The application stack is PHP. After moving to Aurora, I noticed that the CPU consumption is really high. When I checked the performance insights, its showing the SET command is consuming more. (Green colour is CPU)
And I checked the Aurora Billed Read IOPS, which is almost zero, I think most of them are in InnoDB buffer pool, I didn't see any slow queries, all are executed within a second.
So what Im thinking, the number of SQL queries on this server is a bit high, and thats why the Set command is showing more CPU.
Can someone help to understand this?
And I checked the Aurora Billed Read IOPS, which is almost zero, I think most of them are in InnoDB buffer pool, I didn't see any slow queries, all are executed within a second.
So what Im thinking, the number of SQL queries on this server is a bit high, and thats why the Set command is showing more CPU.
Can someone help to understand this?
Asked by TheDataGuy
(1986 rep)
Oct 23, 2021, 05:46 AM
Last activity: Jul 17, 2025, 03:05 PM
Last activity: Jul 17, 2025, 03:05 PM