[dba-Tech] MemSQL Claims to be Fastest Database on the Planet - 80, 000 queries per second

Stuart McLachlan stuart at lexacorp.com.pg
Mon Jun 25 17:31:22 CDT 2012


Or JC's SQLServer/C++  system where he uses lots of RAM and SSDs

-- 
Stuart

On 25 Jun 2012 at 22:47, Gustav Brock wrote:

> Hi Arthur
> 
> Looks like an exact replica of Oracle TimesTen:
> 
> http://en.wikipedia.org/wiki/TimesTen
> 
> /gustav
> 
> 
> >>> fuller.artful at gmail.com 25-06-12 21:50 >>>
> Snippet from iProgrammer:
> 
> Two former Facebook developers have created a new database that they say is
> the world's fastest and a video to demonstrate its superiority compared to
> MySQL.
> 
> According to former Facebook developers Eric Frenkiel and Nikita Shamgunov,
> MemSQL, the database they have developed over the past year, is thirty
> times faster than conventional disk-based databases.
> 
> The team employed techniques they had used at Facebook to create a database
> that would be very fast. The key ideas are that SQL code is translated into
> C++, so avoiding the need to use a slow SQL interpreter, and that the data
> is kept in memory, with disk read/writes taking place in the background.
> 
> Shamgunov has excellent credentials in the database world, having worked at
> Microsoft on SQL
> Server<http://www.i-programmer.info/news/84-database/4397-memsql-80000-queries-per-second.html#>
> for
> six years. He also has several patents to his name, and is a world medalist
> in ACM programming contests.
> 
> MemSQL has put together a video showing MySQL versus MemSQL carrying out a
> sequence of queries, in which MySQL performs at around 3,500 queries per
> second, while MemSQL achieves around 80,000 queries per second.
> 
> This is, of course, impressive, but the question remains of how much of
> this was achieved by clever picking of the queries. What would be
> interesting would be to see MemSQL running some of the Transaction
> Processing<http://www.i-programmer.info/news/84-database/4397-memsql-80000-queries-per-second.html#>Performance
> Council (TPC) tests to see how it performs against known benchmarks.
> 
> The main reason that MemSQL achieves the speed it does is because of being
> memory based, with all the benefits and drawbacks in terms of size limits
> and potential data loss that carries.
> 
> The documentation says that MemSQL writes back to disk/SSD as soon as the
> transaction is acknowledged in memory, and that using a combination of
> write-ahead logging and snapshotting ensures your data is secure.
> 
> MemSQL is fully compatible with MySQL, giving a clue as to the target
> audience, and the website <http://memsql.com/> describing the product
> suggests that:
> 
> *"MemSQL handles terabyte-scale workloads by connecting MemSQL and MySQL
> nodes together, conferring real-time access for your most valuable data as
> well as long-term historical lookback". *
> 
> MemSQL runs on 64-bit Linux, and is described as ideally suited for
> machines with multi-core processors and at least 8 GB of RAM. There's a
> free developer edition that's limited to 10 GB in capacity, and a trial
> edition that supports unlimited storage but is time limited to 30 days.
> 
> So far, no details of the license fee for commercial use seem to be
> available. To visit the site click MemSQL <http://memsql.com/>.
> 
> -- 
> Arthur
> Cell: 647.710.1314
> 
> Prediction is difficult, especially of the future.
>   -- Niels Bohr
> 
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
> 




More information about the dba-Tech mailing list