Eat your own dog food. The latest development version of MySQL Workbench 5.1 successfully runs a pre-alpha snapshot of the MySQL Driver for C++ since a few weeks. Enjoy your pizza at my costs, Andrey (Hristov). I lost my bet. Less than five bugs have been found when migrating MySQL Workbench to Connector/C++.

MySQL Connector/C++ is now being used by two "internal customers": MySQL Workbench and MySQL Connector/OpenOffice.org. And our internal development version of Connector/OpenOffice.org runs on Connector/C++ as well. The preview version of Connector/OpenOffice.org was using the …

Yesterday we announced what the Waffle Grid project is.  Some people ignored it, others I am sure read it with curiosity, but i figure their is a small subset of folks out their who said: “WOW!!!  That is really cool.  I want a Waffle Grid now!”… I wonder if these are the same people who run out and buy the latest SSD harddrive because its fast and the latest nvidia card because they can one up all their friends…  To those who want it now, but do not know where to begin I let me give you a quick install tutorial.  Some of this already exists on the wiki, but hopefully I will make it clearer here.

Get two servers….  I will wait.

Eat your own dog food. The latest development version of MySQL Workbench 5.1 successfully runs a pre-alpha snapshot of the MySQL Driver for C++ since a few weeks. Enjoy your pizza at my costs, Andrey (Hristov). I lost my bet. Less than five bugs have been found when migrating MySQL Workbench to Connector/C++.

MySQL Connector/C++ is now being used by two "internal customers": MySQL Workbench and MySQL Connector/OpenOffice.org. And our internal development version of Connector/OpenOffice.org runs on Connector/C++ as well. The preview version of Connector/OpenOffice.org was using the …

After some discussions on the OpenSQLCamp 2008 conference we decided to move our development to Launchpad, to be in stream with other MySQL related projects.

We published our patches there https://code.launchpad.net/percona-patches, it is supposed to be main repository for the patches.

We advise to use Launchpad bug system to report bugs and also for feature requests.

Entry posted by Vadim | No comment

Add to: | …

I got some really awesome feedback from Giuseppe (the Data Charmer) in my preivous post and it gave me a few ideas I thought I would share. One of the really nice things he did in his article about partitioning was to test partitions with the ARCHIVE engine. His results were mixed (and, actually, so were mine), but I did want to give it a spin. Here is what I ended up with:

DROP TABLE IF EXISTS Logger;
CREATE TABLE `Logger` (
  `timestampOccurred` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `dateOccurred` date NOT NULL,
  `session` char(32) DEFAULT NULL,
  `host` varchar(255) DEFAULT NULL,
  `sslMode` enum('enabled','disabled') DEFAULT 'enabled', …

MySQL has long built a great database. It's increasingly also building a great database business.

MySQL made two big announcements on Wednesday, one product-related (the final release of MySQL 5.1) and the second licensing model-related (improvements to the subscription-only MySQL Enterprise Monitor service with Query Analyzer). Of the two, I believe the latter is the more important as it helps Sun to monetize the research and development investments it has been making in the MySQL product.

The product announcement is that MySQL 5.1 will ship on or before December 6. Sun announced MySQL 5.1 back in April, but now it's ready for release. MySQL 5.1 is not important because it adds transactions capabilities (MySQL has had this functionality for years), but rather because it augments MySQL's sweet spot: industry-beating scalability and …

By moving the sorting out of the database and back into the application, plus putting a limit on how many stories would be returned to any first request, Freund watched query execution time drop from an average 5.27 seconds down to 2.54 seconds. In other words, Clickability chopped 48% of the time it took to execute each query out of his overhead. The new tool "gave us a snapshot. We learned more about query usage in two minutes than we could gain in two years of ad hoc log analysis and guessing,"

http://www.informationweek.com/news/software/database/showArticle.jhtml?articleID=212100690

Sun considered a merger or acquisition with Apple on three occasions in the past ... is it time for Sun to open that door again? READ MORE

Wow, it's so cool when something you've worked and worked on finally sees the light of day and goes GA. There's lots in this release, but one of the area's I'm most excited about is the PHP support. Our editor teams produce awesome stuff, and this is no exception, IMHO.

Of course there is also the cool stuff we've done in the databases area:

• SQL code completion
• SQL history
• Editable, pageable results
• Export results as SQL INSERT statements
• Easy installation of Sakila sample database
  

Go get the bits, have fun.

Very interesting review of the new MySQL Query Analyzer that comes with MySQL Enterprise Monitor. I installed Quan (Query Analyzer) and within about 20 minutes it became clear I had a query that was averaging 14 seconds to run. This query doesn't get run all that often, every 5 minutes or so, but it uses a table that is the most active table on our system.

OK, click on the query and it pops up a full view, showing the query with literals replaced by place holders. If you have Example Queries configured, you can check to see if there is an example showing all of the data, and if you have Example Explain configured, you will also be able to …