memsql/bench
View on GitHub ↗ ★ 23 Python archived
MemSQL Benchmark Tools
4 mentions on Hacker News by 2 people: 0 stories, 4 comments · first 2012-06-27 · latest 2012-06-28
20082026
-
…sustained a higher throughput, resulting in more data inserted. Refer to the simulation code ( https://github.com/memsql/bench/blob/master/benchmark.py ) to see exactly what is going on. - We actually print information about row overhead…
comment by ankrgyl · 2012-06-28 · in Reading Between the Benchmarks: How MemSQL Designs for Speed and Durability -
Referring to https://github.com/memsql/bench/blob/master/sql_database.py , we use _mysql, not mysqldb. Here's some code that demonstrates: In [1]: import _mysql In [2]: c = _mysql.connect(host='127.0.0.1', user='root') In [3]:…
comment by ankrgyl · 2012-06-28 · in Reading Between the Benchmarks: How MemSQL Designs for Speed and Durability -
…well for a lot of small concurrent reads and writes. If you look at the benchmarking code: https://github.com/memsql/bench/blob/master/sql_database.py you will notice that there are a lot of queries like "fetch by pk/guid". The trade-offs…
comment by nikita · 2012-06-27 · in Reading Between the Benchmarks: How MemSQL Designs for Speed and Durability -
…each core 80% utilized. The number of inserts and queries can be easier explained when looking at https://github.com/memsql/bench/blob/master/sql_database.py , starting at get_games and ending at log. Every action is composed of one call…
comment by ankrgyl · 2012-06-27 · in Reading Between the Benchmarks: How MemSQL Designs for Speed and Durability