Bug #111671 MYSQL performance
Submitted: 6 Jul 2023 5:18 Modified: 6 Jul 2023 13:10
Reporter: rooma ore Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S5 (Performance)
Version:8.0 OS:Windows
Assigned to: CPU Architecture:ARM
Tags: MYSQL 8.0.3.2 performance

[6 Jul 2023 5:18] rooma ore 
Description:
Recently i upgrate mysql version from 5.7 to mysql 8.0.3 ,but i observe over all performance is very slow .Mysql 5.7 running on machine having 4gb ram 8.0 is running on machone having 8gb rame but still query is taking 3 times more than to execute than in 5.7 .both machine have same data and same table structure .
inno_db_buffer pool size =6g  fro mysql 8.0 .

Please provide solution

How to repeat:
xdxvx
[6 Jul 2023 13:10] MySQL Verification Team 
HI Mr. ore,

Thank you for your bug report.

However, there are already 38 (thirty eight) bugs that report significant drop in performance in MySQL 8.0, compared with MySQL 5.7.

This is a very well known fact, that has been discussed in various forums already.

This is due to the fact that that 8.0 has introduced so many new features. Using those features, described in our Reference Manual, could improve the performance.

Not a bug.