MySQL running VERY slowly on a new i9 machine. Ideas or advice?

[Ken Wachs]

Hello All:

I have been using MySQL 8.0.26 on my i7 Dell Inspiron laptop for about 5 years (full specs below). Last week, I purchased some upgraded hardware for an important project: An i9 CyberPowerPC gaming computer with 64 Gig of RAM.

The problem is that the exact same MySQL queries are running MUCH slower on the i9 machine compared with my i7 laptop. The databases and tables are identical (I just finished migrating them), as are the MySQL configs.

Using one of my more complex queries, I benchmarked some performance numbers.
As you can see, the new machine is slower by a factor of more than 2x:

- CyberPowerPC i9: MySQL Query Test
+ Run Time = 219.188 seconds

- Dell i7: MySQL Query Test
+ Run Time = 98.297 seconds

I know the CyberPowerPC is not running slowly for everything. Below are some benchmark numbers for a particularly large and complex spreadsheet. As you can see, the new hardware does buy me quite a bit of performance in Excel.

- CyberPowerPC: Excel Sheet Test
+ Open File = 17.42 seconds
+ Run Analysis = 1:41 minutes/seconds
+ Clear Filter = 24.24 seconds
+ Recalc = 6.43 seconds


- Dell Laptop: Excel Sheet Test
+ Open File = 29.42 seconds
+ Run Analysis = 2:47 minutes/seconds
+ Clear Filter = 39.18 seconds
+ Recalc = 14.00 seconds

What is going on here? Can I resolve this? Or should I get a different machine?

Any help would be appreciated!

Ken


Full Specs:

Dell Inspiron Laptop
- 11th Gen Intel(R) Core(TM) i7-1165G7 @ 2.80GHz 2.80 GHz
- 16.0 GB Ram
- 64 bit Windows 10 Home
- 1 TB SSD
- MySQL 8.0.26 (64 bit)

CyberPowerPC Gaming Desktop
- Intel(R) Core(TM) i9-14900KF 3.20 GHz
- 64.0 GB Ram
- 64-bit Windows 11 Home
- 2 TB SSD
- MySQL 8.0.41 (64 bit)