MySQL

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 - 09:21
database, MySQL
MySQL 5.5 is entering beta; some new exciting stuff.

It‘s been a long time, from my point of view, since MySQL was out with something exciting.
Since version 5.0 back in 2005 we mainly saw bug fixes. Version 6.0 is in development for years and I am not sure if it heads anywhere
(see the following post). So the following new article from MySQL was very encouraging.

haim 25/04/2010 - 09:51
ALM, Databases mysql, MySQL
musqldump (on slave) with --single-transaction option (for InnoDB)

 I got the following question from one of our customers.

 

”I have a question regarding mysqldump.

I am using the following scenario:

haim 04/01/2010 - 09:40
ALM, Databases mysql, MySQL
Is Oracle a good company to host Open Source like MySQL?

 I guess that since the acquisition of Sun, and as result MySQL AB, by Oracle every MySQL user had wonder if Oracle is a good hosting place to Open Source like MySQL.  Basically I am optimistic regarding the future of MySQL, but I think the community should stay alert and make sure Oracle know how match we care for MySQL.  So I am attaching a link to a post by Michael "Monty" Widenius, the creator of MySQL where he states his fears regarding the upcoming for MySQL and ask your support.

 http://monty-says.blogspot.com/2009/12/help-saving-mysql.html
 

haim 13/12/2009 - 22:04
Databases mysql, MySQL
MySQL Performance Blog

Though our application is now mostly Oracle oriented, I spent quite a lot of time with mysql. One of the sources for mysql information which I had frequently used (and I apologize if some of you are already familiar with it) is the "MySQL Performance Blog":

www.mysqlperformanceblog.com/2008/11/24/how-percona-does-a-mysql-performance-audit/

 

 

 

shlomo 30/04/2009 - 12:32
MySQL, MySQL, Java
Oracle To Buy Sun - Hold On To Your Hats

Oracle Corporation is to buy Sun Microsystems Inc. for $9.50 a share in a deal valued at $7.4 billion, just a few weeks after a deal by IBM to buy Sun fell apart. It looks like Oracle will pay a premium of $2.81 a share, or 42%, over Sun Micro’s closing price of $6.69 a share on Friday. Oracle said the deal is valued at $5.6 billion excluding cash and debt. Oracle is calling Sun’s Java “the most important software” it has ever acquired. The deal has massive implications for the future openness of Java and MySQL.

udid 20/04/2009 - 14:56
Java, MySQL, Newsflash, Solaris
Remotly dumping the content of RDBMS (Oracle. mysql etc)

Hi,

In our application we needed a tool that can remotly connect to any RDBMS using JDBC and dump the content of of the DB to a local file system.

I found http://henplus.sourceforge.net/ which was easy to install and I allready tested it with Oracle (both running on Linux).

if anyone has a similiar requirenment, I would be happy to help.

Shlomo.

shlomo 18/03/2009 - 08:17
dump, MySQL, MySQL, oracle, Java
My little open-source project - JDBC console

 This is intended to be used from shell scripts or ant or maven builds to execute SQL scripts. Also it allows to enter SQL commands in interactive mode. In addition to the source code, there is a pre-built binary including all major open-source database drivers. To use Oracle/DB2/MSSQL JDBC drivers you need to download them from the corresponding corporate site.

Hope to hear your feedback.

andrew 07/09/2008 - 09:17
JDBC, MySQL, Newsflash, oracle, Persistence, PostgreSQL, script, SQL Tools
Syndicate content