This question already has an answer here:
I have a wordpress database (4GB). I have two servers with the following spec:
Processor Cores RAM HDD DBMS 1. Xeon X5650 2.6GHz 6 64GB 250GB SSD Mariadb 10.1 2. Corei7 4740 3.4GHz 4 32GB 250GB SSD Mariadb 10.1
I run a query which is a LEFT JOIN on two tables (wp_posts, wp_term_relationships) on both servers and I get surprised when I see the results. I run query with and without configuring my.cnf. If I run the query on the 1st server the execution time varies from 4.48s to 5.2s and if I run the query the execution time on the 2nd one varies from 1.8s to 3.2!! I thought Xeon Processors are much faster than the Corei ones! But with these results I think I have to use one of the Corei7 CPU family for my database server which is expected to be very busy (a lot of query). If it is, why Xeon CPUs are specially designed for servers?? I wonder to know which kind of CPU the big companies with a great database load query are using?