I was wondering if a MySQL database run faster on Windows server 2019 or on Windows 10.

Are the performance based on the operating system or just on the installed hardware?

CodePudding user response：

The only significant differences are

• HDD (slower) or SSD (faster)
• Network latency (now close are the client and server)

Other things:

• CPU -- Today's CPUs don't have much range in speed. And most queries are fast enough that a CPU speed difference is usually not noticeable
• CPU cores -- See CPU.
• RAID with hardware write cache -- Beneficial for heavy write situations.
• OS -- Only if you have very little I/O and network latency might you even be able to measure an OS speed difference.