Some of you know that I have published how to install Oracle VM Manager (OVMM) on a Dom0 host since Oracle released the Oracle VM 3. I have described why you possibly may want to do it in my very first post. Just want to mention here that it should be used for sandbox configurations only. You can find the previous post on how to install 3.1.1 OVMM version under Dom0 here. This time I talk about 3.2.2 version.

NOTE: At the time of writing ORACLE VM 3.2.3 SERVER (Patch 16410428) and ORACLE VM 3.2.3 MANAGER (Patch 16410417) became available. I didn’t have time to install the latest versions yet. However I do not

Friends,

I want to remind you, to let us know if you would like to come for the dinner at Pedro’s on Tuesday April, 23.

Actually ALL of you should come !

Pedro’s is asking us to have a better idea of the number of participants, so please go to this page “MySQL Community Dinner at Pedro’s 2013”

and subscribe.

We want to have all of you enjoy the evening with us, subscribe & come!

Once again, Pythian is organizing an event that by now may be considered a tradition: The MySQL community dinner at Pedro’s! This dinner is open to all MySQL community members as many of you will be in town for the MySQL Conference that week.

Here are the details:

What: The MySQL community pay-your-own-way dinner
When: Tuesday April, 23 – Meet us at 6:30 pm in the lobby of the Hyatt Santa Clara, or at 7 pm at Pedro’s (you are welcome to show up later too!)
Where: Pedro’s Restaurant and Cantina – 3935 Freedom Circle, Santa Clara, CA 95054
How: Comment on this blog post to add your name to the list of probable attendees

Pedro’s can handle large groups of people, but we would like to have an idea of

I am very excited and thrilled to use the latest release of MySQL 5.6 in production.

This is probably the most notable and innovative release in many years, if not ever.

During the last year, we had the chance to work with many new features and to test if the fixes to old issues were working fine.

To be honest, I was expecting to have MySQL 5.6 GA before now, and I even wagered with my colleague Francisco that it would be out before the end of 2012.

Nothing special just a beer in the Santa Clara Hyatt lounge.

Unfortunately for me, MySQL 5.6 is now in GA and given that it happen in 2013, I lost the bet and now have to pay for that beer.

But I have also lost the full list of things that we saw as relevant, interesting, or really innovative for MySQL.

So I took a step back, took my time, and reviewed what Oracle delivered in this new MySQL release.

This is just a small bug fix release of the plugin. It was actually quietly released for a while now of if you have downloaded the plugin recently, you have the latest version. To be sure — check the version in the Console or you will see it in the file name.

There are two bugs fixed:
1. Deployment on an OMS hosted on Solaris didn’t work (and suspect could be the same for Agents on Solaris).
2. Changing thresholds on the metrics caused an error “Modification of Target Monitoring Settings has Failed”. Also applying monitoring template was failing for the same reason.

If you did’t know that you can setup threshold and customized the thresholds that are set out of the box with the plugin then you are not using full capabilities of the Enterprise Manager. You can do that in the MySQL target menu — Monitoring -> Metric

Another interesting day today, I was attending the keynotes and I have found them quite interesting.

Specially the way Tweeter use MySQL to build-up a nosql solution, jokes a side I take few notes on things I must analyze and dig in.

Interesting one was also the introduction of the Paypal models, which brings me to attend the presentation later on. Presentation was well constructed and with some good theoretical work, but I was quite disappointed, I found the presentation incomplete, and missing real numbers for the MySQL Cluster NDB setup.

I attend the presentation done by Ronald B. it was good, nothing really advance, but on purpose. Very informative and explanatory for junior MySQL DBA, I enjoy it for the logic approach and the construction.

Ronald also highlight that it was the content of less then a chapter of one of his book, and done on purpose to give initial understanding of

I attend five sessions today and I think some of them were very interesting.

Like the one on the Optimizer insight, quite informative and accurate.

The other one done by the MySQL Cluster (NDB) group on the installer and new Javascript API interface, left me a little bit … foggy. Why? Because in my mind one of the most important thing to accomplish in NDB is the correct dimensioning of the memory, buffers, possible operation, attributes and so on, all things that should come from the review of the schema definition review and from the application analysis.

Now given the review analysis of the schema is still not present in the installer, I think that we miss a very important peace of information.

When I raise the issue, Bernd mention that they are thinking of integrating that as well, good move and I hope to see it soon.

About the

It is exciting to be here, meeting again old friends and ex colleagues, but also exciting for what seems the start of a very significant conference fro MySQL.

I really enjoy the introductions done from Edward Screven and Thomas Ulin.

Edward highlight the fact that MySQL is increasing his presence in the market and in the community.
This could be also thanks to the unbelievable effort done by Oracle in keeping his production cycle on target.

That part was really stress and well describe by Thomas, who show where the focus of Oracle is, mainly on InnoDB, with implementation and enhancement of the internal contentions, then on Optimizer improvements  and NoSQL integration.
Replication remain a pending issue from my side because also if we will have the global transaction ID, we will still suffer for delay in replication given that parallel

Oracle OpenWorld 2012 is just over a month away and yes we are organizing the Annual Oracle Bloggers Meetup — one of your top favorite events of the OpenWorld.

What: Oracle Bloggers Meetup 2012

When: Wed, 3-Oct-2012, 5:30pm

Where: Main Dining Room, Jillian’s Billiards @ Metreon, 101 Fourth Street, San Francisco, CA 94103 (

MySQL management plugin for EM 12c has been long overdue. I’ve initially migrated the older plugin to EM 12c about 6 months ago and few dozen people received this as initial beta of the plugin. It worked OK but didn’t use any of the 12c new features and its home page was a bit of a mess in the EM 12c Cloud Control web interface.

I’ve had lots of new features to add but I didn’t really have much time to invest into completing them all. Finally, I decided to just finish the home page dashboard and clean it up from all unfinished new features. I did, however, finish MySQL Slave configuration and status monitoring which was the largest gap in the the functionality of the previous plugin. There is no custom UI for MySQL slave

This past week I attended OSCon, the annual conference for open source’s true believers. And there was a religous fervor in the air, particularly from the point of view of someone more accustomed to Oracle conferences.

And if open source is the religion, proprietary closed-source companies are the devil. That having been said, I was surprised how virtually all large companies were demonized. Even long-time defenders of open source like IBM were ignored at best. That didn’t prevent the from coming though, with Microsoft and HP in particular with high-profile sponsorships and PR offensives that didn’t seem to have much influence with the crowd.

The companies generating buzz were the small companies built around development of their own open source products. There are a surprising number of them out

Quite intense couple of weeks, with a lot of news.

What I am really noticing is the escalation in the race to be better, between MySQL/Oracle and MariaDB.

I have to say that all of us are taking the benefit out of that, and that I am not fully sure that Oracle would have put the same effort, if Monty and his team was not pushing so hard.

For sure Thomas Ulin has is agenda, but still Monty is doing a great job, for his product and in pushing the competitor to do his best.

As said the results is that MySQL is becoming day after day a better product.

Thanks guys!

MySQL Internals

It is a crazy idea to use MySQL for Json and HTTP embedded?

I love crazy things and this seems crazy, but it is less far from the future then we can imagine:

“PoC: HTTP, JSON, JavaScript, Map&Reduce built-in to MySQL

What if MySQL had an HTTP interface

Simple issue that Mark Callaghan mentioned on DDL operation. I found the back porting interesting, not always a possible option, and the out-coming results.

Nothing to comment on top of what was already stated there, but mentioning it because interesting to read.

http://www.facebook.com/note.php?note_id=10150783146150933

http://www.facebook.com/note.php?note_id=10150826999790933

Why a Killed query do not disappear, after it was killed?
====================================

It happens to me, and I think to all MySQL DBAs, that a customer asks us, “WHY did that query remain in a KILL state, and does not go away?”.

As we know KILLed queries remain in MySQL until a clean up takes place, given

A calm week this time,
I was really busy on daily work, but had some spare time that I have use to do simple implementation and tests.

My work was related to Tablespace management in 5.6 and Table partition EXCHANGE, you can read the articles here .

I have also start to dig a little bit more in details on Mongo architecture, given the need to have it correctly review and implemented in parallel with MySQL installations.

As news review I was more interested in a couple of articles, as for below:

Interesting article from Vadim about SSD, more a suggested reading then able to comment.

On the other end what really makes me unhappy, was the

When preparing for the the IOUG Collaborate 12 deep dive on deploying Oracle Databases for high Availability, I wanted to provide some feedback on what hardware components are failing most frequently and which ones are less frequently. I believe I have reasonably good idea about that but I thought that providing some more objective data would be better. I couldn’t find and results of a more scientific research so I decided to organize a poll. This blog post shows the results and I promised to share it with several groups.

The results are also in the presentation material but it might be hidden deep into 100+ slides so here is the

Why this article?

First of all because I had fun digging in the code.

Then, I was reading a lot about the improvements we will have in MySQL 5.6, and of some already present in 5.5.

Most of them are well cover by people for sure more expert then me, so I read and read, but after a while I start to be also curious, and I start to read the code, and do tests.

I start to do comparison between versions, like 5.1 – 5.5. – 5.6

One of the things I was looking to was how the new Purge thread mechanism works and his implications.

I have to say that it seems working better then the previous versions, and the Dimitry blog (see reference) seems confirm that.

So again why the article? Because I think there are some traps here and there and I feel the need to write about them.

The worse behaviour is when using MySQL 5.5, and

Day 1 is the fist official day of the Percona Live MySQL Conference; the day began with two mini-keynotes by Peter Zaitev and Baron Schwarz of Percona talking about the history of MySQL and how he got started in the open source movement respectively. Very nostalgic and I’m sure it brought a tear to a few people’s eyes.

Following the dynamic duo was full keynotes by followed by Mårten Mickos (Eucalyptus Systems) speaking on “Making LAMP a Cloud” and Brian Aker (HP) on “The New MySQL Cloud Ecosystem”. To be honest I found the full keynotes to be quite disappointing. For me the keynotes speeches should be about a topic that is visionary or notable in some way. What I got from the keynotes were:  MySQL is good, MySQL is growing, let me show you my product around MySQL, and buy/use my product. For me, they felt far more like

A panel on “Future Perfect: The Road Ahead for MySQL”

Brian Aker (HP), Paul Mikesell (Clustrix), Sundar Raghavan (Amazon), Slavik Markovich (McAffee), Ori Hernstadt (Akiban)

If there’s one common theme to this panel, and indeed, this whole conference, it is “We’re hiring!” It is amazing how much talent there is at the conference this year and yet it isn’t enough. Pythian is hiring as well of course: http://bit.ly/pythianjobs

Interesting differenciation between the mindset of Oracle from MySQL from Brian Aker: database as a service, which is something MySQL seems to be getting to. It comes with its own problems especially around trust levels which will lead to more thinking around data security (rather than just database security)

MySQL vs. NoSQL. Different tools for different jobs

Security is definitely a big topic these days other than performance.

Here it is finally – the MySQL conference 2012 starts with the Keynote Sessions.

The first keynote speech is by Peter Zaitsev, founder of Percona and a very smart guy and also by Baron Schwartz (Percona), another very smart guy, the brains behind a number of toolkits for MySQL. They’re talking about the MySQL Evolution – what I alluded to in my first post regarding this conference – they ways in which MySQL has grown, evolved, scaled and continues to make new inroads into new applications and industries.

From Peter: “What is most important hasn’t changed – MySQL is still a great piece of technology and it is evolving very rapidly” (Love that quote!) Also “MySQL is also buzzword compatible: NoSQL, BigData”

From Baron: his own

A very well attended Pedro’s dinner – I didn’t count, but we had 9 tables of 8-10 people or so – dare I say almost a 100 people? Lots of beer, margaritas and good conversations! Here are a few pictures from the event

Wow what a lot has changed since the last MySQL conference I blogged about in 2007

MySQL has been acquired twice, once as MySQL by Sun and the second time around bundled with Sun when Oracle bought Sun. The conference is no longer organized by O’Reilly but by Percona. And the MySQL database itself has changed – We were talking about new features in MySQL 5.1, which wasn’t released yet, along with Falcon (where did it go?). 5.1 has long since been released as has 5.5 and we’re now talking about 5.6 instead of 6.0. There was no “Cloud” on the horizon, nor was there MariaDB, XtraDB, Drizzle, Schooner or any of the other offshoots of MySQL, all of which are creating a new buzz around the product.

Yet one thing remains constant – the vibrant community around

How much memory does my Oracle instance use? How much memory do my database connections use?

These are questions that can help with capacity planning of your server’s Physical and Virtual memory. There are several write ups out there on the web that attempt to address these questions. From what I could gather from them, there is only one truly good way to tell exactly how much memory is currently in use by an oracle instance (or any other system, http, mysql, etc), as well as the average memory usage for oracle dedicated connection processes.

This technique makes use of the “pmap” command. This command displays the real current memory usage of a process broken down by memory segment types. By parsing the output of pmap, we can make several useful calculations. Note that this command is available for Linux, Solaris and HP-UX servers. It is also apparently