We welcome everyone to Amsterdam where on Friday at 16:00 CET we will be giving a talk together with SpamExperts at the Open Source Conference 2011. The talk will be about MariaDB and how SpamExperts successfully overcame their problems with MySQL by migrating to MariaDB. The talk will focus on the MariaDB features that differentiate it from vanilla MySQL and an in-depth case study on SpamExperts and the problems they faced when deciding to migrate to MariaDB and a detailed overview of the actual migration process.  For more information about the conference, check out their website: http://www.opensourceconference.nl/

Just a friendly reminder to let everyone know you can still sign up for tomorrow's Open Discussion on Using MariaDB in commercial database projects provided by Monty Program and SkySQL.

You can register here:

http://www.skysql.com/news-and-events/webinars/mariadb-future-mysql-community-enterprise-open-webinar


When:

Thursday, December 8, 2011

11:00am ET, 8:00am PT, 16:00 UK, 17:00 CET, or 18:00 EET


Agenda & speakers:

Colin Charles, Chief Evangelist at Monty Program
When and why to use MariaDB in a commercial setting

Rasmus Johansson, COO at Monty Program
The offerings of Monty Program Ab and how to interact with us commercially
…

It is finally ready! The training course at least I have been waiting for since we started the company: A MySQL training course for Developers.  And this is not just another standard MySQL for Developers training course. Based on our previous experiences at MySQL AB, we wanted to create something different, with a better fit. We wanted to aim this MySQL training course more at developers who already have experience using SQL and MySQL instead of just focusing on teaching SQL basics. Sure, we still cover the SQL basics, however it's done quickly.  We focus more on the MySQL exceptions and how to optimize SQL on MySQL.  As a result, entire chapters are dedicated to query optimization in MySQL, choosing storage engines, replication and other things often related more to a DBA role, that we deemed to be important for an advanced MySQL developer. We have also added a large section focusing on solving complex problems with …

Monty Program and SkySQL invite you to an open discussion webinar on why MariaDB™ is the alternative and future of the MySQL® database, not only for the User Community, but also for the Enterprise.

Register for this webinar.

When:

Thursday, December 8, 2011

8:00am PT, 11:00am ET, 16:00 UK, 17:00 CET, or 18:00 EET

Agenda & speakers:

• Colin Charles, Chief Evangelist at Monty Program
  • When and why to use MariaDB in a commercial setting
• Rasmus Johansson, COO at Monty Program
  • The offerings of Monty Program Ab and how to interact with us commercially
• Kaj …

If you’re in Nuremberg Germany next week (November 15-17th) and have anything to do with Oracle or their products, then the DOAG (German Oracle User Group) conference is the place to be. I will be representing SkySQL Ab at the conference, giving a talk about the internal architecture of MySQL Cluster. The talk will look at the internals of MySQL Cluster and at the different processes that ensure the High Availability of MySQL Cluster. Beyond that, the talk will also look at how the data is stored on the data nodes, how different types of queries are resolved in the cluster, and how a primary key lookup is executed differs significantly from a tree index search. The talk will also look at the resources involved in resolving the queries.

So if any of the above sounds interesting come and listen to my talk in room Singapur at 13:00 on Tuesday!

Most of you are all aware of the lack of microsecond support in MySQL.

This has been a long-standing issue:

http://bugs.mysql.com/bug.php?id=8523

*cringe* .. sorry, just my normal reaction after seeing that bug, err feature request, again and again over the past 6+ years ..

However, I think many people do not realize that microseconds are supported by MariaDB in version 5.3+, which for all intensive purposes is a drop-in replacement for MySQL.

So if you need microsecond support for MySQL, you should definitely check out MariaDB.

“In MariaDB 5.3, the TIME, DATETIME, and TIMESTAMP types, along with the temporal functions, CAST and dynamic columns, now support microseconds. The datetime precision of a column can be specified when creating the table with CREATE TABLE”

Also:

“Generally, the precision can be …

This is a somewhat uncommon error, so I wanted to take a moment and post the error and an explanation in order to make it easier for those who run into this in the future.

The main error is this (full pasted below):

InnoDB: Assertion failure in thread 139838283589376 in file log/log0recv.c line 1094
InnoDB: Failing assertion: !page || (ibool)!!page_is_comp(page) == dict_table_is_comp(index->table)

Basically, this is what it can look like after a power outage. In fact, this is the only time I have seen it, but I won’t say that it is the only way you could encounter it.

How do I deal with this, you ask?

Well, the above error shows that the internal InnoDB dictionary is corrupt.

Unfortunately, in this situation, you must recreate the tablespace. And if you don’t have a current backup + binlogs, then that means you will also need to …

If you're one of those that thinks that HA is all about MySQL® Replication, or if you've tried to alter your tables to NDB to drink at the holy grail of shared nothing architectures, SkySQL has got a meet-up for you! Join Ivan Zoratti, SkySQL's Director of Field Services, at MySQL meet-ups in Seattle, San Francisco, and Boston where he'll cover old tricks and new tools for deploying highly available MySQL databases. The pizza's on us! Sign-up today:

Seattle, Monday, December 5th, 7:00PM
San Francisco, Wednesday, December 7th, 6:30PM
Boston, Monday, December 12th, 7:00PM

For Windows users, if you try searching the MySQL source code for various strings, you know you will often come up empty with the built-in Windows search.

It wasn’t too long ago and I was searching the source for “MALLOC_OVERHEAD”. My Windows search came up empty, and someone suggested I try grep for Windows.

Well, I downloaded it, extracted it to the location I wanted, and added the .exe to the $PATH.

Now I can grep away!

See the new results when searching for “MALLOC_OVERHEAD”:

C:\mysql-5.5\mysql-5.5>grep -r "MALLOC_OVERHEAD" .
./client/mysql.cc:   (longlong) 2*1024L*1024L*1024L, MALLOC_OVERHEAD, 1024, 0},
./client/mysql.cc:   REQUIRED_ARG, 16384, 1024, 512*1024*1024L, MALLOC_OVERHEAD, 1024, 0},
./client/mysqldump.c:   (longlong) 2L*1024L*1024L*1024L, MALLOC_OVERHEAD, 1024, 0},
./client/mysqldump.c: …

Back in January 2010, I wrote an article titled Proxy Trace : Tracing the Variables and Functions Available within MySQL Proxy.

That post was basically a lua script I posted which traces the steps of Proxy, outputting comments as it traverses through the various functions, and then outputs the names and values of [most of] the available variables available within Proxy.

That script worked fine with Proxy 0.7.2 and 0.8.0. It also works just fine with Proxy 0.8.1 (though you need to specify your admin settings in 0.8.1) and 0.8.2 (admin values not necessary).

However, I did go ahead and build it out a little further.

I did not add too much, but I did add the following (the full script, trace.lua, is provided at the end of this post):

• Outputs backends.type variable
• Expanded the rows returned outputs (returns more detailed row …