1

I installed MySQL db for storing my simulation data in phd. First I used a pc with i7-8700 cpu, 24 gb ram and 1 TB nvme disk.

Then I transferred data to a newer pc with i7-12700 cpu, 48 GB ram and 2x1 nvme 1 TB disk in soft raid0 configuration. Since then my query performance become very slow. It was 10-15 minutes in old pc to 2.5 hours on the newer hardware. I configured the conf file according to new hardware but nothing changed. Any ideas please. I am desperate.

HakanA
  • 29
  • 1

1 Answers1

-2

Considering you have already adjusted the 'conf' file to your new hardware. You might want to ensure that your tables are still properly indexed. If you're running queries they may have changed during the transfer.

I would also make sure you're monitoring the disk performance as you have raid0 config. Your disk can always be a bottleneck, especially if something is not configured right. Please check your raid0 config and ensure it is set appropriately.

Vividlee
  • 9
  • 2