I'm trying to figure out for a friend what results in something like this

Restart the MySQL server and then run the query once. Then check the status variables.

Created_tmp_disk_tables = 0
Created_tmp_files = 362
Created_tmp_tables = 2
Sort_scan = 0
Sort_merge_passes = 0

What could be creating all those tmp files? It's not sorting on disk....

Learn how to extend your existing MySQL based website to leverage the power of MySQL variants, AWS cloud based MySQL deployments and RDBMS alternatives. Evaluate how to integrate and use these different various technologies such as MySQL based variations KickFire, a column based optimization and InfoBright, a data warehousing solution. Understand the means of approach towards data synchronization between various database solutions in your business.

At the MySQL Meetup in New York this month, I spoke on “Extending the MySQL Data Landscape“. A MySQL centric view on an earlier work, “The Data Landscape” which I presented at a recent GoDaddy Tech Day.

You can download the presentation on my Presentations page.

Good news!

DBD::mysql

I have a new co-maintainer who is going to help out with DBD::mysql, particularly with Windows build issues with Strawberry Perl. His name is Matthew Wilson. He "works part-time for a hedge fund maintaining predictive market models. " and I'm looking forward to working with him to improve DBD::mysql.

Things on the agenda for DBD::mysql :

* Build issues, particularly with Windows
* Any bugs that need fixing
* Change to a new SVN server, as well as get moved to Launchpad

Memcached Functions for MySQL

New release this week, 0.8. Numerous fixes, particularly to behaviors functions. They will work now!

Thats all for now. I'm in the middle of writting a book, so must get back to work!

Learn how to extend your existing MySQL based website to leverage the power of MySQL variants, AWS cloud based MySQL deployments and RDBMS alternatives. Evaluate how to integrate and use these different various technologies such as MySQL based variations KickFire, a column based optimization and InfoBright, a data warehousing solution.

So, a colleague ran into issues booking the Santa Clara Hyatt Regency Hotel—apparently there were no rooms with 2 double beds left for the MySQL 2009 Conference and Expo.

I could not imagine that the conference hotel would sell out so quickly!

The conference’s travel/hotel web page links directly to the online reservations page at http://santaclara.hyatt.com/groupbooking/clara2009orea.

I went there and did a little detective work. What I found was:

• When I chose Mon Apr 20 - Thu Apr 23, there were rooms with 2 double beds available.
  
• When I chose Sun Apr 19 - Thu Apr 23, there were rooms with 2 double beds available.
  
• When I chose Sat Apr 18 - Thu Apr 23, there were rooms with 2 double beds available. …

Most software changelogs list what’s changed and what bugs are fixed during each upgrade. But when you’re evaluating an upgrade, what you’re typically concerned about is slightly different — it’s a combination of what’s changed and what might have broken. The fixed bugs aren’t as important for most people, who are either using [...]

I just noticed that Fedora has updated their development repository to include MySQL 5.1:



Actually it's a pity that MySQL 5.1 didn't already make it into Fedora 10 since Fedora 10 was released on November 25, 2008, 2 days prior to MySQL 5.1.30. But it will most certainly be in Fedora 11.

Yepp, it's back again. By popular request, libmysqld is here with us again, having been off to attend other important library matters, whatever those are. But before I go on about this, let me tell what the heck I'm talking about, if you missed the neginning here.

MySQL can be embedded in your application, this is what is often called MySQL Embedded. If you are an ISV (Independent Software Vendor) or OEM (Original Equiment Manufacturer) then this should interest you. If you have never theard those acronyms before, then what this means is that you represent a company that, as part of some unique solution, integrates components from outside vendors. such as MySQL (and you you think that OEM in particular is a weird acronym, theen you are not alone, but this is historical).

Now, assume you build an application that might not be completely Open Source or use an license that is incompatible with GPL. So you have to use …

Mail services

dkim was added during the Intrepid release cycle. Work keeps being done by Scott Kitterman to keep the milter support up-to-date: dkim-milter, pymilter, pymilter-milters have been updated to the latest upstream version in Jaunty.

Virtualisation

Soren Hansen has uploaded a new version of the libvirt package. Amongst bug fixes the version available in Jaunty brings support for openvz. A patch to support opennebula has also been added but is not enabled yet. The related tool virt-viewer has also been updated and provides a Mozilla plugin package. The tools used to interact with EC2 have been updated to the latest version released by Amazon while the latest version of virtualbox-ose made its way to the Jaunty archive. The 2.1 version brings better support for 64 bit systems as well as full VMDK/VHD support including snapshots.

Collaboration tools

moinmoin has been updated to a new …

Background Knowledge

I have Windows Vista with Adobe Acrobat Professional v8.1.3 installed and I was trying to covert to Adobe PDF within Microsoft Publisher 2007.

Error Message

Acrobat PDFMaker reported the following error message dialog, “Adobe PDF Printer is not bound to Adobe PDF Port. Cannot proceed further. Kindly change the PDF Port to Adobe PDF Port in Adobe PDF Printer Settings”.

Solution

1. Go to Control Panel -> Printers.
2. Right mouse click on “Adobe PDF” and left click on “Properties”.
3. Left mouse click on “Ports” tab.
4. Uncheck mark the current port that is presently check marked. Place a checkmark on either “Desktop\*.pdf” or “Documents\*.pdf”. Ensure the description is “Adobe PDF Port”.
5. Left …