I wanted to compare the following DBs, NoSQLs and caching solutions for speed and connections. Tested the following Redis Memcached Tokyo Tyrant / Tokyo Cabinet MySQL 5.1.40 (MyISAM) MySQL 5.1.40 (with Innodb Plugin 1.0.4), compiled into source of MySQL My test had the following criteria 2 client boxes All clients connecting to the server using Python Used Python's threads to create concurrency Each thread made 10,000 open-close connections to the server The server was Intel(R) Pentium(R) D CPU 3.00GHz Fedora 10 32bit Intel(R) Pentium(R) D CPU 3.00GHz 2.6.27.38-170.2.113.fc10.i686 #1 SMP 1GB RAM Used a md5 as key and a value that was saved Created an index on the key column of the table Each server had SET and GET requests as a different test at same concurrency Results please ! read more

More...