On 8 core Opteron Box we were able to achieve 275K inserts/sec at which time we started to see load to get IO bound because of log writes and flushing dirty buffers. I’m confident you can get to 400K+ inserts/sec on faster hardware and disks (say better RAID or Flash) which is a very cool number. Of course, mind you this is in memory insertion in the simple table and table with long rows and bunch of indexes will see lower numbers.
There are more caveats in the article. Not sure though how to compare this number with the 750k qps on the NoSQLish MySQL.
Original title and link: High Rate insertion with MySQL and Innodb (NoSQL databases © myNoSQL)