Simple Machines > Archives

New SQL Server

<< < (29/31) > >>

Bas:
I do agree RAID10 is faster if you don't have enough drives.

But I do not agree on the number of cores, it's already proven that many cores without the much needed memory band-weight is useless.
For everything the CPU does it's pulling data from the memory and pushing the result back.
Caching does a bit, but upto a point, it still needs to write it to the memory...and in the end to the harddisk.

I doubt you are even able to get all cores fully loaded at all with MySQL...sure a CPU bench running in cache could, but real life....no way.

This problem isn't new, it was already there at the 486DX100 ages, the CPU was too fast for the memory and hardly did any better then the 486DX66....and in those days the memory speed wasn't that far back on the CPU speed.
8 cores, with terribly limited band-weight? No way...sorry...waste of money on the CPU, 4 core would have worked just the same.

Arantor:
For many typical apps, I've no doubt you may be correct, Bas, but this thread has seen comment from the admin of this forum, and indeed I know the admin of one of the largest SMF forums worldwide has seen this thread too.

For the load that SMF generates, how it generates it and how it works in terms of MySQL it is simply more CPU intensive than other apps, when you have properly built indexes stored in memory, plus memory tables.


Out of interest, you mention your dedicated server: how big's your forum (we can't see it, the link appears to be broken)?

Sabre™:

--- Quote from: Arantor on September 04, 2009, 03:54:22 PM ---Out of interest, you mention your dedicated server: how big's your forum (we can't see it, the link appears to be broken)?

--- End quote ---

Typo in his link, [THIS] seems to be it.

rsw686:
If http://forum-en.msi.com/ is running on the server in Bas's sig there is something not configured right as the page load time was 6.5 seconds.

Arantor:
Thanks Sabre. Interesting.

A forum of 890k posts is no lightweight, but the load is slightly different for 890k posts/83k members vs 2m posts / 200k members, especially considering the extra things built into this site that do hook into the forum code, such as the mod site, the support site and so on.

The load on this forum is not the same as it is on a straight forum as a result and more of the operations here are thus more CPU intensive (particularly around the mod site) than I/O intensive.

Navigation

[0] Message Index

[#] Next page

[*] Previous page