Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 30 of 139 Next 30 Older Entries

Displaying posts with tag: Technical Blog (reset)

Installing Oracle VM Manager 3.2.x under Dom0 host
+0 Vote Up -1Vote Down

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

  [Read more...]
REMINDER – MySQL Community Dinner at Pedro’s 2013
+2 Vote Up -0Vote Down

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!

MySQL Community Dinner at Pedro’s 2013
+3 Vote Up -0Vote Down

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...]
About MySQL 5.6
+14 Vote Up -2Vote Down

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 test the fixes to old issues. 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. It was 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 happened 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 some time, and reviewed what Oracle delivered in this new MySQL release.

Short premise

Oracle developer teams

  [Read more...]
Quiet Release MySQL Plugin 12.1.0.1.2 — Bug Fixes
+1 Vote Up -0Vote Down

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

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


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



  [Read more...]
MySQL Oracle Connect 2012: Day Two
+1 Vote Up -0Vote Down

Another good day today: I attended the keynotes and found them quite interesting.

I especially liked the way Twitter uses MySQL to build up a NoSQL solution. Jokes aside, I took a few notes on things I must analyze and dig in.

The introduction of the Paypal models seemed very interesting, which brought me to attend the presentation later on. It was well constructed and had 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 attended the presentation done by Ronald B. It was good — nothing really advanced, but it was on purpose. He was very informative and explanatory for a junior MySQL DBA, and I enjoyed his presentation for the logical approach and construction.

Ronald also highlighted that it was the content of less then a chapter of one of his books and was done on purpose to

  [Read more...]
MySQL Oracle Connect 2012: Day One
+2 Vote Up -0Vote Down

I attend five sessions today, and I think that some of them were very interesting, like the one on the Optimizer insight. It was quite informative and accurate.

Another 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 things to accomplish in NDB is the correct dimensioning of the memory, buffers, possible operation, attributes, and so on. All these things should come from 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 missed a very important piece of information. When I raised the issue, Bernd mentioned that they were thinking of integrating that as well. It’s a good move, and I hope to see it soon. About the

  [Read more...]
MySQL Oracle Connect 2012 Keynotes
+1 Vote Up -0Vote Down

I’m excited to be here not only to catch up with old friends and ex-colleagues, but also to witness what seems to be the start of a very significant conference from MySQL.

I really enjoyed the introductions done by Edward Screven and Thomas Ulin. Edward highlighted the fact that MySQL is increasing its presence in the market and in the community. This could be thanks to the unbelievable effort done by Oracle in keeping its production cycle on target. Thomas stressed that point and gave a great description of it. He demonstrated Oracle’s main focus points, which are mainly on InnoDB, with implementation and enhancement of the internal contentions, then on Optimizer improvements and NoSQL integration.

Replication remains a pending issue from my side because if we have the global transaction ID, we still suffer from delay in replication given that parallel

  [Read more...]
Oracle OpenWorld 2012 – Bloggers Meetup
+0 Vote Up -0Vote Down

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 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...]
Announcing MySQL Plugin 12.1.0.1.0 for Oracle Enterprise Manager 12c Cloud Control
+1 Vote Up -0Vote Down

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 the initial beta of the plugin. It worked OK but didn’t use any of the new 12c 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...]
A Few Thoughts on OSCon and the Open Source Community
+1 Vote Up -0Vote Down

This past week I attended OSCon, the annual conference for open source’s true believers. And there was a religious 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 them 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...]
MySQL News
+0 Vote Up -0Vote Down

These past couple of weeks have been quite intense and generated a lot of news.

What stood out to me was the escalation in the race between MySQL/Oracle and MariaDB to be better. I have to say that all of us are benefiting from this competition. I am also not fully sure that Oracle would have put in such effort if Monty and his team was not pushing so hard. Certainly, Thomas Ulin has his agenda, but Monty is doing a great job for his product and in pushing the competitor to do his best. The result is that MySQL is becoming a better product day by day.

Thanks guys!

MySQL Internals

Is it a crazy idea to use MySQL for Json and HTTP embedded? I love crazy things, and this seems crazy, but it is closer to our reality than we can imagine:

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

What if MySQL had an HTTP interface and would reply JSON?


  [Read more...]
MySQL News – June 5
+0 Vote Up -0Vote Down

Stalls During DDLFaster DROP TABLE Courtesy of the InnoDB Team

Mark Callaghan mentioned a simple issue on DDL operation. I found the back porting interesting, but not always a possible option. I have nothing to comment on top of what was already stated there, but I’ll mention it because it is interesting to read.

Why do threads sometimes stay in ‘killed’ state in MySQL?

Customers often ask me (and I believe all MySQL DBAs can relate): “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 that the action

  [Read more...]
MySQL News (May 10, 2012)
+0 Vote Up -0Vote Down

This week has been rather calm.

I was busy with day-to-day work but had some spare time to use on simple implementations 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 started to dig a little bit more in the details of Mongo’s architecture, given the need to have it properly reviewed and implemented in parallel with MySQL installations. As for news and reviews, I was interested in a couple of articles:

Interesting article from Vadim about SSD. This is more of a suggested reading then one I can comment on.

What really makes me unhappy was the

  [Read more...]
Hardware Components Failures – Survey Results
+1 Vote Up -0Vote Down

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...]
Some Fun with MySQL’s History List
+0 Vote Up -0Vote Down

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 about some already present in 5.5. Most of them are well covered by people that certainly know more than me, so I read and read, but after a while became curious. I began reading the code and performing tests. I started to compare versions, like 5.1 – 5.5. – 5.6. One of the things I was looking for was how the new Purge thread mechanism works and what were its implications. I have to say that it seems to work better than the previous versions, and the Dimitry blog (see reference) seems to 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 behavior is with MySQL 5.5. This is because in 5.5 we have an

  [Read more...]
MySQL bi-weekly news 04/26/2012
+0 Vote Up -0Vote Down
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 [...]
YACR! (Yet another conference review!)
+0 Vote Up -0Vote Down
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 [...]
MySQLboy @ MySQL Conf 2012 [part 1/2]
+1 Vote Up -0Vote Down
MySQLBoy attends the annual MySQL Conference and Expo host by Percona. [part 1 of 2]
Percona Live MySQL Conference 2012 – Day 1 Review
+0 Vote Up -0Vote Down

Day 1 is the first official day of the Percona Live MySQL Conference. It began with two mini keynotes by Peter Zaitev and Baron Schwarz of Percona talking about the history of MySQL and his beginnings in the open source movement, respectively. It was very nostalgic, and I’m sure it brought a tear to a few people’s eyes.

Following the dynamic duo was full keynotes by Mårten Mickos (Eucalyptus Systems) 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. They felt far more like glorified sales pitches.

I

  [Read more...]
Percona Live MySQL Conference 2012 – Day 0 Review
+0 Vote Up -0Vote Down
Day 0 of the MySQL Conference was a day unlike any other day. It was, in fact, tutorial day. While regular days of the Percona Live MySQL Conference feature 50 minute sessions, usually split into a 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 be, but at the same time, we are limited to 2 tutorials slots per day instead of the 5 for sessions. 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 attended  [Read more...]
My Second day at MySQL Conference 2012 – third session
+0 Vote Up -0Vote Down
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) [...]
My Second day at MySQL Conference 2012 – first session
+0 Vote Up -0Vote Down
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 [...]
MySQL Conference 2012 – Keynotes on Day 2 (3)
+0 Vote Up -0Vote Down

A panel on “Future Perfect: The Road Ahead for MySQL“, by Brian Aker (HP), Paul Mikesell (Clustrix), Sundar Raghavan (Amazon), Slavik Markovich (McAffee), and Ori Hernstadt (Akiban).

If there’s one common theme to this panel and  this whole conference, it’s: “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.

There was an interesting distinction between the mindset of Oracle and of MySQL made by 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

  [Read more...]
MySQL Conference 2012 – The Keynotes (1)
+0 Vote Up -0Vote Down

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

The first keynote speech was by Peter Zaitsev, founder of Percona and a very smart guy, and by Baron Schwartz (Percona), another very smart guy, the brain 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 – the 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: He talked about his

  [Read more...]
Pictures from Pedro’s Dinner 2012
+0 Vote Up -0Vote Down

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

  [Read more...]
MySQL Conference 2012 Day 0
+0 Vote Up -0Vote Down

Wow! 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 MySQL.

  [Read more...]
Announcement: Release 1.1.2 of MySQL Plug-in for Oracle Enterprise Manager 10g/11g
+2 Vote Up -0Vote Down
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 [...]
Oracle Instance Memory Usage
+0 Vote Up -0Vote Down

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...]
Oracle OpenWorld 2011 — Bloggers Meetup
+2 Vote Up -0Vote Down
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 [...]
Showing entries 1 to 30 of 139 Next 30 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.