The Pythian Group added another feather to its cap today. Our Nicklas Westerlund passed his MySQL Cluster DBA Certification exam, making him part of an elite group of 57 MySQL Cluster Certified DBAs worldwide, and now two here at Pythian, the other being Augusto Bott. We have a wealth of hands-on experience setting up and maintaining the MySQL Cluster. Nick’s and Augusto’s certified creds make them our go-to guys for MySQL Clustering.
Congratulations, Nick!
Welcome to the 130th edition of Log Buffer, the weekly review of database blogs.
Oracle Blogs
Tanel Poder began a new series on Oracle memory troubleshooting with an introduction to his heapdump analyzer script.
Richard Foote asked, is it possible to shrink a newly created index? His answer? Just.
On the Oracle DBA and Apps DBA blog, Sabdar Syed also has a …
[Read more]Yesterday we announced the new release of the Gearman server, library, and UDFs, and now I’d like to provide a more useful example. This example assumes you’ve taken the steps to install the C server and MySQL UDFs as explained in that post, and now we’ll be using those pieces and the Perl API to show how to do URL processing. This could be used by a number of applications - anything where you have a URL, need to fetch it, possibly do some processing, and then store it somewhere (RSS feed cache, pulling links out of a HTML page, image conversion, …). In this example, MySQL is being used as the repository and “trigger point”, helping track the requests and results. Since we’ll be using Perl for our worker code, the first thing to do is install the Perl API from CPAN:
> perl -MCPAN -eshell cpan shell -- CPAN exploration and modules installation (v1.9205) cpan[1]> …[Read more]
We all know the usual UPDATE statement, for example:
UPDATE table_1 SET column_a1 = 57;
And if we want to update more than 1 column, we do this:
UPDATE table_1 SET column_a1 = 57, column_a2 = 37;
Or, assuming we are using something else than MySQL, we can do
this:
UPDATE table_1 SET (column_a1, column_a2) = (57, 37);
The last two statements do the same thing, but using slightly
different syntaxes (is that a proper word?), both in the SQL
standard, and both supported by most RDBMSs, but only the former
one by MySQL. Which really doesn't matter much, as these are just
two ways to express the same thing, and the two ways aren't
really that different.
An UPDATE statement with a subquery, where you use the subquery
to fetch the information for the new values for the updated
columns is not an uncommon operation. It can look like this, for
example:
UPDATE table_a SET column_a1 = (SELECT column_b1 …
EMC buys some, but not all, of SourceLabs. Cfengine launches data center automation software. Open source and TCO. Measuring corporate contributions to open source. And more.
Official announcements
Self-repairing Data Center Automation solution
released Cfengine
Acquia Joins Red Hat Exchange Bringing Social Publishing Expertise to the Open Source Ecosystem Acquia
DotNetNuke Moves to CodePlex DotNetNuke
The BitRock Network Service Improves Product …
[Read more]Earlier today, MySQL 5.1 was downloaded for the millionth time. Pretty cool! I wonder if we can find out who the lucky downloader is who got the millionth copy. Maybe we could embarass them with a MySQL logo prize or something at the MySQL Conference April 20-23 in Santa Clara.
Congrats to all those who created MySQL 5.1, to all our users, to the many who found, fixed or otherwise helped us chase down bugs. Thank you for making this a great release!
Error can’t create table … I was trying to add new table and alter another table to add new column and foreign key to the new table. Here’s basically what I had When I execute the code, I got an error message something like Error can’t create table … (errno: 150). It turned out that […]
A (slightly belated) Happy New Year to you! I just returned from my Christmas vacation two days ago, which I spent mostly at home and with my parents-in-law in St. Radegund, Austria. Now I am busy catching up with what has piled up during my absence (I managed to resist the temptation to check my work email during the time off).
Some MySQL-related news that came up in the past weeks and are worth sharing:
A (slightly belated) Happy New Year to you! I just returned from my Christmas vacation two days ago, which I spent mostly at home and with my parents-in-law in St. Radegund, Austria. Now I am busy catching up with what has piled up during my absence (I managed to resist the temptation to check my work email during the time off).
Some MySQL-related news that came up in the past weeks and are worth sharing:
Wohoo!
I just got word that the proposals I submitted for FOSDEM are
appoved! I was going to go to FOSDEM no matter what, and when I
saw Lenz
Grimmer's call for participation, I decided to give it a
go.
I'll be doing two talks:
Having the opportunity to do these talks adds to the fun, and I
feel honored for being given the chance. Thank you!
This year, Fosdem looks very promising for the MySQL crowd. Lenz
himself is …