Search code examples
mysqldatabasewindows-server

Does a MySQL database run faster on Windows server or Windows 10?

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?

Solution

  • 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.