There is more than new versions and acquisitions happening in the MySQL world. A vendor-neutral consortium, Open Database Alliance, has been formed to become a hub for all activity related to MySQL. The open source community has been anxious about future of MySQL since Oracle’s aquisition of Sun was announced. [Continue]
The Oracle-Sun deal seems to be the new weapon in the hands of advocates of proprietary software. It was recently used in a presentation at a friend’s company, to prove that even the open source software was prone to lock-ins. The logic was that, just like proprietary products, MySQL‘s future was in danger because of its company. [Continue]
Bret Taylor, one of the founders of FriendFeed, explains how they use MySQL to store schema-less data. It is an insightful post not only because he explains why they chose MySQL, but also the limitations of their schema-less design over an RDBMS. And more importantly it illustrates The importance of modeling your data, even if it is to realize that it has flexible schemas, without thinking of what tools you will use.
That was not what was being expected. MySQL was touted to go public and Sun never seemed to be wanting to become a database company. But it has happened (press release), and Sun seems to be planning to come out with global support offerings for MySQL. [Continue]
In spite of using caching to improve performance of this blog, it was down today, but for a different reason. I kept getting the following error at the top of my all WordPress admin pages. [Got error 134 from storage engine] SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_approved = ‘spam’ MySQL error code 134 means access to a record that was already deleted, which indicates that the table was corrupted. [Continue]
MySQL has not had its native storage engine until recent times. It supported various engines like MyISAM, InnoDB and BerkleyDB through plugins and the users could choose one of them. Oracle acquired both, InnoDB and BerkleyDB through their purchase of Innosoft in late 2005 and Sleepycat in early 2006. [Continue]
Optimizing Open-Source Software for Intel Architectures is an excellent article on optimizations. As a case study it takes up optimizing MySQL, written in C++, using gcc. The optimization process can serve as a good guideline for optimizing any application on any architecture. [Continue]