8 ms·
It depends on transactions obviously (among many other factors). MySQL would handle simple one-insert web-style ones pretty well. At the same time very simple (
by snaky 8y ago
It depends on transactions obviously (among many other factors). MySQL would handle simple one-insert web-style ones pretty well. At the same time very simple (but slightly more realistic) read-write transactions barely got 2500 tps on PostgreSQL with Xeons and SSDs with as low as 32 clients and almost no contention at all (https://blog.pgaddict.com/posts/performance-since-postgresql-7-4-to-9-4-pgbench https://blog.pgaddict.com/posts/performance-since-postgresql...). And all transactions were the same, and there were no long-lived ones, no distributed ones, and no rollbacks, and so on.
- qaq 8y agohttp://www.tpc.org/tpcc/results/tpcc_results.asp?print=false&orderby=tpm&sortby=desc http://www.tpc.org/tpcc/results/tpcc_results.asp?print=false....
- snaky 8y agoHow exactly TPC-C v5 synthetic benchmark transactions related to the Delta Airlines backend transactions? Yes, that's somwewhat toyish 'business application' sketch benchmark. The goal of any benchmark is to be the same for all participants to compare them - staying aside the question what exactly the results tell about one or another particular system.
- qaq 8y agoNo company outside of exceptional circumstances will give you their actual data and workloads so some generic data points are useful. It's also pretty obvious that number of transaction Delta is handling is few orders of magnitude less than say Walmart. To me the point that conventional RDBMS can not handle transactional workload of Delta sounds like total BS.
- qaq 8y agoYou do realise that it is a tiny box with really crappy SSD BTW? You can get an x86 box with 12TB RAM 200+ cores and RAID over a bunch of Enterprise NVMe SDDs for 350K.
- snaky 8y agoThat's nice, and you can get a 1,000,000 tps on the shelf POWER8 server if you wish (on simple select-only requests, after tuning and patching the PostgreSQL core by a couple of the best PostgreSQL hackers in the world - yes, using carefully crafted assembler, no less https://akorotkov.github.io/blog/2016/05/09/scalability-towards-millions-tps/ https://akorotkov.github.io/blog/2016/05/09/scalability-towa...). That wouldn't make that server competitor neither for IBM Parallel Sysplex, nor even for Oracle Exadata.
- qaq 8y agoOracle Exadata is not a mainframe which once more underscores the point of not having to use a mainframe.