Upgraded from 5.32 to 6.0.0. Although the DB schema changes took forever–it successfully upgraded. But now regardless of the client (Windows Desktop, Android, iPhone, or Web Browser), users are complaining about sluggish behavior. I’ve also been able to replicate it. It also seems that this version is far more DB intensive then the previous one. Has anyone else experienced this? Any suggestions?
O/S: Ubuntu 20.04
DB: MySQL 8.0.26-0ubuntu0.20.04.2
Server: AWS EC2 “c5.2xlarge” instance (16GB RAM, 8 vCPUs, 500GB EBS)
Stats: