I wanted to call out one database tooling feature in NetBeans 6.5 that I think is pretty cool, and it's a little bit hidden.

If you execute a query and you get results, you can then do a number of interesting things with them.



Things like show what the CREATE TABLE statement would look like, or copy and paste the data you have selected (the paste format is hard-coded right now, but next release we plan to support CSV and XML output).

The one I like the best is that you can generate INSERT statements for the data.



Combine this with generating the CREATE TABLE statement, and it makes it really easy to hand your data set to someone else for testing or collaboration.

One of the problems with living in times as they are now is the lack of funds for what I like to call non-directed autodidactic exploration. Some of you would call this 'investigating new tools' but most would call it getting 'toys'. How do you know if D-trace, the MySQL Query Analyzer, or the next new announcement is that new tool that you can not live without if you do not get a chance to live with it? In the past I was able to rig an old laptop, my new laptop and an old development system to play, er, experiment with MySQL Cluster before taking my Cluster DBA exam.

Cisco CCIE candidates end up with an expensive pile of routers, hubs, switches, and cables in preperation for their lab exam. I wanted to get back up to speed on Solaris and went hunting used hardware for Sparc system so I could learn all the new items added since the 2.5.1/2.6 …

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