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

[Ken W]

I have a couple more data points to offer....

1. I wrote a little benchmarking script in Python to test four performance parameters;

2. I also benchmarked the two machines querying the same problematic table.

The test results for both are below:

Python Benchmark Test

CYBERPOWERPC

Timestamp: 2025-02-20 16:10:15
CPU Time: 0.6834 sec
Disk Write Time: 0.0694 sec
Disk Read Time: 0.0263 sec
MySQL Query Time: 36.2028 sec

Dell Inspiron Laptop

Timestamp: 2025-02-20 16:15:27
CPU Time: 3.0518 sec
Disk Write Time: 0.0759 sec
Disk Read Time: 0.0352 sec
MySQL Query Time: 28.0875 sec


MySQL Table Query Test

CYBERPOWERPC

--- SELECT * FROM record WHERE id_record <=5000000;
Posted Query Time: 9.734 seconds
Actual Query Time: 24.09 seconds

Dell Inspiron Laptop

--- SELECT * FROM record WHERE id_record <=5000000;
Posted Query Time: 16.875 seconds
Actual Query Time: 40.29 seconds