August 6, 2012

Notes, links and comments August 6, 2012

I haven’t done a notes/link/comments post for a while. Time for a little catch-up.

1. MySQL now has a memcached integration story. I haven’t checked the details. The MySQL team is pretty hard to talk with, due to the heavy-handedness of Oracle’s analyst relations.

2. The Large Hadron Collider offers some serious numbers, including:

3. One application area we don’t talk about much for analytic technologies is education. However:

So how soon will budgets emerge for all this, especially in the United States? I’m not sure.

4. Recent posts with robust comment threads — and this is a very partial list — include:

5. Finally — and thoroughly superseding my post on disk, flash, and RAM — I saw an awesome round-up of latency numbers, which I’ll just quote below:

L1 cache reference …………………………………………………… 0.5 ns
Branch mispredict ……………………………………………………….. 5 ns
L2 cache reference ………………………………………………………. 7 ns
Mutex lock/unlock ………………………………………………………. 25 ns
Main memory reference …………………………………………… 100 ns
Compress 1K bytes with Zippy ……………………………… 3,000 ns
Send 2K bytes over 1 Gbps network …………………… 20,000 ns
SSD random read ……………………………………………….. 150,000 ns
Read 1 MB sequentially from memory ……………….. 250,000 ns
Round trip within same datacenter …………………… 500,000 ns
Read 1 MB sequentially from SSD* ………………… 1,000,000 ns
Disk seek ……………………………………………………….. 10,000,000 ns
Read 1 MB sequentially from disk ……………….. 20,000,000 ns
Send packet CA -> Netherlands -> CA ……… 150,000,000 ns

Repeating that in different units, it’s:

    L1 cache reference ......................... 0.5 ns
    Branch mispredict ............................ 5 ns
    L2 cache reference ........................... 7 ns
    Mutex lock/unlock ........................... 25 ns
    Main memory reference ...................... 100 ns
    Compress 1K bytes with Zippy ................. 3 µs
    Send 2K bytes over 1 Gbps network ........... 20 µs
    SSD random read ............................ 150 µs
    Read 1 MB sequentially from memory ......... 250 µs
    Round trip within same datacenter .......... 0.5 ms
    Read 1 MB sequentially from SSD* ............. 1 ms
    Disk seek ................................... 10 ms
    Read 1 MB sequentially from disk ............ 20 ms
    Send packet CA ->  Netherlands -> CA ....... 150 ms

Comments

Leave a Reply




Feed: DBMS (database management system), DW (data warehousing), BI (business intelligence), and analytics technology Subscribe to the Monash Research feed via RSS or email:

Login

Search our blogs and white papers


Warning: include(): php_network_getaddresses: getaddrinfo failed: Name or service not known in /home/dbms2cm/public_html/wp-content/themes/monash/static_sidebar.php on line 29

Warning: include(http://www.monash.com/blog-promo.php): failed to open stream: php_network_getaddresses: getaddrinfo failed: Name or service not known in /home/dbms2cm/public_html/wp-content/themes/monash/static_sidebar.php on line 29

Warning: include(): Failed opening 'http://www.monash.com/blog-promo.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/dbms2cm/public_html/wp-content/themes/monash/static_sidebar.php on line 29