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

  [Read more...]

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 from many years, if not ever. During the last year, we had the chance to work with many new features and to test if fixes to old issues were working...

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

  [Read more...]

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 [...]

I attend five session 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 [...]

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 [...]

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 (

  [Read more...]

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

  [Read more...]

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

  [Read more...]

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 [...]

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? [...]

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 [...]

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

  [Read more...]

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, [...]

Following a brief list of what I have found more interesting during the last two weeks. Up to now, April has being a great month for MySQL. MySQL Conference  – Percona conference 2012 The Percona MySQL 2012 conference, has seen the MySQL community, interact as it was doing many years ago, re-creating the dynamic and creative [...]

The journey to the Hotel in Santa Clara took me something like 16 hours. It was long, arduous and at times despairing, but was it worth it? Absolutely! I made the epic journey with my Pythian (and former Nokia) colleague Andrew Moore, and once at the conference we met up with more members of our [...]

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

  [Read more...]

Day 0 of the MySQL Conference is a day unlike any other day. It is, in fact, tutorial day. While regular days of the Percona Live MySQL Conference feature 50 minute sessions, usually split into 40 minute talk and a 5-10 minute question period, tutorials are 3 hour long sessions (with a generous 10 minute break in the middle for those that wish to go to the WC) that provide an in-depth dive into some aspect of MySQL. Due to the length of the tutorials, they are more in-depth and technical than individual sessions can provide, but at the same time we are limited to 2 tutorials slots per day instead of the 5 session slots per day. The tutorial schedule for the conference is located here and with so many good ones, it was hard to choose which one(s) to go to. For the morning session, I  [Read more...]

MySQL Cluster Performance Tuning ——————————————- In this session we will look at different tuning aspects of MySQL Cluster. As well as going through performance tuning basics in MySQL Cluster, we will look closely at the new parameters and status variables of MySQL Cluster 7.2 to determine issues with e.g disk data performance and query (join) [...]

Using and benchmarking Galera in different architectures ———————————————————- What I was interested most during the second day was again, synchronous replication and Replication solutions provide from Continuent. The first I attend in the day was the Galera one, done Henrik and Alexey. The presentation was going to talk about: “We will present results from benchmarking [...]

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

  [Read more...]

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

  [Read more...]

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

  [Read more...]

This release is just a quick bug fix release of an older 1.1.1 version of the plug-in. It’s long overdue but I’ve managed to fix “” problem only couple weeks ago. I’ve distributed the new version to the folks who have reached out to me by email of via blog reporting the issue in the [...]

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

  [Read more...]

Isn’t that that time of the year again? Yes, it is — it’s time for our annual Oracle Bloggers Meetup and of course Oracle is piggybacking OpenWorld with the meetup again! ;) What: Oracle Bloggers Meetup 2011 When: Wed, 5-Oct-2011, 5:00pm Where: Main Dining Room, Jillian’s Billiards @ Metreon, 101 Fourth Street, San Francisco, CA [...]

I’ve been following the development of Tungsten Replicator for quiet some time now, and recently was fortunate enough to find the time to take a look at the product in more detail. If you haven’t heard of Tungsten Replicator yet, it’s an open source database replication engine that can be used to complement or completely [...]