MYSQL server get CPU utilization 100% while running on Redmine Application in ubuntu [closed]

When we  click on "Spent time" on redmine application, the cpu utilisation of mysql server goes to 100%  and the whole system hangs.  What is the possible solution for this App Server - Config (Ubuntu 20.01 - Rails version- 2.7, Redmine version-5.0.1 , vCPUs 2 and Instance type-t2 medium

files been loading in the application: 250 Users 1200 projects 32000 Issues 180000 time logs