Sujet : Re: big, fast, etc, was is Vax addressing sane today
De : anton (at) *nospam* mips.complang.tuwien.ac.at (Anton Ertl)
Groupes : comp.archDate : 14. Sep 2024, 11:21:46
Autres entêtes
Organisation : Institut fuer Computersprachen, Technische Universitaet Wien
Message-ID : <2024Sep14.112146@mips.complang.tuwien.ac.at>
References : 1 2 3 4 5
User-Agent : xrn 10.11
John Levine <
johnl@taugh.com> writes:
It appears that Michael S <already5chosen@yahoo.com> said:
There's also a rule of thumb about databases that says one system of
performance 100 is much better than 100 systems of performance 1
because those 100 systems will spend all their time contending for
database locks.
>
How many transactions per minute does world's biggest company need at
peak hours?
>
Ten years ago Visa could process 56,000 messages/second. It must be a
lot more now. I think a transaction is two or four messages depending
on the transaction type.
>
Is not this number small relatively to capabilities of
even 15 y.o. dual-Xeon server with few dozens of spinning rust disks?
>
Uh, no, it is not.
The way I would design this for a machine with that little IOPS is as
an in-memory database, with transactions written to a log on RAID-1
(on two or three of the HDDs), and a snapshot of the in-memory
database written to disk repeatedly, with copy-on-write to get a
consistent snapshot. The 8 cores of a 2009-vintage the dual-Xeon
machine should be easily capable of doing it, but the question is if
the machine has enough RAM for the database. Our dual-Xeon system
from IIRC 2007 has 24GB of RAM, not sure how big it could be
configured; OTOH, we have a single-Xeon system from 2009 or so with
32GB of RAM (and there were bigger Xeons in the market at the time).
- anton
-- 'Anyone trying for "industrial quality" ISA should avoid undefined behavior.' Mitch Alsup, <c17fcd89-f024-40e7-a594-88a85ac10d20o@googlegroups.com>
Date | Sujet | # | | Auteur |
5 Sep 24 | is Vax adressing sane today | 134 | | Brett |
5 Sep 24 | Re: is Vax adressing sane today | 122 | | John Dallman |
6 Sep 24 | Re: is Vax adressing sane today | 1 | | Lawrence D'Oliveiro |
6 Sep 24 | Re: is Vax adressing sane today | 120 | | Anton Ertl |
6 Sep 24 | Re: is Vax adressing sane today | 1 | | Lawrence D'Oliveiro |
6 Sep 24 | Re: is Vax adressing sane today | 5 | | MitchAlsup1 |
7 Sep 24 | Re: is Vax adressing sane today | 4 | | Anton Ertl |
7 Sep 24 | Re: is Vax adressing sane today | 3 | | Anton Ertl |
7 Sep 24 | Re: is Vax addressing sane today | 2 | | John Dallman |
7 Sep 24 | Re: is Vax addressing sane today | 1 | | Anton Ertl |
7 Sep 24 | Re: is Vax adressing sane today | 111 | | John Levine |
8 Sep 24 | Re: is Vax adressing sane today | 110 | | Anton Ertl |
8 Sep 24 | Re: is Vax adressing sane today | 102 | | MitchAlsup1 |
8 Sep 24 | Re: is Vax addressing sane today | 101 | | Lawrence D'Oliveiro |
9 Sep 24 | Re: is Vax addressing sane today | 31 | | MitchAlsup1 |
9 Sep 24 | Re: is Vax addressing sane today | 30 | | Brett |
9 Sep 24 | Re: is Vax addressing sane today | 3 | | MitchAlsup1 |
10 Sep 24 | Re: is Vax addressing sane today | 2 | | Niklas Holsti |
11 Sep 24 | Re: is Vax addressing sane today | 1 | | Lawrence D'Oliveiro |
10 Sep 24 | Re: is Vax addressing sane today | 26 | | Anton Ertl |
10 Sep 24 | Re: is Vax addressing sane today | 4 | | Michael S |
10 Sep 24 | Re: is Vax addressing sane today | 3 | | Anton Ertl |
10 Sep 24 | Re: is Vax addressing sane today | 1 | | Niklas Holsti |
11 Sep 24 | Re: is Vax addressing sane today | 1 | | Michael S |
11 Sep 24 | Re: is Vax addressing sane today | 7 | | Lawrence D'Oliveiro |
11 Sep 24 | Re: is Vax addressing sane today | 6 | | Michael S |
11 Sep 24 | Re: is Vax addressing sane today | 5 | | David Brown |
11 Sep 24 | Re: is Vax addressing sane today | 2 | | Thomas Koenig |
11 Sep 24 | Re: is Vax addressing sane today | 1 | | David Brown |
11 Sep 24 | Re: is Vax addressing sane today | 2 | | David Schultz |
13 Sep 24 | Re: is Vax addressing sane today | 1 | | David Brown |
11 Sep 24 | Re: is Vax addressing sane today | 5 | | John Levine |
11 Sep 24 | Re: is Vax addressing sane today | 4 | | Thomas Koenig |
11 Sep 24 | Re: is Vax addressing sane today | 2 | | Anton Ertl |
11 Sep 24 | Re: is Vax addressing sane today | 1 | | jseigh |
11 Sep 24 | Re: is Vax addressing sane today | 1 | | John Levine |
20 Sep20:35 | Re: is Vax addressing sane today | 9 | | Kent Dickey |
21 Sep00:00 | Re: is Vax addressing sane today | 4 | | MitchAlsup1 |
21 Sep03:09 | Re: is Vax addressing sane today | 3 | | Lawrence D'Oliveiro |
21 Sep03:52 | Re: is Vax addressing sane today | 2 | | MitchAlsup1 |
21 Sep10:17 | Re: is Vax addressing sane today | 1 | | Lawrence D'Oliveiro |
21 Sep03:12 | Re: is Vax addressing sane today | 4 | | Lawrence D'Oliveiro |
21 Sep03:51 | Re: is Vax addressing sane today | 3 | | MitchAlsup1 |
21 Sep09:56 | Re: is Vax addressing sane today | 1 | | Niklas Holsti |
21 Sep10:18 | Re: is Vax addressing sane today | 1 | | Lawrence D'Oliveiro |
9 Sep 24 | Re: is Vax addressing sane today | 69 | | Anton Ertl |
9 Sep 24 | Re: is Vax addressing sane today | 3 | | Michael S |
9 Sep 24 | Re: is Vax addressing sane today | 2 | | Anton Ertl |
9 Sep 24 | Re: is Vax addressing sane today | 1 | | Michael S |
9 Sep 24 | Re: is Vax addressing sane today | 1 | | Lawrence D'Oliveiro |
9 Sep 24 | Re: is Vax addressing sane today | 64 | | John Levine |
10 Sep 24 | Re: is Vax addressing sane today | 63 | | Anton Ertl |
10 Sep 24 | Re: is Vax addressing sane today | 62 | | Michael S |
10 Sep 24 | Re: is Vax addressing sane today | 61 | | Anton Ertl |
11 Sep 24 | Re: is Vax addressing sane today | 60 | | Lawrence D'Oliveiro |
11 Sep 24 | Re: is Vax addressing sane today | 59 | | Anton Ertl |
11 Sep 24 | Re: what's a mainframe, was is Vax addressing sane today | 19 | | John Levine |
11 Sep 24 | Re: what's a mainframe, was is Vax addressing sane today | 7 | | Stephen Fuld |
11 Sep 24 | Re: what's a mainframe, was is Vax addressing sane today | 6 | | John Levine |
11 Sep 24 | Re: what's a mainframe, was is Vax addressing sane today | 1 | | Stephen Fuld |
11 Sep 24 | Re: what's a mainframe, was is Vax addressing sane today | 1 | | Thomas Koenig |
12 Sep 24 | Re: what's a mainframe, was is Vax addressing sane today | 1 | | Terje Mathisen |
13 Sep 24 | Re: what's a mainframe, was is Vax addressing sane today | 2 | | Lynn Wheeler |
14 Sep 24 | Re: what's a mainframe, was is Vax addressing sane today | 1 | | Lawrence D'Oliveiro |
11 Sep 24 | Re: what's a mainframe, was is Vax addressing sane today | 1 | | MitchAlsup1 |
12 Sep 24 | Re: what's a mainframe, was is Vax addressing sane today | 8 | | Lars Poulsen |
12 Sep 24 | Re: what's a mainframe, was is Vax addressing sane today | 7 | | John Levine |
12 Sep 24 | Re: what's a mainframe | 1 | | Lars Poulsen |
12 Sep 24 | Re: what's a mainframe, was is Vax addressing sane today | 5 | | Lawrence D'Oliveiro |
13 Sep 24 | Re: what's a mainframe, was is Vax addressing sane today | 4 | | Terje Mathisen |
13 Sep 24 | Re: what's a mainframe, was is Vax addressing sane today | 2 | | Lawrence D'Oliveiro |
13 Sep 24 | Re: what's a mainframe, was is Vax addressing sane today | 1 | | Terje Mathisen |
13 Sep 24 | Re: what's a mainframe, was is Vax addressing sane today | 1 | | Lynn Wheeler |
12 Sep 24 | Re: what's a mainframe, was is Vax addressing sane today | 1 | | Lawrence D'Oliveiro |
13 Sep 24 | Re: what's a mainframe, was is Vax addressing sane today | 1 | | Lynn Wheeler |
11 Sep 24 | Re: is Vax addressing sane today | 35 | | Brett |
12 Sep 24 | Re: is Vax addressing sane today | 34 | | Lawrence D'Oliveiro |
12 Sep 24 | Re: big, fast, etc, was is Vax addressing sane today | 33 | | John Levine |
13 Sep 24 | Re: big, fast, etc, was is Vax addressing sane today | 1 | | Lawrence D'Oliveiro |
13 Sep 24 | Re: big, fast, etc, was is Vax addressing sane today | 6 | | Terje Mathisen |
13 Sep 24 | Re: big, fast, etc, was is Vax addressing sane today | 5 | | Thomas Koenig |
13 Sep 24 | Re: big, fast, etc, was is Vax addressing sane today | 3 | | Michael S |
13 Sep 24 | Re: big, fast, etc, was is Vax addressing sane today | 2 | | Thomas Koenig |
14 Sep 24 | Re: big, fast, etc, was is Vax addressing sane today | 1 | | MitchAlsup1 |
14 Sep 24 | Re: big, fast, etc, was is Vax addressing sane today | 1 | | Lawrence D'Oliveiro |
13 Sep 24 | Re: big, fast, etc, was is Vax addressing sane today | 1 | | Anton Ertl |
13 Sep 24 | Re: big, fast, etc, was is Vax addressing sane today | 23 | | Michael S |
13 Sep 24 | Re: big, fast, etc, was is Vax addressing sane today | 4 | | John Dallman |
13 Sep 24 | Re: big, fast, etc, was is Vax addressing sane today | 3 | | Michael S |
13 Sep 24 | Re: big, fast, etc, was is Vax addressing sane today | 2 | | John Dallman |
14 Sep 24 | Re: big, fast, etc, was is Vax addressing sane today | 1 | | Lawrence D'Oliveiro |
13 Sep 24 | Re: big, fast, etc, was is Vax addressing sane today | 3 | | MitchAlsup1 |
14 Sep21:17 | Re: big, fast, etc, was is Vax addressing sane today | 2 | | Michael S |
14 Sep22:42 | Re: big, fast, etc, was is Vax addressing sane today | 1 | | MitchAlsup1 |
13 Sep 24 | Re: big, fast, etc, was is Vax addressing sane today | 14 | | John Levine |
14 Sep 24 | Re: big, fast, etc, was is Vax addressing sane today | 6 | | Anton Ertl |
14 Sep 24 | In-memory database (was: big, fast, etc, was is Vax addressing sane today) | 5 | | Thomas Koenig |
14 Sep12:45 | Re: In-memory database (was: big, fast, etc, was is Vax addressing sane today) | 4 | | Anton Ertl |
14 Sep13:46 | Re: In-memory database (was: big, fast, etc, was is Vax addressing sane today) | 3 | | Thomas Koenig |
14 Sep14:48 | Re: In-memory database (was: big, fast, etc, was is Vax addressing sane today) | 2 | | Anton Ertl |
14 Sep15:41 | Re: In-memory database (was: big, fast, etc, was is Vax addressing sane today) | 1 | | Anton Ertl |
14 Sep 24 | Re: big, fast, etc, was is Vax addressing sane today | 1 | | Lawrence D'Oliveiro |
14 Sep22:32 | Re: big, fast, etc, was is Vax addressing sane today | 1 | | Michael S |
14 Sep22:57 | Re: big, fast, etc, was is Vax addressing sane today | 5 | | Lynn Wheeler |
14 Sep 24 | Re: big, fast, etc, was is Vax addressing sane today | 1 | | Lawrence D'Oliveiro |
13 Sep 24 | Re: big, fast, etc, was is Vax addressing sane today | 1 | | Lynn Wheeler |
11 Sep 24 | Re: is Vax addressing sane today | 2 | | Stephen Fuld |
11 Sep 24 | Re: is Vax addressing sane today | 2 | | MitchAlsup1 |
8 Sep 24 | Re: is Vax adressing sane today | 7 | | Brett |
8 Sep 24 | Re: is Vax adressing sane today | 2 | | MitchAlsup1 |
6 Sep 24 | Re: is Vax adressing sane today | 2 | | MitchAlsup1 |
6 Sep 24 | Re: is Vax adressing sane today | 1 | | Lawrence D'Oliveiro |
6 Sep 24 | Re: is Vax adressing sane today | 8 | | Anton Ertl |