The latest from the MySQL community

I've created a new community poll: Would you prefer InnoDB to be the default storage engine?, as I'm just curious how the community currently feels about this.

Of course, anyone can put --default-storage-engine=InnoDB (and --sql_mode=NO_ENGINE_SUBSTITUTION) in their my.cnf to accomplish the same, but... as a friend of mine has been asking me for years, it would make MySQL "ACID compliant out of the box" (e.g., by default) with no silent ignoring of transactions or foreign key constraints.

You can always specify the desired engine explicitly with CREATE TABLE ... ENGINE=...

One could say that it's about usability and ease-of-use for new users who don't yet know much about MySQL or its configuration. Did you know that the config wizard on Windows actually already sets the …

Dear Lazyweb, quick question: once I’ve USE-ed a database in MySQL, how can I un-USE it so I have no default database? Is it even possible?

Pimp My Drive by Richard and Barb

There’s remarkably little information online about using MySQL on ZFS, successfully or not, so I did what any enterprising geek would do: Built a box, threw some data on it, and tossed it into production to see if it would sink or swim.

I’m a Linux geek, have been since 1993 (Slackware!). All of SmugMug’s datacenters (and our EC2 images) are built on Linux. But the current state of filesystems on Linux is awful, and …

Hi,
I just pushed a version of PBMS up onto launchPad that works with any storage engine. 
The new version provides a set of UDFs and API functions that allow you to set triggers on longblob columns so that the table can be used with the PBMS engine the same way a PBXT table would.  
The following has been added to the API:

/* Functions used for non PBMS enabled tables. */

/*

 * pbms_init_udfs() 

 * Declares the PBMS UDFs on the server if they do not already exist.

 *

 * Equivalent UFD: NONE

 */

pbms_bool pbms_init_udfs(MYSQL *mysql);

/*

 * pbms_enabled() 

 * Returns 'true' if the 'engine' is PBMS enabled i.e. provides direct support for PBMS. 

 * So far the PBXT engine is the only PBMS enabled engine out there. …

One of the frustrations of of working in Certification is that so little time is spent creating exam questions. There are million other things from expense reports to mandatory training that need to be take care of before delving back into things like InnoDB buffer pools or scaling Falcon databases. The good news is that new exam questions are ready for the next generation of DBA Certification and I will soon be begging the folks who helped me in the past for one last look before we shrink wrap the exams.

I attended the CEdMA Conference this week and was able to network with other certification folks. One of the items of discussion was what goes into a certification package. In tight economic times, training and certification departments need to cut costs. Many certification entities are simply sending out PDF certificates via email. Others are concerned about rising costs for shipping t-shirts, pens, wallet-sized cards, certificates, …

Selling valuable products (not support) shows that Red Hat/JBoss won't let purists get in the way of evolving the open source business model. READ MORE

The 118th edition of Log Buffer, the weekly review of database blogs, has been published on Ward Pond’s SQL Server blog.

Log Buffer is the only platform-neutral, distributed, human-edited article on database blogs. It receives several thousand views each week, and publishing an edition on your own blog brings those views to you. Hosting an edition of LB also introduces you and your blog to your colleagues in the DB blogosphere. Write me an email and I’ll get you started.

Now, here’s Ward Pond’s Log Buffer …

SetupWe have one InnoDB file per table on our database, which was set with the following option: innodb_file_per_table.This allows me to portably transport Innodb files on a system level with minimal hassle, and is much faster than mysqldump, as these tables are several GB each.ProblemWhen transporting an .idb file from one server to another, I ran into the following error:ERROR 1030 (HY000): Got

So, I installed one of those math question anti-spam plugins for WordPress comments. It stopped the spam! Unfortunately it also stopped all valid comments when the answer was right, although it did work when I first set it up. So if you tried leaving a comment (I see a few were denied) for one of the recent Drizzle or MySQL related posts (like the New libdrizzle), please try again. :)

Anyone have a suggestion for a good anti-spam plugin for WordPress comments? I’ve looked a bit but nothing really stands out.

What does that mean? Should we wait two …