Using MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity server

Re:Using MySQL as a NoSQL - A story for exceeding 750,000 qp... by jtdowney on Tuesday November 09, 2010 @07:32AM (#1886207)

Interesting that bypassing the SQL part of MySQL would increase performance by that much. In the comments he says that prepared statements would still be slower but it would be useful to see some numbers on his hardware to compare with.

[ Parent | on HN ]

Re:Using MySQL as a NoSQL - A story for exceeding 750,000 qp... by mike-cardwell on Tuesday November 09, 2010 @07:42AM (#1886227)

I agree that the figures would be useful. His response in the comments was reasonable though:

"Prepared Statement is still expensive in MySQL. It avoids SQL parsing, but it still has to open/lock/unlock/close tables, make query execution plans, etc."

[ Parent | on HN ]

Re:Using MySQL as a NoSQL - A story for exceeding 750,000 qp... by jamaicahest on Tuesday November 09, 2010 @10:47AM (#1886770)

The whole point of the article is to measure QPS, so I think it's fair to want numbers to back up that statement instead of speculating.

[ Parent | on HN ]