Re: configuring new server / many slow disks?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




Am 09.03.2007 um 12:42 schrieb Richard Huxton:

Axel Rau wrote:
Hi performers,
after following this list for a while, I try to configure a database server with a limited budget.
Planned are 2 databases
- archiveopteryx -  http://www.archiveopteryx.org/sql-schema.html
- ERDB - https://www.chaos1.de/svn-public/repos/network-tools/ERDB/ trunk/database/ERD.pdf In peak times I expect something like
- 50 inserts
- 20 updates
- 200 selects
per second.

Presumably with multiple clients, not just one extremely busy one?
Multiple clients do mainly selects (the IMAP users), few mailservers are busy and do mainly inserts and updates.
How big do you expect the databases to get?
Up to 1 TB. The 1st DB is an IMAP message store, which keeps Mime message parts as byteas in one table (bodyparts).

That'll affect the next point.

Current configuration is:
- Tyan S3992G3NR
- 2 x Opteron 2212 (2GHz)
- 8 GB RAM (DDR2-667)

Depending on the amount of data you've got to deal with, it might be worth trading disks/cpu for more RAM.

- ARC-1261ML with 1GB and BBU

OK, so you can turn write-caching on. That should let you handle more updates than you need. You probably don't need so much RAM on board either, unless each update has a lot of data in it.
updates not, but inserts may have 10-20 MBs.

- 16 Seagate ST3250820NS (250GB, 7200 rpm, 8GB, with perpendicular recording)
1 raid 1 for OS (FreeBSD) and WAL
1 raid 0 with 7 raid 1 for tablespace
Can I expect similar performance as 5 drives at 10k rpm (same costs)?

The main question is whether you're going to need to hit the disks often. If you can get to the stage where the working-set of your DBs are all in RAM you could sacrifice some disks. If not, disk I/ O dominates.
Because of the table with the blobs, I need the many disks.
Perhaps this table would be worth of on an own table space / raid 10 set.

Should I revert to a single-CPU to prevent from oscillating cache updates between CPUS?
Anybody experience about NUMA stuff with FreeBSD?

Sorry - I know nothing about FreeBSD.

That any use - I didn't bother to reply before because I couldn't help with the BSD stuff, and it's always guesswork with these sorts of questions.
--
Axel
---------------------------------------------------------------------
Axel Rau, ☀Frankfurt , Germany                       +49 69 9514 18 0




[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux