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 !