Today I had a hard time dealing with mysql and transactions. Somehow my transaction has been committed in the middle of the statements. A short look into the manual revealed that there are SQL command that implicit commit a transaction. While I do understand that CREATE TABLE commits a transaction, I was surprised that LOAD DATA INFILE does it too!

And since I use the nice REPLACE INTO SELECT ... workaround found on mysqlperformanceblog (Hint: Always a great resource!) I had to upgrade my development mysql server because since version 5.0.28 LOAD DATA INFILE does not commit a transaction.

MySQL manual

Today I spoke on MySQL at PHP Quebec. Here are my slides.. It was a first time giving this presentation, so feel free to email feedback to morgan [[at]] mysql.com.

Database migration is an old favorite, so I'm looking forward on speaking again tomorrow!

Event Information

Topic:
Zmanda Management Console for Amanda Enterprise Edition

Date and Time:
Thursday, March 22, 2007 10:00 am
Pacific Daylight Time (GMT -07:00, San Francisco)

Panelist(s) Info:
Shailen Patel - Professional Services Engineer,
Dmitri Joukovski - VP of Product Management,
Ram “TK” Krishnamurthy - VP of Services and Support

Duration: 1 hour

Description:
The recently released Amanda Enterprise Edition 2.6, contains Zmanda Management Console [ZMC]. ZMC is a web-based services that is integrated with the Zmanda Network. This release also includes Amanda Rapid Installer, a very simple and easy to use installation mechanism that installs MySQL, PHP, Apache and all …

Reading last few days worth of planet MySQL and commenting on some entries as you can see. The post by Oli catches my attention. There is also PDF with more details available

Oli is saying you can use MySQL with Active Active Clustering and MyISAM tables if you follow certain rules like enabling external locking, disabling query cache and delayed key writes etc. This is as far as many articles on this point go, and in theory this is what should work. In practice however you should think about what exactly are you looking for with this setup.

Performance ? This configuration adds effectively global table locks besides extra overhead you get from external locking. Plus key cache have to be invalidated with remote writes which makes even less …

Looking at post by Konstantin Osipov we should finally get Query Cache working with prepared statements in MySQL 5.1

The interesting thing Konstantin notes it just took few days to fix it - I believe MySQL Support Team alone spent much more times explaining customers why is it not done or troubleshooting cases with wrong customer assumptions regarding this problems. I think I alone spent tens of hours in various cases related to this problem.

This is one thing MySQL Development Management could consider - if the thing is annoying and it does not take a long to fix it why not to go ahead and make it done instead of spending longer time explaining over and over again why this stuff is not high priority

This feature should help MySQL getting even better results in SpecJAppServer benchmarks as previously it was hard choice - if you want to have …

Send me your resume, and I'll hook you up with a job at Yahoo!

Specifically I'm looking for a mySQL DBA, with 64-bit Linux Experience.
If you have more sys-admin / development skills then actually DBA skills no worries, if your good I'll give you a crash course in how to tune / improve uses of mysql.


Send your inquires to

mysqldba1@yahoo.com

or comment on this blog.

We'd like to test few things in regards to MySQL and Innodb scalability with multiple CPUs but we seems to be short of boxes right now, all stuff we have access to is in production right now which makes it not good for benchmark.

Could anyone lend us access to the box with at least 4 cores running Linux or Solaris ?

As I wrote a few days ago in my blog, MySQL is participating in the Google Summer of Code 2007.

The application process for students has now been opened! You have just one good week of time to apply, as the window closes 24 March 2007.

To participate in MySQL Summer of Code,

1. Read my blog announcement on http://www.planetmysql.org/kaj/?p=89
2. Read Google’s Guide to the GSoC Web App for Student Applicants at …

Red Hat announces the release of Red Hat Enterprise Linux 5…Centric CRM updates its open source CRM…Unicon contributes additional code to the uPortal project…and more…

Red Hat Initiates Long-term Plan for Customer Value [Red Hat Enterprise Linux 5], Red Hat (Press Release)

IBM and Red Hat Announce New Development Innovations in Linux Kernel, IBM (Press Release)

OpenVZ Software Available Based on Red Hat Enterprise Linux 5, OpenVZ Project (Press Release)

Open Source Systems Management Leader Hyperic Announces General Availability of Hyperic HQ 3.0 Enterprise …

Red Hat earlier today announced the latest version of RHEL 5 in a series of live events worlwide in Germany and the US.  Since we work closely with Red Hat, I joined along with other open source partners and customers in San Francisco.  Red Hat execs Paul Cormier, Mike Evans, Brian Stevens and David Burney were on hand to provide an overview of what's new and what's coming in the future.

The newest flagship version is called RHEL 5 Advanced Platform, which includes quad-core CPU support, …