database

CUBRID - new kid in the block?

 So does anybody has an opinion on the subject? Their features look promising.

 

I also liked the way they advertised the performance relative to Oracle, MySQL and another DBMS I'm not sure about (most probably MSSQL or DB2, but only as a wild guess).

 

So they did not name the competitors, but from the configuration of the test you can easily guess that innodb_buffer_pool_size belongs to MySql, and configuration for versions 10g and 11g are talking about Oracle :-)

 

www.cubrid.org/benchmark_result

 

andrew 01/03/2012 - 18:00
database, Java
Using MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity server

http://yoshinorimatsunobu.blogspot.com/2010/10/using-mysql-as-nosql-stor...

 

A very interesting article as to how to gain high performance from mysql by not going through sql parsing. It seems that if the database fits in memory, then the parsing of the sql statements creates a very high overhead on the overall query handling. The author of the article created a plugin for mysql that accepts PK queries in a much simpler format and therfore does not incur the parsing overhead. He got to benchmark results that are better than memcached.

 

I wonder if using stored procedures for the query only (that is, without processing the results) will also create such gains?

ittayd 11/11/2010 - 10:21
database, MySQL
Syndicate content