Anand on Database Server Platforms
Posted on: 04/04/2002 09:17 PM

Man. The Boi Wonder never ceases to amaze me. This time he's pulled out all the stops and compared AMD and Intel's baddest DP platforms in a database battle royale. Like some of his previous database tests, Anand used snapshots of his own site's database access patterns and ran dual Xeons and dual Athlon MPs through the gauntlet. Here's a quote:
The Web DB is where all of our content is stored; everything from news and reviews to our own internal article rankings are stored in this database. By far the majority of the transactions on this database are selects (reads). Remember that the web site only really offers one way interaction, the readers come to the site and read articles which are contained in this database. The articles are selected from the database and fed to one of the 4 web servers for assembly into a page for your browser. Internally, some update queries are also run, but they were not recorded in the test trace we ran. This database is the smallest out of the three; the DB was only 300MB when we ran the test.

The Ad DB is very similar to the web database in that quite a few selects are running. The select queries are used to pull the ads from the database for display in the user's browser. There are also a number of stored procedures that run along with the selects, but to keep things as simple as possible (at least for this comparison), we omitted them from the test trace. The Ad DB is noticeably larger than the web database, at a large 2.1GBs at the time of publication.

The final database is the Forums DB, which is by far the most transaction intensive database in the AnandTech Network. While the vast majority of the requests to the DB are in the form of selects (users reading categories and threads), there are significantly more inserts and updates (posting, thread/post counts, etc…) than in either of the other DBs. This database is also our largest, weighing in at just under 3GB during the testing and close to 8GB today (we used an older version of the DB from a few months ago).
In typical Anandtech fashion, the review is eleventeen pages long, but it is worth reading every word. There are many valid points made, and many surprising details revealed. You must read this article!




Printed from 2CPU.com (http://www.2cpu.com/contentteller.php?ct=news&action=story&page=anand_on_database_server_platforms.html)