0

Recently we changed version of RDS mysql from 5.7 to 8.0 by using blue/green deployment. first we put our green instance in 5.7 version later we upgraded the instance and switched over successfully.Later problem got started. CPU utilization is 90% above now and application database running is very slow. and there is no query cache in mysql 8.0..can you please explain how to over come these 2 problrms..please

We tried changing instance type of RDS from t2.medium to t3.medium. still showing 90% of CPU utilization(before it never touches 90%).and also added inno db buffer to database still there database is very slow..I want to resolve these two problems as soon as possible.I need solutions for these two Issues

Improve this question
6
  • Are the 2 problems, A) no query cache in 8.0 and B) 90% CPU utilization? Please confirm. Commented Feb 28, 2024 at 13:43
  • For your B) Additional DB information request, please. Any SSD or NVME devices on MySQL Host server? Post TEXT data on justpaste.it and share the links. From your SSH login root, Text results of: A) SELECT COUNT(*) FROM information_schema.tables; B) SHOW GLOBAL STATUS; after minimum 24 hours UPTIME C) SHOW GLOBAL VARIABLES; D) SHOW FULL PROCESSLIST; E) STATUS; not SHOW STATUS, just STATUS; G) SHOW ENGINE INNODB STATUS; for server workload tuning analysis to provide CPU conserving suggestions. Commented Feb 28, 2024 at 13:45
  • Could you post the CPU utilization graph for the last 7 days? Commented Feb 28, 2024 at 13:46
  • For your A) observation, we have encouaged customers on 5.7 to TURN OFF query feature and none of them missed the query cache feature for the past two years. The reason they do not miss the Query Cache feature is because the processing to manage qcache_lowmem_prunes can be very resource intensive. This reinforces the need to use the Slow Query Log to minimize the number of queries running more than one second. A goal since the beginning of serious computing. Commented Feb 28, 2024 at 13:52
  • If you must have Query Cache, MariaDB still supports Query Cache. I suspect you want to avoid changing from MySQL, if possible. Not a trivial project. Commented Feb 28, 2024 at 14:03
Related questions
0
Laravel 5.2 + MySQL 8.0 On RDS - Connection Errors Out With "SQLSTATE[HY000] [2002]"
0
AWS RDS MySQL 8.0 Parameter Groups
108
How does Amazon RDS backup/snapshot actually work?
Load 4 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.