Quote:
Originally Posted by TFCash
Not sure I'd put a production site on a overclocked machine, but yeah the i7-7700K will most likely spit out results faster in similarly configured machines, the dual 5620 will have some help since it has 16 threads vs the 8 from the 7700, and it's cpu cache is 50% larger.
Sql queries are more about tweaking your application to make sure it's running at 100%, you can always add more memory since mysql will use more if given more. Also your drive that is holding the database can make a huge difference in how fast you get results. And most importantly make sure you really need to hit the database, a good caching solution can speed up a site 10x with no sql changes at all.
 |
I have quite a big site with MySQL database that gets around 1500-2000 concurrent users all day, it has system cache implemented that works quite well but once traffic hits over 2000 concurrent users I start getting 502 cloudflare errors.
My current server:
2x Intel Xeon 5620
Memory: 32GB DDR3 RAM
Drive 1: 240GB SSD
50TB Traffic per month
CentOS 6.8 64-bit
1000Mbit Premium Network
Trying to configure a new server that can handle more traffic, the database isn't built in the best way but there's no chance of rebuilding it atm so looking for a stronger server.